Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Time out?
Message
From
01/04/2003 13:33:16
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00766479
Message ID:
00772572
Views:
19
Hi Sergey and Mark,

The query execution creates and destroys too many temporary cursors, this causes name table overflow and the name for result gets removed from there.
As a workaround you can declare local variable with the same name that should be in scope while query is executed.
LOCAL GebRec as Integer

*! Afkalvingen en droogzetten wordt niet gecheckt op aanwezigheid
Select gb.nRecId, Max(gb.dModify) As dModify ;
 From Gebeurtenissen gb ;
 Inner Join GebCodes gc On gc.nRecId == gb.nRecId ;
 Inner Join Dieren dr On dr.cdd204100 == gb.cdd204100 ;
 Where dr.ndd200087 == lnUBN;
 And IIf(gb.nType == 1 And InList(gb.nCode, 1, 5), .T., flAanwezig(gb.cdd204100, gb.ddd201736, lnUBN)) ;
 Group By gb.cdd204100, gb.ddd201736, gc.ntype, gc.ncode ;
 Order By gb.cdd204100, gb.ddd201736, nVolgNumme ;
 into cursor GebRec

?"gebRec", STR(SECONDS()-lnSec,6,2), ALIAS()
lnSec = SECONDS()
Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform