C / C++ / MFC

Re: Database work in Visual C++

3-Sep-04 7:01

Last time I checked, JOINs weren't editable.

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Imtiaz Baig3-Sep-04 7:08

Imtiaz Baig

3-Sep-04 7:08

Friend,
I am doing database work for first time in VC++. There is lots of hardwork involved as compared to Visual Basic. But i feel that i am not following right path. Are "data controls" i am using are good solution, or there is some better solution. Can i insert combo box in the cells of datagrid control or other such controls. If not then how can i make my life easy for doing database programming in Visual C++. Please suggest me the right way to follow ??

Re: Database work in Visual C++

David Crow3-Sep-04 7:14

ActiveX TypeLib Practices: property or method?

3-Sep-04 7:14

While many ways exist, some better than others, I tend to use ODBC and CDatabase/CRecordset objects. Give this section of CP a try.

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

KFournier3-Sep-04 6:28

KFournier

3-Sep-04 6:28

I write custom ActiveX controls for an application that has been slow to support ActiveX completely. In fact, only the recent release of the software claims to support the ability to modify and save ActiveX control properties during design time. So, I plopped my custom controls on a form, but no properties.

The application developers informed me that the design tools only look for properties by scanning the "methods" section of a control's type library rather than the "properties" section. Of course, my properties are all listed on "properties" because VC++ 6.0 does this automatically when you add properties via the Class Wizard.

Example: here's what my property looks like:

dispinterface _DMyControl
{
    properties:
    [id(1)] BSTR Caption;
    
    methods:
    [id(DISPID_ABOUTBOX)] void AboutBox();
};

But, here's what the application would prefer:

dispinterface _DMyControl
{
    properties:
    
    methods:
    [id(0x00000001), propget] BSTR Caption();
    [id(0x00000001), propput] void Caption([in] BSTR lpszNewValue);
    [id(DISPID_ABOUTBOX)] void AboutBox();
};

My question is: does anyone have information or an opinion on which method is preferrable? I ask because the application developers refuse to support straight "properties" on the grounds that so few controls use this paradigm. I want to know if there is a reason I should conform to using purely methods or if I should push the company to support properties.

Kevin Fournier
SRP Computer Solutions, Inc.

Hey i am looking for real MSGINA code

ThatsAlok3-Sep-04 6:21

ThatsAlok

3-Sep-04 6:21

Pls somebudy give me that,pls don't give any refrence of MS gina stub or MSgina hook i want real gina code
thanks in advance

-----------------------------
"I Think It will Work"
Formerly Known As "Alok The Programmer" at CP
-----------------------------
Alok Gupta
visit me at http://www.thisisalok.tk

Michael Dunn3-Sep-04 7:18

Michael Dunn

3-Sep-04 7:18

You want the actual source for the GINA that MS wrote and ships with the OS? Good luck.

--Mike--
Personal stuff:: Ericahist | Homepage
Shareware stuff:: 1ClickPicGrabber | RightClick-Encrypt
CP stuff:: CP SearchBar v2.0.2 | C++ Forum FAQ
----
If my rhyme was a drug, I'd sell it by the gram.

ThatsAlok3-Sep-04 19:44

ThatsAlok

3-Sep-04 19:44

Yes,With all due Respect,
sir,
I am including the Smartcard functionality to the login dialog that why i need real source code of MSGINA,as i come to know MS is giving it for free.

thanks

-----------------------------
"I Think It will Work"
Formerly Known As "Alok The Programmer" at CP
-----------------------------
Alok Gupta
visit me at http://www.thisisalok.tk

David Crow7-Sep-04 7:51

7-Sep-04 7:51

ThatsAlok wrote:
...as i come to know MS is giving it for free.

Seems to me that if you knew it was being given away for free (if that is indeed accurate), you'd also know how to obtain it. Yes?

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

ThatsAlok7-Sep-04 23:09

ThatsAlok

7-Sep-04 23:09

HI there,
Sorry i late to response to this message, i already got the mSGINA dll code in Visual STudio samples
thanks for Replying

-----------------------------
"I Think It will Work"
Formerly Known As "Alok The Programmer" at CP
-----------------------------
Alok Gupta
visit me at http://www.thisisalok.tk

excel automation!!

pnpfriend3-Sep-04 5:56

3-Sep-04 5:56

Hello All excel Automation expert,
I'm having trouble closing excel application. It physically closed.. but the TaskManager Process shows the Excel Process is still running.

The program wait for the excel application to be close by user.. it is waiting forever since the Excel process is still running. How to close the excel application totally?

Is there anyway, not closing excel application and waiting for the user to finish formating or whatever he/she has to do with the worksheet then let the user close the excel file (not excel application). As soon as program knows the user just close the excel ( again , not excel application), the program can open new excel file in the same application?
Thank you.

<br />
ReleaseAllDispatch();<br />
WaitForExcelToClose();<br />
<br />

<br />
void CDlg::WaitForExcelToClose()<br />
{<br />
    HWND hWnd;<br />
    char buf[1024];<br />
    hWnd = ::FindWindow(TEXT("XLMain"),NULL);<br />
    if(NULL==hWnd)<br />
    {<br />
      return;<br />
    }<br />
	<br />
    DWORD pid;<br />
    DWORD dThread;<br />
    DWORD dwReason;<br />
    dThread = ::GetWindowThreadProcessId(hWnd,&pid);<br />
    HANDLE hProcess;<br />
    hProcess = ::OpenProcess(SYNCHRONIZE|PROCESS_ALL_ACCESS,TRUE,pid);<br />
    pid = NULL;<br />
    dwReason = ::WaitForSingleObject(hProcess,INFINITE);<br />
    ::CloseHandle(hProcess);   <br />
}

