Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A combo with the rowsourcetype = SQL Statement
Message
De
05/10/2009 13:10:09
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
A combo with the rowsourcetype = SQL Statement
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Divers
Thread ID:
01427773
Message ID:
01427773
Vues:
135
Hi All:

I have a combo class with the rowsourcetype = SQL Statement.

The statement reads thus:
sele dist Cde from itlook where cnatable = 'PRTDISP' into curs "Z"+ substr(sys(2015),3,10)
The itlook table contains two possible values, 'Display' or 'Print'.

This problem started when I wrote the init method:

In the init I have:
this.Value = 'Display'
In some forms that use this combo, I'm getting the following message when instantiating the form:
Cannot access the selected table
It then appends the SQL code.

Again, This problem started when I wrote the init method.

What gives?

Yossi
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform