Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select Time out?
Message
De
01/04/2003 13:33:16
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00766479
Message ID:
00772572
Vues:
18
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform