Click here to Skip to main content
15,886,806 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
QuestionHow Do I use VirtualListView (LVN_GETDISPINFO) with CRecordset? Pin
apavlenko3-Feb-00 18:41
apavlenko3-Feb-00 18:41 
AnswerRE: How Do I use VirtualListView (LVN_GETDISPINFO) with CRecordset? Pin
apavlenko3-Feb-00 19:16
apavlenko3-Feb-00 19:16 
Generallock toolbar position after docking Pin
Anonymous3-Feb-00 3:42
suss Anonymous3-Feb-00 3:42 
GeneralRE: lock toolbar position after docking Pin
Cristi Posea4-Feb-00 0:15
Cristi Posea4-Feb-00 0:15 
GeneralRE: lock toolbar position after docking Pin
Jesse Ezell5-Feb-00 19:13
Jesse Ezell5-Feb-00 19:13 
QuestionHow Do I Get/Set Mouse Sensitivity? Pin
Anonymous1-Feb-00 11:05
suss Anonymous1-Feb-00 11:05 
GeneralCreateFileMapping - Open it... Pin
braulio31-Jan-00 22:26
braulio31-Jan-00 22:26 
GeneralODBC Recordset Indexes Pin
Henry Venn31-Jan-00 21:51
Henry Venn31-Jan-00 21:51 
I have got a project where I link a couple of tables from an external database to use within a local Jet (access.mdb) database, for which purpose I use the DAO classes.

THE DATABASE
The external database Open() call looks like this :- m_dbExtern.Open(_T(""), TRUE, FALSE, _T("ODBC;"));
The empty name string combined with the "ODBC;" cause the Windows ODBC selection dialog to appear, and CDaoDatabase opens a link to that. SIDE ISSUE: Anyone know how to get this dialog to default to the SYSTEM tab rather than the USER?

THE RECORDSET
Originally I used the straight CRecordset classes but found DAO more flexible, but its flexible. I have a class derived from CDaoRecordset which contains static attributes mirrored to what is in the table I want to access.
The ODBC links to a database table written in dataflex which has a data definition file : here is the indexes it defines :-

INDEX# FIELDS DES U/C LENGTH LEVELS SEGMENTS MODE
------ --------------- --- --- ------ ------ -------- -------
1 CODE NO NO 6 3 1 ON-LINE

2 ALPHA NO NO 9 3 2 ON-LINE
RECNUM NO NO

3 CODE NO NO 8 3 2 ON-LINE
EMPL NO NO

4 CODE NO NO 11 3 3 ON-LINE
ALPHA NO NO
RECNUM NO NO

The thing is, I don't know much about these recordset classes, I just want CDaoRecordset::Open() to use INDEX #2, #3 or #4 - it is defaulting to INDEX #1. Dataflex is a pretty rare database, but it does have an ODBC driver written for it - perhaps this driver defines everything I need?

Hope someone can help me....P-l-ease!!!

Cheers,
H. Venn
QuestionHow to insert picture in CRichEditView ? !!!! Pin
Roma31-Jan-00 4:23
Roma31-Jan-00 4:23 
QuestionIPX and CSocket? Pin
Topher30-Jan-00 13:02
Topher30-Jan-00 13:02 
GeneralANNOUNCEMENT: New C/C++ source beautifier Pin
HPSI29-Jan-00 19:39
HPSI29-Jan-00 19:39 
GeneralProblems with Visual C++ Version 6 Pin
Subby Rajan29-Jan-00 7:15
sussSubby Rajan29-Jan-00 7:15 
GeneralRE: Problems with Visual C++ Version 6 Pin
Michael Owen31-Jan-00 9:07
Michael Owen31-Jan-00 9:07 
GeneralRE: RE: Problems with Visual C++ Version 6 Pin
StasK2-Feb-00 2:55
suss StasK2-Feb-00 2:55 
QuestionHow do I allow ODBC access my data Pin
Anonymous28-Jan-00 6:27
suss Anonymous28-Jan-00 6:27 
GeneralLost debugg information Pin
martin27-Jan-00 21:25
suss martin27-Jan-00 21:25 
GeneralRE: Lost debugg information Pin
Anonymous1-Feb-00 0:46
suss Anonymous1-Feb-00 0:46 
GeneralAdding controls to a CTabCtrl Pin
Frank Deo27-Jan-00 9:02
Frank Deo27-Jan-00 9:02 
GeneralRE: Adding controls to a CTabCtrl Pin
Nick Hodapp29-Jan-00 11:34
sitebuilderNick Hodapp29-Jan-00 11:34 
GeneralCtabctrl - change tab name on double click Pin
chrisg27-Jan-00 5:26
chrisg27-Jan-00 5:26 
GeneralCreating DLLs in VC for use in VB Pin
Bagyalakshmi SN26-Jan-00 20:18
sussBagyalakshmi SN26-Jan-00 20:18 
GeneralRE: Creating DLLs in VC for use in VB Pin
Nick Hodapp29-Jan-00 11:29
sitebuilderNick Hodapp29-Jan-00 11:29 
GeneralFlexGrid Activation Problem Pin
glerner26-Jan-00 16:58
glerner26-Jan-00 16:58 
GeneralNested CSplitterWnd('s) and CSize Pin
Frank Deo25-Jan-00 11:01
Frank Deo25-Jan-00 11:01 
GeneralRE: Nested CSplitterWnd('s) and CSize Pin
Mike Dunn25-Jan-00 14:50
Mike Dunn25-Jan-00 14:50 

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.