Click here to Skip to main content
16,010,392 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: DLL loading trouble. Pin
yamini19-Aug-01 22:51
yamini19-Aug-01 22:51 
GeneralRe: DLL loading trouble. Pin
The_Server20-Aug-01 1:03
The_Server20-Aug-01 1:03 
GeneralRe: DLL loading trouble. Pin
Mukkie21-Aug-01 7:18
Mukkie21-Aug-01 7:18 
QuestionHow settings the DCB for SerialPort ? Pin
youssef19-Aug-01 20:54
youssef19-Aug-01 20:54 
AnswerRe: How settings the DCB for SerialPort ? Pin
Tim Deveaux20-Aug-01 13:05
Tim Deveaux20-Aug-01 13:05 
Generalconnection options Pin
19-Aug-01 20:47
suss19-Aug-01 20:47 
Questionhmmm DAO !!! 3 question ??? Pin
Ahmad19-Aug-01 20:20
Ahmad19-Aug-01 20:20 
AnswerRe: hmmm DAO !!! 3 question ??? Pin
Steen Krogsgaard20-Aug-01 5:17
Steen Krogsgaard20-Aug-01 5:17 
Here's some short replies. I really recommend that you read some books on the subject, as it is a huge one. "Microsoft Jet Database Engine Programmers Guide" used to be online on MSDN, but I can't find it there anymore. It's a bit outdated anyway, but gives you a good grip on DAO (although it's written for VB!!!). If you have some MSDN Library CD's from last year I guess it will be there.

The answers:
1: snapshot: the resultset is a snapshot of the data in the database. Changes to the data in the db after the snapshot is opened is not reflected in the snapshot. The snapshot is read-only (and I vaguely remember something about it being forward-only also).
Dynaset: the resultset represents the actual data in the database at the time you fetch (i.e. read) the data. Updateable.
Snapshots and Dynasets are the result of a query, i.e. an SQL statement.
Table: as Dynaset, but gives you all the fields of one particular table. Among other things very useful if you want to browse the table, or as a basis for a data-entry form in your program.
2: You probably asked for a snapshot - they're read-only.
3: Use a QueryDef object. Here you can set the SQL text.

good luck


Steen
GeneralRe: hmmm DAO !!! 3 question ??? Pin
Ahmad20-Aug-01 21:56
Ahmad20-Aug-01 21:56 
QuestionCan I dialing from my programme ??? Pin
Ahmad19-Aug-01 20:15
Ahmad19-Aug-01 20:15 
GeneralReference to the document Pin
19-Aug-01 20:09
suss19-Aug-01 20:09 
GeneralMail from an NT Service Pin
Nick Blumhardt19-Aug-01 19:47
Nick Blumhardt19-Aug-01 19:47 
Generalp.s. Pin
Nick Blumhardt19-Aug-01 19:53
Nick Blumhardt19-Aug-01 19:53 
GeneralRe: Mail from an NT Service Pin
Giles20-Aug-01 1:41
Giles20-Aug-01 1:41 
GeneralRe: Mail from an NT Service Pin
Nick Blumhardt20-Aug-01 12:51
Nick Blumhardt20-Aug-01 12:51 
GeneralRe: Mail from an NT Service Pin
Nick Blumhardt20-Aug-01 17:38
Nick Blumhardt20-Aug-01 17:38 
GeneralRe: Mail from an NT Service Pin
Giles21-Aug-01 8:53
Giles21-Aug-01 8:53 
GeneralRe: Mail from an NT Service Pin
Nick Blumhardt21-Aug-01 12:41
Nick Blumhardt21-Aug-01 12:41 
Generalpropertysheet: how do I add one to a formview Pin
ssiegel19-Aug-01 18:33
ssiegel19-Aug-01 18:33 
Generalproblems with recreating fwatch Pin
Hong Wye Kean19-Aug-01 17:26
Hong Wye Kean19-Aug-01 17:26 
GeneralRe: problems with recreating fwatch Pin
Michael Dunn19-Aug-01 20:18
sitebuilderMichael Dunn19-Aug-01 20:18 
GeneralProblems with a Win98 Machine Pin
19-Aug-01 15:53
suss19-Aug-01 15:53 
GeneralTesting for Previous Application Instances Pin
19-Aug-01 15:32
suss19-Aug-01 15:32 
GeneralRe: Testing for Previous Application Instances Pin
Ravi Bhavnani19-Aug-01 15:46
professionalRavi Bhavnani19-Aug-01 15:46 
Generalcreating new process sanity check Pin
Amit Jain19-Aug-01 15:30
Amit Jain19-Aug-01 15:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.