Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DropDown SQL issues
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01116632
Message ID:
01116655
Vues:
16
The cursor names are all unique:

combo1 - select ... pplans
combo2 - ... paplans
combo3 - ... splans
combo4 - ... saplans

Is there a point that I could debug to see if the cursors are ever being created at all. In other words, is there a way to tell if the cursors are just not being created as opposed to being created and then wiped out?

If i set a break point in the init of the control itself, would the cursor have been created at that point? I can't do it at the form's init because by then, they definitely don't exist.

>Are you using the same cursor name in all selects? The cursor names should be unique.
>
>>I have 4 combo boxes on a form. Each one is set to RowSourceType of 3 - SQL Statement. The RowSource is a valid SQL select statement with each box querying into a different cursor.
>>
>>In the init of my form, I run a method that tries to access some data in the 4 cursors. However, only the cursor from my first dropdown has been created. I can correct this by adding:
>>
>>
>>thisform.cboBox2.requery
>>thisform.cboBox3.requery
>>thisfrom.cboBox4.requery
>>
>>
>>in the init of my form. However, it seems like that should not be necessary.
>>
>>Is there something I'm doing wrong? What would keep those cursors from being created during the init of the control itself? Would a when or valid clause keep the control from creating the cursor during it's init?
>>
>>Thanks so much for your help!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform