Re: error doing a select distinct - C / C++ / MFC Discussion Boards

Re: Using a dialog as a control

moredip1-Aug-02 11:43

moredip

1-Aug-02 11:43

yeah, but subsequent calls to GetStyle() return 44000844 Cry | :((

Re: Using a dialog as a control

C^hris L^osinger1-Aug-02 11:46

C^hris L^osinger

1-Aug-02 11:46

maybe i'm misunderstanding.. but... they should.

ModifyStyle(0xffffffff, X) will set the style bits to "X"

To explain Donald Knuth's relevance to computing is like explaining Paul's relevance to the Catholic Church. He isn't God, he isn't the Son of God, but he was sent by God to explain God to the masses.
/. #3848917

image effects!

Re: Using a dialog as a control

moredip1-Aug-02 11:51

moredip

1-Aug-02 11:51

I'm calling ModifyStyle(0xffffffff, 0x40000844)
and subsequent GetStyle calls return 0x44000844.

Note that the 2nd 0 is now a 4.

Re: Using a dialog as a control

C^hris L^osinger1-Aug-02 11:52

C^hris L^osinger

1-Aug-02 11:52

ah.

any idea what the extra '4' represents?

image effects!

Re: Using a dialog as a control

moredip1-Aug-02 11:57

moredip

1-Aug-02 11:57

WS_CLIPSIBLINGS (WINUSER.h)

A strange style to be misbehaving Big Grin | :-D

I have a feeling that this bug-hunt is academic now anyway, as I modified the resource to have ClipSiblings set, and it still does not work.

So even if I could get that ModifyStyle() call to do the job, it would not solve my problem.

Intriguing though....

Thanks,

Pete

Re: Using a dialog as a control

moredip1-Aug-02 12:20

moredip

1-Aug-02 12:20

So, for those who are interested, here is how I did it (finally):

ModifyStyle() can't be used, possibly because of the way dialogs are loaded from resources.

But it is possible to programmatically modify the resource, as follows:

	CString strIDD;
	strIDD.Format( "#%u", IDD_VCR ); //where IDD_VCR is the dialog resource I wish to embed
	DLGTEMPLATEEX* pDlgTemplate = (DLGTEMPLATEEX*)::LockResource( ::LoadResource( NULL, ::FindResource( NULL, strIDD, RT_DIALOG ) ) );

	//set the dialog style so that we can use it as an embedded control (see the #defines for WS_POPUP etc in WINUSER.H)
	pDlgTemplate->Style = 0x40000844;
	

	m_pVCR = new DEmbeddedVCR();
	m_pVCR->CreateIndirect( pDlgTemplate, this );

//note that we cannot directly 'unlock' pDlgTemplate, this is handled by Windoze

This should all really be put in DEmbeddedVCR::Create(), rather than called 'client-side' as it were.

Hope that helps out someone at some point...

Pete

error doing a select distinct

ns1-Aug-02 9:35

1-Aug-02 9:35

I am doing a simple select distince:

if(pAdoDb.Open((LPCTSTR)strConnection))
{
	CString strCommandText;
	CString strQry = _T("");
	int numRecords;

	strQry.Format(_T("SELECT DISTINCT (Color) From tblTest"));

	CADOCommand pCommand(&pAdoDb, strCommandText = _T(""),CADOCommand::typeCmdText);
	pCommand.SetText(strQry);

	CADORecordset pRs(&pAdoDb);

	if(!pRs.Execute(&pCommand))
		AfxMessageBox("failed");

This snippet worked with "select * from tblTest".

With the distinct command above I am getting a runtime error:

CADORecordSet error
code = 80040e10
code meaning = IDispatch error #3088
Source = Microsoft JET database engine
Description = No value given for one or more required parameters

What am I doing wrong? Please help!
Thanks,
ns

Re: error doing a select distinct

Ravi Bhavnani1-Aug-02 9:44

Ravi Bhavnani

1-Aug-02 9:44

Are the parentheses around "Color" extraneous?

(Caveat: I know nothing about SQL.)

/ravi

Let's put "civil" back into "civilization"
http://www.ravib.com
ravib@ravib.com

Re: error doing a select distinct

ns1-Aug-02 9:51

1-Aug-02 9:51

The parentheses dont seem to matter. I just realized this is not the forum for this stuff, but the ADO forum is really dead....d'you think I can post here or is that not nice?

Re: error doing a select distinct

Ravi Bhavnani1-Aug-02 9:57

Ravi Bhavnani

1-Aug-02 9:57

ns wrote:
The parentheses dont seem to matter.
Ugh, sorry. I got that from Google.

It's probably better to post in the ADO forum, but I think the lack of replies isn't due to the forum location, rather that most readers may not know the answer. I wish I could help, but I'm database clueless.

/ravi

Let's put "civil" back into "civilization"
http://www.ravib.com
ravib@ravib.com

Re: error doing a select distinct

achandra0071-Aug-02 9:58

achandra007

1-Aug-02 9:58

I am not so sure about ADO but right off the bat, the number of columns you are returning has changed. Have you bound columns?

Re: error doing a select distinct

Joaquín M López Muñoz1-Aug-02 9:59

Joaquín M López Muñoz

1-Aug-02 9:59

Firstly, I think the parentheses are not really needed. Secondly, make sure you're using the right combination of uppercase and lowercase letters.

Joaquín M López Muñoz
Telefónica, Investigación y Desarrollo

Its resolved, thanks!

ns1-Aug-02 10:12

1-Aug-02 10:12

I blush to mention this but I had two copies of the database and I had added columns to one, which I was querying on, but I hadnt pointed my connection to the right version... Anyways I found out what SQL does when it doesnt find a column with the name you specify. Ulp! Blush | :O

VC++ 7.0's Attributes

thefirst_bigd1-Aug-02 9:29

thefirst_bigd

1-Aug-02 9:29

Hi,

I have two interfaces, say IOne and ITwo:

__interface IOne;
__interface ITwo;

[
attribute stuff
]
__interface IOne
{
HRESULT Two(ITwo *pTwo);
};

[
more stuff
]
__interface ITwo
{
HRESULT One(IOne *pOne);
};

The C++ code compiles, but the MIDL fails saying the ITwo parameter in the IOne interface is unresolved. I have tried alsorts of attributes and hacks to get it working and it has me stumped. I have looked through MSDN and found nothing.

Any ideas?

Thanks.

Re: VC++ 7.0's Attributes

Joaquín M López Muñoz1-Aug-02 9:44

Joaquín M López Muñoz

1-Aug-02 9:44

The code seems just fine. I'm almost sure this won't remedy the problem, but please try replacing __interface with interface. Also, the forward declaration of IOne is not needed, maybe you can try deleting it to rule out the (remote) possibility that the compiler is getting confused by it.

Joaquín M López Muñoz
Telefónica, Investigación y Desarrollo

Re: VC++ 7.0's Attributes

thefirst_big1-Aug-02 11:10

thefirst_big

1-Aug-02 11:10

The IOne/ITwo were just a simplification, it's an object model for an offline physics simulator so there's quite MIDL forward declarations to worry about.

changine __interface to interface causes the code to not compile at all. I have changed the forward declarations to everything I can think of. I have even tried dumping a list of my objects in a separate .IDL file and inserting/including it using an embedded IDL statement. Nothing's working.

I would have thought that Microsoft, with 7.0's attributes, which are designed for simpler and speedier COM/ATL/.net programming, wouldn't require forward declaration when it gets to the post-C++ compilation stage.

Resizing ListView Column Headers

RussR1-Aug-02 9:30

RussR

1-Aug-02 9:30

I have an ATL DialogBox class with a ListView Control. I'd like to set the sizes of the columns dynamically. However, when I try to pass the width, I get an "Invalid Property Value" error:

     CComPtr<MSCOMCTL::IListView> piAnsList;
HRESULT hr = GetDlgControl(IDC_ANSWERS,__uuidof(MSCOMCTL::IListView),
            reinterpret_cast<void**>(&piAnsList));

CComQIPtr<MSCOMCTL::IColumnHeaders> piColHdrs;
CComQIPtr<MSCOMCTL::IColumnHeader> piNewHdr;

piColHdrs = piAnsList->ColumnHeaders;
_variant_t vColKey(L"ColOne");
_variant_t vColName(L"First");
_variant_t vWidth((double)100.0);  //Hardcoded now but will be dynamic
_variant_t vAlign((long)MSCOMCTL::lvwColumnLeft);
piNewHdr = piColHdrs->Add(&vtMissing, &vColKey, &vColName,
                               &vWidth, &vAlign);

If I replace vWidth with vtMissing, everything is fine, so it must be the width. I got a similar error using the IColumnHeader->PutWidth method. Any suggestions greatly appreciated. Thanks.

Russ Rogers
GraniteLeaf Systems

CreateFile for folder in 9x, it is possible?

includeh101-Aug-02 9:18

includeh10

1-Aug-02 9:18

in NT, we can use CreateFile("c:\\Myfolder") to open a folder handle then do something with it (i.e. monitor it), it is very useful.

do u know is there a similar way for win9x?

thx.

includeh10

a simple database question

ns1-Aug-02 9:08

1-Aug-02 9:08

I want to get the names of all the field in the database. How do I do this?

Also, when the rs is returned, and it contains say 7 records, can I ask for record #5? How do I do this? I need to access the records by the index they hold in the returned recordset (0-6). Is there a natural indexing that is available to me?

Thanks,
ns

Re: a simple database question

achandra0071-Aug-02 9:14

achandra007

1-Aug-02 9:14

Depending on what you are using, (SQL Query vs. Stored proc), GetRowsFetched() usually returns the number of rows fetched (presuming you are using Bulk Row fetching).

GetODBCFieldCount() gets the number of fields (columns).
GetODBCFieldInfo() gets the field info into a CODBCFieldInfo structure.

SetRowsetCursorPosition(DWORD row) will set the position to a specific row.

ashish

Re: a simple database question

ns1-Aug-02 9:18

1-Aug-02 9:18

Great> fieldInfo has embedded in it what I need. Many thanks!
ns

Using stored procs with CRecordset

achandra0071-Aug-02 8:53

achandra007

1-Aug-02 8:53

I have a problem:

I am trying to use stored procedures that return rows of data but not as output parameters.

When I execute the simplest of these with CRecordset derived class, I get a return status of -1 (which is what return_status is set to originally).

Is there any way to get the data returned by a stored proc without using output parms? I am using a CRecordset derived class.

Thanks
ashish

Adding text in another application

Baatezu1-Aug-02 8:33

Baatezu

1-Aug-02 8:33

I am trying to interface with another application and I want to add text to a edit box in it. I have the HWND for the window but I can't figure out how to get text to show in the box.
I have tried to use WM_SETTEXT, but that isn't working. Is there another way I should be looking for to do this? Thanks.

Quinn

Re: Adding text in another application

Joaquín M López Muñoz1-Aug-02 8:42

Joaquín M López Muñoz

1-Aug-02 8:42

Is the HWND you've got the handle of the editbox, or of its parent?

Joaquín M López Muñoz
Telefónica, Investigación y Desarrollo

Re: Adding text in another application

Baatezu1-Aug-02 8:43

Baatezu

1-Aug-02 8:43

I have both the handle to the parent and the handle to the control. I use FindWindow to get the parent and FindWindowEx to get the control HWND.

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