I have implemented a primary key generation schema using the commonly used "NextID" Stored procedure. This procedure checks to see if the table with the primary keys is open. If ! USED(), the procedure opens this table via the (USE) command. This works fine when a vfp application is accessing the data natively through vfp. My problem is that the newest odbc driver for vfp does not support the (USE) command. Does anyone have a Nextid Procedure that works via odbc?
Thanks.
Steve Summers
vsummers@email.msn.com
Thanks in advance or I hope this helps!
[STS]
:>