Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
When is a cursor NOT a cursor?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
When is a cursor NOT a cursor?
Divers
Thread ID:
00557517
Message ID:
00557517
Vues:
53
Argh!

I'm using VFP7. I'm creating a cursor, then trying to use it again in a SELECT:
CREATE CURSOR Attend(Attender C(8))

FOR i=1 TO lnVars
	INSERT INTO Attend(Attender) VALUES(laAttenders[i])
ENDFOR
This does indeed create a cursor, with several records - but then:
SELECT Attend.*, SchedContribs.UserCode, RECNO('SchedContribs') AS Recordnum ;
	FROM Attend ;
	OUTER JOIN .\Extranet\SchedContribs ;
	ON Attend.Attender=SchedContribs.UserCode ;
	WHERE SchedCode=lcSchedCode ;
	INTO CURSOR TQuery
Reports: "Alias 'ATTEND' is not found." - Even though my data environment clearly shows a workarea with that name (which I can browse). I've tried using DBF('Attend') instead, with the same results.

Any ideas?

TIA
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform