Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem creating cursor
Message
De
20/04/2003 15:32:12
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem creating cursor
Divers
Thread ID:
00779629
Message ID:
00779629
Vues:
45
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform