C / C++ / MFC

Excel works in one app but not another

6-Dec-06 17:23

celllllllll wrote:
Now, I wonder what should be added before "COIN coin" so that when okay is pressed it should perform ENABLE or DISABLE...

If the if(...) condition evaluates to false, it is already doing that.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

Re: need help MFC

celllllllll7-Dec-06 12:31

celllllllll

7-Dec-06 12:31

I got it worked..Thanks

C++Prog

Re: need help MFC

prasad_som6-Dec-06 17:54

prasad_som

6-Dec-06 17:54

As said by David, its done already, Is something other you want ?

Prasad
Notifier using ATL | Operator new[],delete[][^]

BuckBrown6-Dec-06 8:39

BuckBrown

6-Dec-06 8:39

I am using Visual C++ 6.0 MFC on Windows 2000. I have an application that automates Excel and populates the cells with data. I have another application that I need to automate Excel and I have included the excel9.h and excel9.cpp files into the project. I copied the variable declarations and the function that starts excel and gets the application object from the application that already is automating excel. Here is my problem. In the existing application the app.CreateDispatch("Excel.Application") function works fine, but in the new application this same instruction fails. Anyone have any ideas as to what is going on here?

Buck

Re: Excel works in one app but not another

C^hris L^osinger6-Dec-06 9:32

C^hris L^osinger

6-Dec-06 9:32

first thing i always check: did you call CoInitialize in your app's InitInstance (or at least before you call any COM calls) ?

image processing | batch image processing | blogging

Re: Excel works in one app but not another

David Crow6-Dec-06 10:05

6-Dec-06 10:05

BuckBrown wrote:
...but in the new application this same instruction fails.

With what error(s)? The second argument to CreateDispatch() is a COleException pointer. What does its m_strSource and m_strDescription members indicate?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

file location problem

Kim06186-Dec-06 5:52

Kim0618

6-Dec-06 5:52

Hi,

I want to store the location of a file in C# program, but
the file may be moved into another location. So besides using
the File System Watcher, can I store other information of the file
instead of the location, so that the shell or window can recognize
the file by the stored info and give me the new location information ?

Thanks

toxcct6-Dec-06 6:12

toxcct

6-Dec-06 6:12

you wanted to do this in C#, so you told yourself that the C++ forum would be the best place, hum ?
ask here[^] instead.

(and please delete your post if you read this, using the "Delete" link at the bottom of it)

[edit]
you asked the C# forum first, and then asked the C++ forum for this ?! OMG | :OMG:

shame on you !!!
you'd better read what is behind the "links for newbies" in my sig, they seem to apply to you perfectly.
[/edit]

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

S Douglas9-Dec-06 1:30

S Douglas

9-Dec-06 1:30

toxcct wrote:
Don't know where to start ?
Refer the Forums Guidelines and ask a friend

Great Sig, clasic! Smile | :)

I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

toxcct9-Dec-06 2:42

toxcct

9-Dec-06 2:42

i was tired of repeating always and always the same things... lol

but thanks Wink | ;)

Don't know where to start ?
Refer the Forums Guidelines and ask a friend

[VisualCalc 3.0][Flags Beginner's Guide]

Query doesn't work in ExecuteSQL

Hamid_RT6-Dec-06 17:50

Hamid_RT

6-Dec-06 17:50

Wrong forum this is VC++ forum not C# Smile | :)

WhiteSky

prithaa6-Dec-06 5:33

6-Dec-06 5:33

Hello,

The following is the code where I get an error

CDatabase CurrentDatabase;
CString str = "UPDATE Table1 SET ROLLNO = 45;";
CurrentDatabase.ExecuteSQL(str);

Above code gives an error
"Operation must use an updateable query"

Any ideas what went wrong with the query.The same query works in access but gives an error in VC++.
Is this the right forum to ask about it.

Thanks
Prithaa

Mark Salsbery6-Dec-06 6:19

Mark Salsbery

6-Dec-06 6:19

Is the database opened read-only?

David Crow6-Dec-06 10:12

6-Dec-06 10:12

Don't you have to call CDatabase's OpenEx() or Open() method in there someplace?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

prithaa6-Dec-06 18:43

6-Dec-06 18:43

Hello,

Thanks for the reply.

But the problem is not with Open since if it was not open, it would have opened a dialog for ODBC connection to open a database.
The error says
"The operation must use an updateable query"
The same query works with Access

Prithaa

Mark Salsbery7-Dec-06 6:34

Mark Salsbery

7-Dec-06 6:34

prithaa wrote:
The same query works with Access

How is that possible? In the code you posted there's no way the CDatabase object can know which
database to perform the query on.

If you Google the error "The operation must use an updateable query" you'll find that the most
common reason is database opened read only. You haven't shown how you open the database.

Mark

Hamid_RT6-Dec-06 17:49

Hamid_RT

6-Dec-06 17:49

Is it all your code?

WhiteSky

prithaa6-Dec-06 19:02

6-Dec-06 19:02

Hello,

CDatabase C;CString D="Students";
C.Open(_T(D),FALSE,TRUE,_T("ODBC"));
CRecordset R;
R.Open(dbOpenDynaset,_T("SELECT * FROM Table1"));
CString str = "UPDATE Table1 SET ROLLNO = 45";
C.ExecuteSQL(str);
R.Close();

The above is the full code.
Thanks for your reply
Prithaa

prithaa6-Dec-06 19:11

6-Dec-06 19:11

Hello,

Sorry to have bothered
I got my mistake.My Database was opened readonly so the query was not able to update the records

Thanks
PRithaa

Hamid_RT6-Dec-06 20:56

Hamid_RT

6-Dec-06 20:56

I glad you find it Smile | :)

WhiteSky

David Crow7-Dec-06 2:43

7-Dec-06 2:43

prithaa wrote:

The above is the full code.

So why didn't you show this in your initial post? Roll eyes | :rolleyes:

It's plain to see that the CDatabase object was opened as read-only.

prithaa wrote:
C.ExecuteSQL(str);

Should have been:

if (R.CanUpdate())
    C.ExecuteSQL(str);

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb