I normally use Access for my desktop applications but want to look at Pervasive as a more robust option. In VB I can open an ADO recordset as the result of an SQL statement. Ex:- rs1.Open "SELECT * FROM Course", dbTest, adOpenDynamic, adLockBatchOptimistic
When I try to open this recordset on a Pervasive table I get a "Table does not exist" error. I assume it thinks SELECT is a table name. Can I only open recordsets to a table name?
Thanks.
When I try to open this recordset on a Pervasive table I get a "Table does not exist" error. I assume it thinks SELECT is a table name. Can I only open recordsets to a table name?
Thanks.