Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting autoyield to .F. causes problems in working SQL code
Message
De
06/01/2000 15:27:31
Mary Dugan
Medeco Security Locks
Salem, Virginie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Setting autoyield to .F. causes problems in working SQL code
Divers
Thread ID:
00314109
Message ID:
00314109
Vues:
63
I am using a third party Active X Control from DBI Technology called Solutions Schedule 3.0. I first wrote code to query a database and then fill in fields in the control. This code worked fine until I set autoyield equal to .F. Now the code fails with the following error...

Alias 'COLS' is not found. Line #43

Any suggestions would be helpful. Thanks in advance.

This is the section of code that is failing...

SELECT Collections.col_date, Collections.employeeno;
FROM park!Collections;
WHERE ALLTRIM(Collections.route) = ALLTRIM(Sched.route);
ORDER BY Collections.col_date;
Into Cursor Cols

If Reccount("Cols") > 0

Go top

Do While !EOF()

*** THIS LINE EXECUTES SUCCESSFULLY ****
nBarID = Thisform.ctSchedule1.AddKeyTimeBar(nIndexID, ;
0, ; 1440, ;
Thisform.numdate(Cols.col_date), ;
Thisform.numdate(Cols.col_date), 0)

*** THIS IS LINE # 43 WHICH GENERATES
*** "Alias 'COLS' is not found."
*** WHEN autoyield is set to .F.

cHHNum = SUBSTR(TRIM(Cols.employeeno), ;
LENC(TRIM(Cols.employeeno))-2,3)
thisform.ctSchedule1.BarText(nIndexID, nBarID ) = cHHNum
thisform.ctSchedule1.BarTextAlign(nIndexID, nBarID ) = 2

nCount = thisform.ctSchedule1.AddBarStyle(20, 0)
thisform.ctSchedule1.StyleBackColor(nCount) = RGB(0,255,0)
thisform.ctSchedule1.BarStyle(nIndexID, nBarID ) = nCount

SKIP IN Cols
ENDDO
ENDIF
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform