Click here to Skip to main content
15,890,973 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Only One Instance to be opened - alternative Pin
.::RockNix::.6-Mar-01 21:15
.::RockNix::.6-Mar-01 21:15 
GeneralRe: Only One Instance to be opened - alternative Pin
l a u r e n6-Mar-01 22:51
l a u r e n6-Mar-01 22:51 
GeneralRe: Only One Instance to be opened - alternative Pin
.::RockNix::.7-Mar-01 2:24
.::RockNix::.7-Mar-01 2:24 
GeneralRe: Only One Instance to be opened - alternative Pin
James R. Twine7-Mar-01 3:46
James R. Twine7-Mar-01 3:46 
GeneralRe: Only One Instance to be opened - alternative Pin
.::RockNix::.7-Mar-01 4:22
.::RockNix::.7-Mar-01 4:22 
GeneralRe: Only One Instance to be opened - alternative Pin
James R. Twine7-Mar-01 5:39
James R. Twine7-Mar-01 5:39 
GeneralRe: Only One Instance to be opened... Pin
James R. Twine7-Mar-01 3:34
James R. Twine7-Mar-01 3:34 
QuestionWhy does Seek fail in ADO, even though it should support it? Pin
Brendan Tregear6-Mar-01 11:28
Brendan Tregear6-Mar-01 11:28 
Hi,

This one's really got me confused. I've got my database (tblPatients) with a primary key patientID. I create a new recordset:

//
pAnotherRecordSet.CreateInstance(_uuidof(Recordset));
//

then I make sure to use the server-side cursor:

//
pAnotherRecordSet->PutCursorLocation(adUseServer);
//

then I open the record, making sure to use a direct table access:

//
hr = pAnotherRecordSet->Open("tblPatients", _variant_t((IDispatch*)pConnection), adOpenKeyset, adLockOptimistic, adCmdTableDirect);
//

I've also tried a completely new connection object like:

//
hr = pConnection->Open(
_bstr_t(L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Projects\\DB\\TrialRun.mdb;"),
_bstr_t(L""),
_bstr_t(L""),
adModeUnknown);
//

But when I get to:

pAnotherRecordSet->Supports(adSeek)

it always returns FALSE! If I ignore it and try a Seek, anyway, I get a runtime error. I'm using Access 97, is that relevant?

Thanks for any help Smile | :)

Brendan


AnswerRe: Why does Seek fail in ADO, even though it should support it? Pin
l a u r e n6-Mar-01 11:49
l a u r e n6-Mar-01 11:49 
GeneralMmmm, I suspect you're right... (n/t) Pin
Brendan Tregear6-Mar-01 12:15
Brendan Tregear6-Mar-01 12:15 
GeneralPLEASE HELP: debug_assertion in property page creation Pin
Joan M6-Mar-01 7:45
professionalJoan M6-Mar-01 7:45 
GeneralRe: PLEASE HELP: debug_assertion in property page creation Pin
6-Mar-01 11:05
suss6-Mar-01 11:05 
Generalmessage for christian... Pin
l a u r e n6-Mar-01 11:40
l a u r e n6-Mar-01 11:40 
GeneralRe: message for christian... Pin
Christian Graus6-Mar-01 13:49
protectorChristian Graus6-Mar-01 13:49 
GeneralGetting Message problem.... Pin
Richard Cheng6-Mar-01 6:55
Richard Cheng6-Mar-01 6:55 
GeneralRe: Getting Message problem.... Pin
l a u r e n6-Mar-01 9:28
l a u r e n6-Mar-01 9:28 
GeneralRe: Getting Message problem.... Pin
Richard Cheng6-Mar-01 9:45
Richard Cheng6-Mar-01 9:45 
GeneralRe: Getting Message problem.... Pin
Richard Cheng6-Mar-01 9:45
Richard Cheng6-Mar-01 9:45 
GeneralRe: Getting Message problem.... Pin
l a u r e n6-Mar-01 11:39
l a u r e n6-Mar-01 11:39 
GeneralRe: Getting Message problem.... Pin
Richard Cheng6-Mar-01 12:11
Richard Cheng6-Mar-01 12:11 
GeneralRe: Getting Message problem.... Pin
l a u r e n6-Mar-01 12:13
l a u r e n6-Mar-01 12:13 
GeneralRe: Getting Message problem.... Pin
Richard Cheng6-Mar-01 12:13
Richard Cheng6-Mar-01 12:13 
GeneralRe: Getting Message problem.... Pin
l a u r e n6-Mar-01 12:21
l a u r e n6-Mar-01 12:21 
GeneralRe: Getting Message problem.... Pin
Manfred Ramosch6-Mar-01 11:48
Manfred Ramosch6-Mar-01 11:48 
GeneralRe: Getting Message problem.... Pin
Richard Cheng6-Mar-01 12:58
Richard Cheng6-Mar-01 12:58 

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.