Saturday, August 14, 2004

My workaround to Retrieve AutoInc Number using OLEDB

I am using ADO OLEDB to manipulate VFP8 table in ASP. I am looking a way to get last AutoInc Number after insert record to master table, and put it to child table as foreign key.

A new VFP9 function GettAutoIncValue() is what I am looking for. But, OLEDB for VFP9 is not available yet. For workaround, I give up the use of AutoInc Number data type in my table. I wrote my custom NewID() function and call it from ASP before I insert any master record.

Anybody has any other suggestion? Pls advise.

0 Comments:

Post a Comment

<< Home