Re: How do I get the GUID value of a Record that I just Inserted ?

Vitali


Could you please give me an example on how this would be done, as I
have not been able to find any.

Thanks

Mark Moss



"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:43fb4084@xxxxxxxxxxxxxxxxxxxxxxxxx

"Mark Moss" <markmoss@xxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:43fb3e00$1@xxxxxxxxxxxxxxxxxxxxxxxxx
How do I get the GUID value of a Record that I just Inserted ?


DM.DataModule1.ADOCommand1.CommandText := 'INSERT INTO Customer ' +
'( CustomerID, CardNumber, NameLast, DateTimeCreated,
DateTimeUpdated )' +
' VALUES ('
+
'NEWID()'
+ ',' +
chr(39) + Hold_Customer_CardNumber +
chr(39) + ',' +
chr(39) + Hold_Customer_NameLast +
chr(39) + ',' +
'GETDATE()'
+ ',' +
'GETDATE()'
+
' )';

DM.DataModule1.ADOCommand1.Execute(Records_Affected, EmptyParam);


It Inserts the record correctly, but I do not know how to get the
GUID
Value for further Processsing

Mark Moss
How about generate this GUID on a client side so that you will know it
before insert?




.