Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem creating cursor
Message
 
 
To
20/04/2003 15:32:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00779629
Message ID:
00779632
Views:
15
This message has been marked as the solution to the initial question of the thread.
Gaylen,

My guess is that VFP creates "filtered cursor". It may happend if condition in WHERE clause is Rushmore optimizable. That would explain why you didn't get an error with another table. The filter expression gets evaluated when record poiner is moved in the cursor. At that point it's running outside of form, so it cannot reference it with THISFORM. If you use local variable it goes out of the scope at this point. To force VFP to create persistent cursor add NOFILTER CLAUSE to the query.
Select * From deposits;
  WHERE policy_no = thisform.lnPolicyNo AND BETWEEN (dep_date,ldbegindate,ldenddate);
  Into cursor depositdetail NOFILTER
>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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform