C / C++ / MFC

Ken Goguen20-Sep-01 9:50

Ken Goguen

20-Sep-01 9:50

Good practice, but didn't resolve the problem.

-kg

Ken Goguen
Principle Design Engineer
EMC Corporation

Tomasz Sowinski20-Sep-01 9:29

Tomasz Sowinski

20-Sep-01 9:29

The code you've posted only inserts a root item. And TVIF_CHILDREN flag is ignored during inserts. It works when you're getting information about the item with GetItem.

BTW: why are you using a InsertItem overload that takes TVINSERTSTRUCT - there are more convenient versions.

Tomasz Sowinski -- http://www.shooltz.com

Ken Goguen20-Sep-01 9:53

Ken Goguen

20-Sep-01 9:53

There is additional code that adds the other nodes, but using message windows I've been able to determine that the expand problem occurs on the first insert.

Only using the overload as it was part of an old example I began with. Do you think this could be part of the problem?

-kg

Ken Goguen
Principle Design Engineer
EMC Corporation

Tomasz Sowinski20-Sep-01 9:57

Tomasz Sowinski

20-Sep-01 9:57

There are many fields in TVITEM struct, which is a member of TVINSERTSTRUCT. You may have overlooked one of them. Give other overloads a try - they are easier to use and understand.

Tomasz Sowinski -- http://www.shooltz.com

Ken Goguen20-Sep-01 10:12

Ken Goguen

20-Sep-01 10:12

I simplified as follows and it seems to have done the trick. Thanks.

HTREEITEM hTreeItem = pMyTree->InsertItem(_T(buffer),0,0,NULL, TVI_LAST);

Big Grin | :-D

-kg

Ken Goguen
Principle Design Engineer
EMC Corporation

DLL Question

#realJSOP20-Sep-01 9:03

#realJSOP

20-Sep-01 9:03

I'm working on a non-MFC DLL (that doesn't have a DllMain). I need to get the HINSTANCE of this DLL (for use inside the DLL). How do I do that?

I can't use AfxGetInstance().

Re: DLL Question

Tomasz Sowinski20-Sep-01 9:15

Tomasz Sowinski

20-Sep-01 9:15

If your DLL doesn't have DllMain, it must have other entrypoint with identical set of parameters. 1st param is HINSTANCE you're looking for - just store the value in global variable.

Tomasz Sowinski -- http://www.shooltz.com

OleAutomation

duggie20-Sep-01 8:43

20-Sep-01 8:43

I am new to OleAutomation. I am trying to execute an Access macro from VC++. I believe I am missing something. It doesn't work. The code is attached below.

_Application oAccess;
IDoCmd cmd;
LPDISPATCH lpDisp;

/////////////////////////////////////////////////////////////////////////////
// CTemp1App initialization

BOOL CTemp1App::InitInstance()
{
// Initialize OLE libraries
if (!AfxOleInit())
{
AfxMessageBox(IDP_OLE_INIT_FAILED);
return FALSE;
}

if (!oAccess.CreateDispatch("Access.Application"))
{
AfxMessageBox("Couldn't CreateDispatch on Access");
}

oAccess.OpenCurrentDatabase("S:\\Ses\\User\\VKaruppiah\\Upfitter97.mdb", FALSE);

COleVariant macroName = "GMDIDProcessing";
COleVariant repeatCount = "";
COleVariant repeatExp = "";
cmd.RunMacro(macroName, repeatCount, repeatExp);

cmd.ReleaseDispatch(); // Release the object-IDispatch binding.
oAccess.ReleaseDispatch();
cmd = NULL; // Destroy the object references.
oAccess = NULL;

}

Any help would be greatly appreciated.

Thanks,
Confused | :confused:

Michael P Butler20-Sep-01 10:34

Michael P Butler

20-Sep-01 10:34

Which bit of code fails? Have you put any try and catch code around the COM calls to access.

Michael Smile | :)

duggie20-Sep-01 10:52

20-Sep-01 10:52

The code does not fail anywhere. But it doesn't run the macro either. The line that is giving me trouble is

cmd.RunMacro(macroName, repeatCount, repeatExp);

If I put a watch on cmd after executing this line, m_lpDispatch value = "Error expression cannot be evaluated".

Any ideas/suggestions would be appreciated.

Thanks,

Michael P Butler20-Sep-01 10:55

Michael P Butler

20-Sep-01 10:55

put a try and catch around the RunMacro and see what error it returns

try
{
cmd.RunMacro(macroName, repeatCount, repeatExp);
}
catch(CException& e)
{
}

Carlos Antollini20-Sep-01 10:53

Carlos Antollini

20-Sep-01 10:53

Yes you need to acces to the CommandInterfase from the database interfase.
Something like this

lpDisp = oAccess.GetCommands(); //Get an IDispatch pointer. I think 
                                //that Here is your problem
ASSERT(lpDisp);            
cmd.AttachDispatch(lpDisp);

Note: I don't know if the method is GetCommand or something like this.

Best Regards!!!

Carlos Antollini.

duggie24-Sep-01 10:09

24-Sep-01 10:09

Hi,

I did add the above lines in the program but it doesn't solve it. The method is GetDoCmd() which is what I used. May be I am including these lines in the wrong place. Attached below is my code. Any idea what I am doing wrong?

if (!oAccess.CreateDispatch("Access.Application"))
{
AfxMessageBox("Couldn't CreateDispatch on Access");
}

oAccess.OpenCurrentDatabase("S:\\Ses\\User\\VKaruppiah\\Upfitter97.mdb", FALSE);

COleVariant macroName = "GMDIDProcessing";
COleVariant repeatCount = "";
COleVariant repeatExp = "";
lpDisp = oAccess.GetDoCmd(); //Get an IDispatch pointer. I think
//that Here is your problem
ASSERT(lpDisp);
cmd.AttachDispatch(lpDisp);
cmd.RunMacro(macroName, repeatCount, repeatExp);
oAccess.CloseCurrentDatabase();
cmd.ReleaseDispatch(); // Release the object-IDispatch binding.
oAccess.ReleaseDispatch();

cmd = NULL; // Destroy the object references.
oAccess = NULL;

Thanks,

Carlos Antollini25-Sep-01 9:15

Carlos Antollini

25-Sep-01 9:15

I don't have a MS Access in my work but I promise that I can see your problem in my home. If you want that, please send me the mdb file to carlos.antollini@nixor.com.ar.

Bests Regards. Big Grin | :-D

Carlos Antollini.

duggie28-Sep-01 8:09

28-Sep-01 8:09

Hi,

For data sensitivity reasons, I won't be able to send you the actual database. But I can give you a good feel for what is in the database. Some tables and a macro that has 2 steps. TransferText (this file xxx.txt that gets loaded into the database)and OpenQuery (opens a query and loads the result data into a table). I want to execute this Macro from VC++ through OleAutomation.

Your help is very much appreciated.

Thanks,