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

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


.