Ah ... sorry no.... whjat that does is return the autonumbered primary key when you execute it just after an insert
>Will this really return list of primary key fields of a table?
>
>>
>>You can try
>>
>>select @@identity
>>
>>
>>You should get the Autonumber field of the record you just inserted.
>>
>>It works for me in Vb.net using ado.net. I connect via oledb, not sure how relevant that is.
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.