I have VFP8 SP1 application running under Windows Terminal Services
in a 4 processor computer running in Windows Advanced Server .
I have always VFP._autoyield=.F.
I have a lot of commands like
SELECT ... INTO CURSOR DOKSUMMA
...
The errors related to a missing cursor DOKSUMMA started to appear
suddenly if I added a lot of data to my databases.
It occurs at random times in different users. I have line debug info turned on and found that it usually occurs in the same lines of source code.
Those errri will not occur in other sites.
From the Sergey Berezniker and Aleksey Tsingauz messages in other
thread I understood that this may be VFP name table bug.
Please suggest what I should to:
1. Does upgrading to VFP9 or downgrading to VFP 7 fix it ?
2. Will adding the commands
LOCAL DOKSUMMA
DOKSUMMA = .F.
before SELECT as Aleksey suggested fix this ?
LOCAL command already initializes DOKSUMMA so is the second line required ?
3. James R. Nelson wrote in message 978848 that closing the cursor
before re-creating it and adding READWRITE clause helps at this moment.
I analyzed log file in one day from 10:14 to 19:57 and found 10 errors.
Error
23/23 /0 13:Alias 'DOKLSTL' is not found.
occurs 3 times at the same line in code
Error
93/93 AJUTASU/1 1:File 'doksumma.dbf' does not exist.
occurs 2 times in the same line of code.
All remainin 5 errors occured 1 times.
Errors from a log file:
1. 10:14:38 *IRINA 22/22 /0 13:Alias 'DOKLSTL' is not found.
DOCLISTLGL.REMOTEFILTERCHANGE F:\DOK\DOCLIST.SCT
2. 10:18:26 *IRINA 32/32 RID_/-1 1:File 'doklstl.dbf' does not exist.
DOKGL.DOCUMENT1.GETSTATIST F:\VFPE\BUSINESS.VCT
3. 10:29:57 *IRINA 23/23 /0 13:Alias 'DOKLSTL' is not found.
DOCLISTLGL.REMOTEREFRESH F:\DOK\DOCLIST.SCT
4. 11:05:08 *IRINA 9/9 /0 1586:Function requires row or table buffering
mode.
DOKGL.DOCUMENT1.BEFOREPOSTINGSINGLEDOCUMENT
BUSINESS.VCT
5. 11:17:04 *IRINA 23/23 /0 13:Alias 'DOKLSTL' is not found.
DOCLISTLGL.REMOTEREFRESH F:\DOK\DOCLIST.SCT
6. 12:43:56 *IRINA 23/23 /0 13:Alias 'DOKLSTL' is not found.
DOCLISTLGL.REMOTEREFRESH F:\DOK\DOCLIST.SCT
7. 14:34:23 *IRINA 93/93 AJUTASU/1 1:File 'doksumma.dbf' does not exist.
DOKGL.DOCUMENT1.LEIATASUTUDKURSOR BUSINESS.VCT
8. 15:00:51 *KAI 93/93 AJUTASU/1 1:File 'doksumma.dbf' does not exist.
DOKGL.DOCUMENT1.LEIATASUTUDKURSOR
F:\VFPE\BUSINESS.VCT
9. 19:53:51 *MARGE 292/292 TAITMATA/1 13:Alias 'DOKSUMMA' is not found.
DOKGL.DOCUMENT1.POST D:\SHARE\EEVA\VFPE\BUSINESS.VCT
10. 19:57:08 *MARIANN 651/651 DLAUS/1 24:Alias name is already in use.
DOKVL.DOCUMENT1.CREATEDLAUSEND BUSINESS.VCT
Andrus