vfp 9.0 autoincrement question & possible solution

Marcel Heitlager — Mon, 13 Aug 2007 15:22:08 GMT

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

RE: vfp 9.0 autoincrement question & possible solution

Trent L. Taylor — Mon, 13 Aug 2007 15:22:08 GMT

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. :)

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » vfp 9.0 autoincrement question & possible solution

vfp 9.0 autoincrement question & possible solution

RE: vfp 9.0 autoincrement question & possible solution