Something like this:

SQLEXEC(Ras2Conn, "SELECT ENV_NO, ENV_TOTL ;
	 	FROM Ras2_envelope where env_no < 10 ", "test")
with thisform.List1
    .RowSourceType= 3
    .RowSource="select * from test into curs tmpcrs"
...
*or

*with thisform.List1
*	.RowsourceType=2
*	.Rowsource="test"
*...

>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