Open an SLQ recordset via OLEDB

[fwadmin]

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.

 

[TomKane]

You could try something like this instead.

strSQL = "SELECT * FROM Currency_Info"
Set rsXrateDets = New ADODB.Recordset
rsXrateDets.Open strSQL, conPostingADO, adOpenForwardOnly, adLockReadOnly, adCmdText

 

[Guest_imported]

I guess the DDF files for the database you are using are still not updated. Please USE the Pervasive Control Center Interface to create the new table "Course" and that will for sure solve the problem.

And as per my 7 months of experience with Pervasive and Betrieve never open a recordset rather use the following..it has allways worked while the recordset.open fails at times...although I do not know why?

Use

Set rs1 = dbTest.Execute ("SELECT * FROM Course&quot

Thanks
-SHRIMANT PATEL-