>Assuming connection succeeded (check value) :
>
>SQLExec(gnConnHandle, "select * from myDB..myTable", "myCursor")
>
>SQL server tables are in the form :
>Database.Owner.Table
>Cetin
Cetin,
Thanks for the reply. Your suggestion worked wonderfully. It even worked without specifying the database owner. So my exact code was:
sqlexec(gnconnhandle, "select * from myDB..myTable","myCursor")
Is it "bad" to run the select statement without specifying the database owner?
Do you know the difference or advantage for using sqlexec() compared to using a select SQL command?
Thanks,
Einar
Semper ubi sub ubi.