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


"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?


.