"Martin Eder" wrote: >This is a multi-part message in MIME format.>>------=_NextPart_000_0010_01C07707.14E4F6C0>Content-Type: text/plain;> charset="iso-8859-1">Content-Transfer-Encoding: quoted-printable>>Anyone know of an easy way to obtain a primary autonumber key from a =>newly inserted record ??>>Martin>>------=_NextPart_000_0010_01C07707.14E4F6C0>Content-Type: text/html;> charset="iso-8859-1">Content-Transfer-Encoding: quoted-printable>> HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">>>content=3D"text/html; =>charset=3Diso-8859-1">>name=3DGENERATOR>>>>>
face=3DArial size=3D2>Anyon e know of an easy way to obtain a =>primary=20>autonumber key from a newly inserted record ??
>
size=3D2>
>
Martin
>>------=_NextPart_000_0010_01C07707.14E4F6C0-->
Yes, for MS SQL7 modify the EasySQL vi to execute the SQL command 'SELECT @@IDENTITY' the query results will contain the identity of the inserted row.
