Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comboboxes and Requerying
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Comboboxes and Requerying
Miscellaneous
Thread ID:
00123475
Message ID:
00123475
Views:
58
I'm really stuck with the following problem :

I am using comboboxes in my program. The Rowsource of the combobox is an
SQL-STATEMENT. When I run the program I sometimes get the message 'Cannot
access the selected table' followed by the error message ' Error
Combobox1.Requery '

In the following text, you can find the properties of my combobox. The
controlsource is a property of my Application class.

BoundColumn = 2
RowSourceType = 3
RowSource = "this.sqlselect"
ControlSource = "oApp.FiltGnsmTheraIndex"
Height = 25
Left = 192
Style = 0
Top = 76
Width = 217
ZOrderSet = 5
Name = "Okcombobox1"


PROCEDURE sqlselect
DO CASE
CASE oApp.clanguage = "N"
SELECT oms, tcode FROM Therapeutische_index ORDER BY oms INTO CURSOR
cthera
CASE oApp.clanguage = "F"
SELECT omsf, tcode FROM Therapeutische_index ORDER BY omsf INTO
CURSOR cthera
OTHERWISE
SELECT oms, tcode FROM Therapeutische_index ORDER BY oms INTO CURSOR
cthera
ENDCASE
ENDPROC


PROCEDURE Destroy
*-- Destroy the alias created in the RowSource property
IF USED("cthera")
USE IN cthera
ENDIF
ENDPROC


I hope anyone can help me !

Thanks a lot.
Next
Reply
Map
View

Click here to load this message in the networking platform