>I know this question has been asked a dozen times before, but I can't seem to locate the answer.
>
>My SQL table auto-generates a GUID primary key for newly inserted records. Is there a way for me to grab that value during or after my insert statement?
>
>TIA
Hi not sure If the right way and if this is the way u are looking for but works for me
SQLExec(han,"declare @myvar uniqueidentifier "+;
"set @myvar = newid() "+;
"insert into <mytable> (guid_colmn,anotherfield) values(@myvar,'abcd') " +;
"select @myvar","theguid")
HTHs
suhas