Jerry

You cannot run select statement against sql table in the list.Rowsource expression. You need to get VFP cursor (which is "test") and used it as a source for the ListBox (no matter how, as an alias, in the sql statement,etc).
Review carefully my previous code and follow it exactly. Do not modify it.


>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