Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - List Box - RowSource problem
Message
From
21/04/2006 11:50:52
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL - List Box - RowSource problem
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01115429
Message ID:
01115429
Views:
63
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
Next
Reply
Map
View

Click here to load this message in the networking platform