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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only