C / C++ / MFC

FirstPrevNext

Re: OLE DB: CDynamicAccessor and Columns order Paul Selormey8-Oct-01 15:18 Paul Selormey 8-Oct-01 15:18  Hello Steen, Thanks for the response. > How do you know that the order is not in the same way as in the > db? 1. Even though I do not have Access installed, because of the testing I wish to achieve, I opened the data with Access on a different PC and could tell the column order. 2. Trying to read the values to fill the columns after the columns names does not work well-since there is no matching of types as obtained from the column information. Any further help will be highly appreciated. Someone says it has to do with the bookmarks, any hint? Best regards, Paul. Paul Selormey, Bsc (Elect Eng), MSc (Mobile Communication) is currently Windows open source developer in Japan, and open for programming contract anywhere! Re: OLE DB: CDynamicAccessor and Columns order Steen Krogsgaard8-Oct-01 22:54 Steen Krogsgaard 8-Oct-01 22:54  Hi Paul, I tested the CDynamicAccessor on a Jet database and it delivers the columns in the same order as Access shows them. However, the DBSCHEMA_COLUMNS rowset shown in RowsetViewer shows another order - so I'm confused. Unfortunately this doesn't really help you much. Can you make your program independent of the column order? The CDynamicAccessor returns a column 0 which contains the bookmarks. This column is returned if you set DBPROP_BOOKMARKS to true. This means that your first data column has ordinal 1. >2. Trying to read the values to fill the columns after the columns names >does not work well-since there is no matching of types as obtained from the >column information. I'm not sure what you mean? Cheers Steen. "To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music" Re: OLE DB: CDynamicAccessor and Columns order Paul Selormey9-Oct-01 0:16 Paul Selormey 9-Oct-01 0:16  Hello Steen, Thanks so much for this great support. I am really hot now and this support is highly appreciated. I do not know if this is a bug in the CDynamicAccessor or the Jet. Please can you make your test source available for me to learn from it? I may be doing something wrong-just confused that it works well with SQL Server. I was initially working with the CManualAccessor and for reasons I cannot tell the binding to the Access columns fails. I gave up and started with the slower CDynamicAccessor and this is the result. Please help with any piece of information-I have to complete this work by Monday to start another project. Best regards, Paul. Paul Selormey, Bsc (Elect Eng), MSc (Mobile Communication) is currently Windows open source developer in Japan, and open for programming contract anywhere! Re: OLE DB: CDynamicAccessor and Columns order Steen Krogsgaard9-Oct-01 1:39 Steen Krogsgaard 9-Oct-01 1:39  Just for the record, I have mailed you the project files and the database directly (more than 7 megs, not suitable for this forum Cheers Steen. "To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music" Re: OLE DB: CDynamicAccessor and Columns order Tomasz Sowinski8-Oct-01 1:26 Tomasz Sowinski 8-Oct-01 1:26  I haven't been working with OLEDB Consumer Templates for some time, but I remember that problem you're experiencing may be related to the bookmark column. Tomasz Sowinski -- http://www.shooltz.com Re: OLE DB: CDynamicAccessor and Columns order Paul Selormey8-Oct-01 15:26 Paul Selormey 8-Oct-01 15:26  Hello Tomasz, Thanks for the support. It is only a simple stage of opening and reading the data to list view. Not using bookmarks, any further hint? Best regards, Paul. Paul Selormey, Bsc (Elect Eng), MSc (Mobile Communication) is currently Windows open source developer in Japan, and open for programming contract anywhere! Re: OLE DB: CDynamicAccessor and Columns order Tomasz Sowinski9-Oct-01 1:05 Tomasz Sowinski 9-Oct-01 1:05  With Jet provider, you're getting bookmarks at position 0, as Steen pointed out. You don't have to ask for them, provider just gives you bookmark for free Tomasz Sowinski -- http://www.shooltz.com Re: OLE DB: CDynamicAccessor and Columns order Steen Krogsgaard9-Oct-01 2:07 Steen Krogsgaard 9-Oct-01 2:07  Are you sure that the Jet provider gives you bookmarks no matter what? In the help it says you can set DBPROP_BOOKMARKS to VARIANT_FALSE, and I translated this into you not getting the bookmarks. I tried opening a table (i.e. through IOpenRowset, using CTable<cdynamicaccessor>) while setting DBPROP_BOOKMARKS to VARIANT_FALSE, but that gave med a DB_E_ERRORSOCCURRED with the status field set to DBPROPSTATUS_CONFLICTING - maybe I'll have to turn off DBPROP_CANFETCHBACKWARDS and DBPROP_CANSCROLLBACKWARDS? I don't want to put too much time into it if you're certain that Jet will always return the bookmark column. Cheers Steen. "To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music" Re: OLE DB: CDynamicAccessor and Columns order Tomasz Sowinski9-Oct-01 2:20 Tomasz Sowinski 9-Oct-01 2:20  No, I'm not sure. As I've mentioned, some time has passed since I was working with OLEDB for the last time. However, I remember problems with column ordinals. Our product had to work with SQLServer and Jet, we had to provide two slightly database layer .dlls, one of the differences was column ordinal handling. Tomasz Sowinski -- http://www.shooltz.com MFC ActiveX and Interfaces Paul Selormey7-Oct-01 21:31 Paul Selormey 7-Oct-01 21:31  Hello All, I have MFC-based ActiveX control. I implemented other Automation objects and interfaces-CCmdTarget stuff (some creatable). Now, when trying to use the control in MFC applications, the ClassWizard does not generate wrapper for the automation objects (only the ActiveX control). This is no problem in VB test application. Is there anything extra I need to do with the *.odl file for the ClassWizard to use it effectively. VC++ compiler-based COM wrappers could be generated as usual but this is not clean and nice to has clients to do. Any help? Best regards, Paul. Paul Selormey, Bsc (Elect Eng), MSc (Mobile Communication) is currently Windows open source developer in Japan, and open for programming contract anywhere! Re: MFC ActiveX and Interfaces Bret Faller8-Oct-01 7:40 Bret Faller 8-Oct-01 7:40  You should have a .tlb file which in ClassWizard you can select New Class from Type Library and it will generate the cpp/h for the type-library. Also, if you don't want to have the header/cpp files you can always do an #import. Bret Faller Odyssey Computing, Inc. Re: MFC ActiveX and Interfaces 8-Oct-01 7:48 8-Oct-01 7:48  Or if you want to take life into your own hands, use the APIs directly: CLSIDFromProgID, CoCreateInstance, IDispatch::GetIDsOfNames, IDispatch::Invoke, etc. Re: MFC ActiveX and Interfaces Paul Selormey8-Oct-01 15:12 Paul Selormey 8-Oct-01 15:12  Thanks, now I get it. The ClassWizard is using the VB generated *.oca file. I used the From the Typelib and selected the *.tlb and it works. Best regards, Paul. Paul Selormey, Bsc (Elect Eng), MSc (Mobile Communication) is currently Windows open source developer in Japan, and open for programming contract anywhere! MotherBoard serial number ernst.maurer7-Oct-01 20:42 ernst.maurer 7-Oct-01 20:42  Hi How can I get mother-board serial number, programmaticaly? Ernst Thanx Combobox Win32 Christian Graus7-Oct-01 20:06 Christian Graus 7-Oct-01 20:06  My second attempt at this question ( Internet at work is screwed, especially for CP ). I have a combo box in Win32, and I want the edit control to work. It appears I need to catch the <enter> key being pressed and impliment the behaviour I want. Spy++ can find WM_KEYDOWN?CHAR?KEYUP being called, but it is not called to the combobox ( subclassed it, nothing ) or the parent dialog ( nothing again ). Can anyone tell me what the (%#(%(# is going on and how I am supposed to do this? Thanks. Christian As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet. Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery. Re: Combobox Win32 Michael Dunn7-Oct-01 20:34 Michael Dunn 7-Oct-01 20:34  Gotta ask the obvious first - Have you set the combo style correctly (should be drop-down, not drop-list)? --Mike-- http://home.inreach.com/mdunn/ "Listen you footwarriors, can you hold down a bit with the firing? I've just got three impromptu weddings breaking out behind me!" -- Arthur Dent your with and Re: Combobox Win32 Christian Graus7-Oct-01 20:39 Christian Graus 7-Oct-01 20:39  Fair cop - yes, and yes, I can edit, but <enter> beeps and that's all. No messages anywhere, as above. Christian As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet. Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery. Re: Combobox Win32 Michael Dunn7-Oct-01 22:27 Michael Dunn 7-Oct-01 22:27  hmm, I'm not quite clear on whether the edit box portion works at all. When you type, do the characters appear at all? Or do you just get a beep? Or both? To answer your original question, you don't have to do anything special, since the combo box manages the edit box portion itself. --Mike-- http://home.inreach.com/mdunn/ "Listen you footwarriors, can you hold down a bit with the firing? I've just got three impromptu weddings breaking out behind me!" -- Arthur Dent your with and Re: Combobox Win32 Christian Graus7-Oct-01 23:23 Christian Graus 7-Oct-01 23:23  I've created a box with CreateWindow and the style "COMBOBOX", and the DROPDOWN style. I can add and remove strings programatically, and select them. I can type in the edit box and strings appear. When I hit enter I get the bell, but the text I have typed remains and does not appear in the list box. If the combo is supposed to handle it, it sounds like something has gone horribly wrong. Christian As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet. Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery. Re: Combobox Win32 Tomasz Sowinski8-Oct-01 1:29 Tomasz Sowinski 8-Oct-01 1:29  The edit control is a child of combo - are you subclassing a combo itself or edit control hosted in the combo? Tomasz Sowinski -- http://www.shooltz.com Re: Combobox Win32 Christian Graus8-Oct-01 1:59 Christian Graus 8-Oct-01 1:59  I've created a Combobox with a call to CreateWindow, with the COMBOBOX class. The resulatant HWND passed back is what I have subclassed using SetWindowLong. I don't know how to get to the edit HWND from where I am, or subclass it, and I think that is my problem. Christian As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet. Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery. Re: Combobox Win32 Tomasz Sowinski8-Oct-01 2:08 Tomasz Sowinski 8-Oct-01 2:08  AFAIR, the child ID of the edit is 1001. Use Spy++ to check this; it's not documented, but remains the same since Win 3.x. Tomasz Sowinski -- http://www.shooltz.com Re: Combobox Win32 Christian Graus8-Oct-01 2:50 Christian Graus 8-Oct-01 2:50  Thanks. Michaels comments have left me worried I have a deeper problem, but I'll try that tomorrow and see how I go. Christian As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet. Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery. Quesstion about Mpeg4! Xiaodi_Liu7-Oct-01 16:35 Xiaodi_Liu 7-Oct-01 16:35  Could you tell me how to encode/decode Mpeg4. Now I want to develop a Mpeg4 encoder/decoder.Is there any dll file and user guide for me. If you have pls email me. Thanks!Xiaodi80@yahoo.com.cn Re: Quesstion about Mpeg4! Xiaodi_Liu8-Oct-01 17:41 Xiaodi_Liu 8-Oct-01 17:41  UP

Last Visit: 31-Dec-99 18:00     Last Update: 23-Sep-24 1:25 Refresh ᐊ Prev1...17921179221792317924179251792617927179281792917930 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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