>I ve got a connection to my MSDE database using
>

>gnConnHandle = SQLCONNECT('myServer', 'me')
>

>
>I should be connected to a database called myDB and there should be a table called myTable. How do I select all records from that table into a cursor called myCursor?
>
>

>select * from myDB!myTable! into cursor myCursor
>

>
>doesn't seem to work.
>
>Thanks,
>Einar

Assuming connection succeeded (check value) :

SQLExec(gnConnHandle, "select * from myDB..myTable", "myCursor")

SQL server tables are in the form :
Database.Owner.Table
Cetin