>I'm using VFP 6 and SQL 2000. Almost all SQL tables have an identity column for the pk. When I add a new record to a view, is there a direct way to retrieve the PK value that was assigned by SQL? I currently do some pretty serious gyrations to pull it off. Must be a quicker way...
>
>TIA
You can retrive the SQL Servers global variable @@IDENTITY or SCOPE_IDENTITY()/ IDENT_CURRENT() functions value. See in BOL wich one is appropriate in your situation.
--sb--