how execute query in access database with CRecordset file?
-
hi all, i m using Access database with ODBC connection in my application. here i am generate a CRecordset derived Class for each table in Database. now here i fetch record here using while loop with movenext. this is slow in process. i want to use Query here to fast my process. please help anyone to execute query to fetch,insert or update record record in table. thanks in advance.
-
hi all, i m using Access database with ODBC connection in my application. here i am generate a CRecordset derived Class for each table in Database. now here i fetch record here using while loop with movenext. this is slow in process. i want to use Query here to fast my process. please help anyone to execute query to fetch,insert or update record record in table. thanks in advance.
Well, the first step is to create a query ( the easiest way would be to create it and test in the MS Access). The second step - create the recordset that supports update and insert operations. See MSDN article [^] for details.
-
hi all, i m using Access database with ODBC connection in my application. here i am generate a CRecordset derived Class for each table in Database. now here i fetch record here using while loop with movenext. this is slow in process. i want to use Query here to fast my process. please help anyone to execute query to fetch,insert or update record record in table. thanks in advance.
Le@rner wrote:
this is slow in process.
How are you measuring this?
Le@rner wrote:
please help anyone to execute query to fetch,insert or update record record in table.
Did you bother to read the docs? They'll answer most, if not all, of your questions. I have an article here that shows how to create a read-only recordset. Other articles here.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles