Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DropDown SQL issues
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01116632
Message ID:
01116655
Views:
17
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform