Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL - List Box - RowSource problem
Message
De
21/04/2006 11:50:52
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SQL - List Box - RowSource problem
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01115429
Message ID:
01115429
Vues:
64
I am trying to connect a VFP list box with a SQL database. When I run the program, it tries to open a dbf file. Additional info:

thisform.List1.RowSourceType=3
thisform.list1.ColumnCount=2
thisform.list1.RowSource="SELECT ENV_NO, ENV_TOTL FROM Ras2_envelope where env_no < 10 into cursor temp"
thisform.requery()

I can add the following code that will give me the info in the browse window.
SQLEXEC(Ras2Conn, "SELECT ENV_NO, ENV_TOTL ;
FROM Ras2_envelope", "test")
SELECT test
BROWSE nowait

Any help will be appreciated.
Jerry
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform