Hi George,
Unfortunately, you cannot use autoinc with ODBC because ODBC doesn't support any new VFP7 and later features. If you're calling this stored procedure from ASP only, you don't have to save and restore a work area at all.
>Sergey -
>
>I tried changing it from LOCAL to PRIVATE. No change in behavior.
>
>Now, we're up to lnSelect3. That fixed it for another couple of days. The only lasting (weeks to months) solution is to re-boot the server.
>
>Could we somehow change the server to 8.0? The code is in a stored procedure in the .DBC. It is code for creating an auto-increment field, using FoxPro (opens an ID table, locks it, increments it, unlocks it, returns value, etc.) If we could change their data to 8.0 data, we could just make the field "auto-Increment", right?
>
--sb--