Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

CRecordset problem... When trying to Open,it says ODBC driver doesn't support Dynasets

Do you know what is the problem?

How can I read and write to fields in a Recordset without the need of deriving a CRecordset class?

Thanks in advance
Skel
0
skel
Asked:
skel
1 Solution
 
inprasCommented:
Hi
CRecordset rs;
rs.Open(CRecordset::dynaset, "SELECT * FROM MyTab", none);
and access the fields

to update
CDatabase db;
db.Open(...);
db.ExecuteSQL("UPDATE TABLE tab1 SET...");

Hope this helps
inpras
0
 
yclCommented:
Yes,use SQL clause is a effective way.
0
 
skelAuthor Commented:
But when I use rs.Open(CRecordset::dynaset, "SELECT * FROM MyTab", none); I get the error that ODBC Driver doesn't support dynasets....

Finally I'm trying using DAO... I have more experience on that

Skel
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now