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