Access 2000

[ABC]

Hi,
I am using Access 2000 as backend and VFP 5 as frontend.

Using SQLEXEC function to insert a row in access table.
This table has an AUTONUMBER field set to 'Increment'.

Now how to determine the value of this field for the newly
addedd record ?

 

[Alastair MacFarlane]

The simplest way would be to create a query that returns
the last number and return the value to a variable in your
VFP project.

SELECT TOP 1 mailtrac.ID
FROM mailtrac
ORDER BY mailtrac.ID DESC

Use an ADO connection to do the rest...

Alastair