Access 2000

  • Thread starter Thread starter ABC
  • Start date Start date
A

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 ?
 
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
 
Back
Top