>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
select @@identity as lastid
would return last identity assigned. However you might want to use IDENT_CURRENT too which returns last identity for a specific table (last by any session,any scope).
Cetin