Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL - List Box - RowSource problem
Message
De
21/04/2006 16:40:12
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01115429
Message ID:
01115581
Vues:
8
Yuri,
I can put in the following code:
SQLEXEC(Ras2Conn, "SELECT Ras2_envelope.ENV_NO, Ras2_envelope.ENV_TOTL ;
FROM Ras2_envelope", "test")
SELECT test
BROWSE nowait
And browse the data; however, the following code (and the code you provided):
thisform.List1.columnCount=2
thisform.list1.RowSourceType= 3
thisform.list1.RowSource="SELECT ENV_NO, ENV_TOTL FROM Ras2_envelope"

results in a box that shows open tables (and there is none). It is apparently trying to open a dbf file.
Jerry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform