>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