Hi Fabio,

Yes, your code would work (I think) since you do a tableupdate and thus forces Visual FoxPro to add the row to the underlying table and that triggers the AutoInc.

My issue was, how can I get the AutoInc value via the view without having to commit the row?

As Tore pointed out, it looks like I may have to wait for VFP9.


Regards,

Mike


But, you are speaking about a autoinc about VFP8 or SQL Server?

VFP9 support SQL @@IDENTITY (perhaps).

If you want VFP8 new AutoInc, you must trigger the table.
If you want the last AutoInc value you can to use AFIELDS(),
but on a shared enviroment you must lock the table header.

A suspect, You want the new autoinc into the view before the tableupdate ?

Fabio