Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem creating cursor
Message
From
20/04/2003 15:32:12
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem creating cursor
Miscellaneous
Thread ID:
00779629
Message ID:
00779629
Views:
44
I am getting an error message using the following code
Select * From deposits;
WHERE policy_no = thisform.lnPolicyNo AND BETWEEN (dep_date,ldbegindate,ldenddate);
	 Into cursor depositdetail 
After the cursor is created and I try to view it in the data session menu option an error message comes up and says 'object is not contained in a form'. Instead of using a form property, I tried using a variable in the where clause and named it "lnPolicyNo" and I get an error message about can't find variable "lnPolicyNo".

Interestingly in the same method I created another cursor from another table and used the same variables in the where clause and did not have a problem with it.

Any ideas on what is happening.

Gaylen
Next
Reply
Map
View

Click here to load this message in the networking platform