Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When is a cursor NOT a cursor?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
When is a cursor NOT a cursor?
Miscellaneous
Thread ID:
00557517
Message ID:
00557517
Views:
55
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
Next
Reply
Map
View

Click here to load this message in the networking platform