<br />
void CDlg::ReleaseAllDispatch(){<br />
range.DetachDispatch();    <br />
pagesetup.DetachDispatch();<br />
sheet.DetachDispatch();	<br />
sheets.DetachDispatch();<br />
book.DetachDispatch();   	<br />
app.DetachDispatch();<br />
<br />
book.ReleaseDispatch();		<br />
books.ReleaseDispatch();		<br />
range.ReleaseDispatch();	<br />
pagesetup.ReleaseDispatch();    <br />
sheet.ReleaseDispatch();    <br />
sheets.ReleaseDispatch();				<br />
app.Quit();    <br />
<br />
app=NULL;		<br />
pagesetup = NULL;<br />
range = NULL;<br />
book = NULL;<br />
books = NULL;<br />
sheet = NULL;<br />
sheets = NULL;<br />
<br />
CoUninitialize();  //unintializing the OLE*/<br />
}<br />

David Crow3-Sep-04 6:11

3-Sep-04 6:11

pnpfriend wrote:
hWnd = ::FindWindow(TEXT("XLMain"),NULL);

Not a good idea to use FindWindow() as the target window could be in a blocked state, thus rendering your code "dead."

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

pnpfriend3-Sep-04 6:56

3-Sep-04 6:56

Hi Dave,
what should I use? any suggestion?

David Crow3-Sep-04 7:02

3-Sep-04 7:02

Did you use CreateProcess() or ShellExecuteEx() to start Excel?

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

pnpfriend3-Sep-04 9:02

3-Sep-04 9:02

Then, how am I going to format the excel if I used ShellExecuteEx() or CreateProcess()?

the following way is to open the excel application. If I used ShellExecuteEx() how to get an app object? if I dont have app obj, I can't get workbooks, no workbooks there will not be no workbook, sheets or sheet. I thought about using ShellExecuteEx() but I don't know how to get workbooks back after that. Any suggestion please?

<br />
CApplication app; <br />
<br />
if(!app.CreateDispatch(TEXT("Excel.Application")))<br />
    {<br />
       AfxMessageBox(TEXT("Could not create Excel Application Object."));<br />
	   open = false;<br />
    }<br />
	else<br />
	{<br />
		app.put_Visible(TRUE);       // set visible....			<br />
		app.put_WindowState(2); //wdWindowstate minimize = 2<br />
		app.put_UserControl(TRUE); // let the user control 		<br />
	<br />
books = app.get_Workbooks(); //get work books<br />
	book = books._Open(fileName, covOptional,covOptional, covOptional, covOptional, covOptional, covOptional,covOptional,covOptional,covOptional,covOptional,covOptional,covOptional); // return workbooks's IDispatch<br />
   <br />
    //Get the Sheets collectiona and attch the IDispatch pointer to your sheets object.<br />
    sheets = book.get_Sheets();<br />
      <br />
    int numofSheets =(int) sheets.get_Count(); <br />
    int index=1;<br />
    <br />
    // Get every single Sheet in the CWorksheets and attach the IDispatch pointer to your sheet object<br />
	//making sure that user wants to print <br />
	<br />
    for( index=1;index <= numofSheets;index++)<br />
    {<br />
		lpDisp = sheets.get_Item(COleVariant ((short)(index)));  //GetItem(const VARIANT &index); // get a sheet<br />
		ASSERT(lpDisp);<br />
}<br />
}<br />

David Crow3-Sep-04 9:42

3-Sep-04 9:42

pnpfriend wrote:
If I used ShellExecuteEx() how to get an app object?

You couldn't, hence my reason for clarifying exactly how you were starting the Excel application.

When I use automation with any of the Office products or Internet Explorer, I do so with the intent of there being no user interaction. If I wanted user interaction, I would use CreateProcess() or ShellExecuteEx(). What you have here seems to be the need for both automation and user interaction. Is this a fair assessment?

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

pnpfriend7-Sep-04 7:33

Activate a specific View in an MDI MFC Doc/View App

7-Sep-04 7:33

True.. I need both automation and user interaction to preview the file first then user print the file manually.

It is hard right?

Paul Steane3-Sep-04 5:28

Paul Steane

3-Sep-04 5:28

I have a VC++ 6 MDI application using the conventional MFC Doc/View architecture. At any given time there can be several different views of several different document types open.

I want to be able to programmatically "activate" one of these Views, i.e. if it is hidden by other Views then I want it to become visible, just as if the User clicked on the relevent numbered item in the Windows menu (NB this does work correctly). The specific View that is to be activated does not directly depend on User input, e.g. it could be as a result of a message from another thread.

This seems to be an obvious thing to be able to do yet I cannot make it work. I am inside a message handler within my CMainFrame class; I have a CMyView* to the View I want to activate. MDIActivate(pMyView) seems to do nothing; I can't get CMDIChildWnd::MDIActivate() to work for me.

Perhaps it is something to do with me using the above functions with a CView* not a CWnd*. Can I deduce the latter from the former in a way that will make this work? What else may be wrong?

All assistance appreciated.

Running an .exe programmatically

anderslundsgard3-Sep-04 5:13

anderslundsgard

3-Sep-04 5:13

I want to run this file C:\gzip.exe like I do in the prompt:

gzip.exe -9 C:\myfile.wrl

How can I make the call with the parameters “-9” and “C:\myfile.wrl” ?

_____________________________

...and justice for all

APe

Re: Running an .exe programmatically

David Crow3-Sep-04 6:12