Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comboboxes and Requerying
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Comboboxes and Requerying
Divers
Thread ID:
00123475
Message ID:
00123475
Vues:
57
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform