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

Click here to load this message in the networking platform