Steve,
If you use only SQL statements to access your tables in your key generator program then you ***won't*** need to use the USE command nor the USED() function. The SQL statement will open the tables as they are need it.


>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