Sergey -
Thanks for the pointer to the webpage. I guess we WILL have to re-bott the server periodically (until we upgrade them to 8.0).
- George
>George,
>
>This problem is listed as fixed in VFP8. See
INFO: Miscellaneous Problems Fixed by Visual FoxPro 8.0 mskb #
818179.
>
>>Hello, all!
>>
>>We are getting a strange error at our client's site.
>>
>>SOME BACKGROUND:
>>They have a web page, which we set up. It looks at some VFP6.0 data, and occasionally adds some records. When it adds records, it calls our intid.prg (which assigns a new integer ID to the record) via ODBC. Here's the program:
><snip>>
>>THE PROBLEM:
>>All works fine, for a few months or so. Then, a few weeks ago, they started getting the following error (as seen in the browser):
>>
Illegal redefinition of variable "lnSelect"
>>Re-booting the server makes the problem go away.
>>Today, the problem cropped back up. Instead of re-booting the server, we changed the LOCAL line to:
>>
>>LOCAL lnSelect2, liReturnValue2, laJunk2(1)
>>
>>And changed the variable references throughout the PRG. All is working fine again.
>>
>>Will we need to re-start the IIS every few weeks? Hope not.
>>
>>THE SOLUTION:
>>[You need to fill this in, as we are stumped!]
>>
>>Thanks!
>>
>>- George [Scratching our heads in confusion.]