As pointed out in another post, vfp doesn't support @@identity.  I did some research on this and found that the vfpoledb provider version 9.0 does support "GETAUTOINCVALUE(0);" (version 8 doesn't).  With the 0 parameter it is supposed to provide the exact same functionality as @@identity provided you call executescalar before closing the connection. 

So I added a KeepConnectionOpen protected property to the dbdatasourceitem class.  In the UpdateRow function  I added the line KeepConnectionOpen = True if loCommands(1) exists (we have autoincrementing table).  In the internalexecutenonquery() function of the dbDataSourceItem class I check for that value so it won't allow it to close the connection if we have an autoincrementing field.  After that I set KeepConnectionOpen = False. So far this seems to work.

Is there anything that I might have overlooked? It seems like a simple solution.

Thanks,

Marcel

 

No.  Thanks for the information.  We have not tested that, so like anything else, you may want to make sure that you do not have any issues when there are multiple-users hitting the file at the same time.  That would be my only caution.