C / C++ / MFC

Run an Oracle script Using VC++

12-Jan-02 1:13

check out colevariant.changetype();

---
"every year we invent better idiot proof systems and every year they invent better idiots ... and the linux zealots still aren't being sterilized"

roysivan12-Jan-02 0:29

roysivan

12-Jan-02 0:29

How can I run an oracle script which is stored in file using VC++
Smile | :)

Re: Run an Oracle script Using VC++

l a u r e n12-Jan-02 1:15

12-Jan-02 1:15

using sql7 i spawn a process to run the osql utility which a command line sql query thingy ... pass it the filename as a command line argumant and voila!

i would assume oracle has something similar

---
"every year we invent better idiot proof systems and every year they invent better idiots ... and the linux zealots still aren't being sterilized"

very Urgent

11-Jan-02 22:20

Hi,

I used this code to get the no of tables in a database.
But I am not getting the table count.Plese check this code

{

CDaoDatabase db;
db.Open ("D:\\San\\data.mdb");
int p=db.IsOpen ();
int x=db.GetTableDefCount();

char n[10];
sprintf(n,"%d",x);

AfxMessageBox(n);

CDaoTableDefInfo ptr;
db.GetTableDefInfo(0,ptr,AFX_DAO_PRIMARY_INFO );

CString str;
str=ptr.m_strSrcTableName ;

AfxMessageBox(str);
}

Nish Nishant11-Jan-02 22:29

11-Jan-02 22:29

What do you mean by saying you are not getting the table count? Do you mean to say you get zero always? Or that you get some kinda error?

Nish

Sonork ID 100.9786 voidmain
www.busterboy.org
If you don't find me on CP, I'll be at Bob's HungOut

11-Jan-02 22:43

I am alwys getting an integet value 5 .When I checked like this I am getting the the value of m_StrName as MSysACEs.

{

db.GetTableDefInfo(0,ptr,AFX_DAO_PRIMARY_INFO );
CString str;
str=ptr.m_strName ;
}
AfxMessageBox(str);

SSN

Christian Graus12-Jan-02 1:21

12-Jan-02 1:21

The above code can work only of str is also defined higher up. The one you define to ptr.m_strname is going out of scope before the AfxMessageBox call.

By the way, has it occured to you that naming every post 'very urgent' is both unimaginative and annoying ?

Christian

I have come to clean zee pooollll. - Michael Martin Dec 30, 2001

Sonork ID 100.10002:MeanManOzI live in Bob's HungOut now

Nish Nishant12-Jan-02 3:02

Re: RECT Problem..[edited]

12-Jan-02 3:02

Christian Graus wrote:
By the way, has it occured to you that naming every post 'very urgent' is both unimaginative and annoying

Well, I donno abt him, but I bet its annoyed everyone else here Smile | :)

Nish

Sonork ID 100.9786 voidmain
www.busterboy.org
If you don't find me on CP, I'll be at Bob's HungOut

RECT Problem..

Neha11-Jan-02 21:18

Neha

11-Jan-02 21:18

Hi,
I have 2 objects derived from RECT
as RECT normal_rect;
RECT zoomed_rect;
There is an image displayed in normal_rect area.
same image in zoomed state will be displayed in zoomed_rect area.If i resize the zoomed_rect.it should be reflected in the normal image.
I would like to know is there way to map between 2 RECTs?

Regards
Neha

Nish Nishant11-Jan-02 21:45

11-Jan-02 21:45

zoomed_rect.left=NORMAL_RECT.left*ratio
zoomed_rect.top=NORMAL_RECT.top*ratio
zoomed_rect.right=NORMAL_RECT.right*ratio
zoomed_rect.bottom=NORMAL_RECT.bottom*ratio

Sonork ID 100.9786 voidmain
www.busterboy.org
If you don't find me on CP, I'll be at Bob's HungOut

Re: RECT Problem..

Christian Graus12-Jan-02 1:22

12-Jan-02 1:22

Do you really mean *= ?

Christian

I have come to clean zee pooollll. - Michael Martin Dec 30, 2001

Sonork ID 100.10002:MeanManOzI live in Bob's HungOut now

Re: RECT Problem..

Nish Nishant12-Jan-02 2:58

Setting background color of a checkbox

12-Jan-02 2:58

OOps!!!!

Thanks.
I'll go edit it now

Nish

Sonork ID 100.9786 voidmain
www.busterboy.org
If you don't find me on CP, I'll be at Bob's HungOut

Bobby Ward11-Jan-02 20:52

Bobby Ward

11-Jan-02 20:52

How would you go about setting a background brush of a checkbox button?

WM_CTLCOLORBTN doesn't work with checkboxes and i can't seem to find any other way beside drawing a checkbox myself. Frown | :(

Nish Nishant11-Jan-02 21:34

11-Jan-02 21:34

Override OnCtlColor and do this inside that :-

HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	if(pWnd->GetDlgCtrlID()==IDC_CHECK1)
	{
		pDC->SetBkColor(RGB(255,0,0));
	}
	// TODO: Return a different brush if the default is not desired
	return hbr;

Nish

Sonork ID 100.9786 voidmain
www.busterboy.org
If you don't find me on CP, I'll be at Bob's HungOut

Bobby Ward12-Jan-02 1:10

Bobby Ward

12-Jan-02 1:10

.....without using MFC.

l a u r e n12-Jan-02 1:16

12-Jan-02 1:16

mfc just traps the wm_ctlcolor message afaik so do the same thing in that handler i would assume

---
"every year we invent better idiot proof systems and every year they invent better idiots ... and the linux zealots still aren't being sterilized"

Bobby Ward12-Jan-02 11:29

Bobby Ward

12-Jan-02 11:29

There is no wm_ctlcolor message. There's WM_CTLCOLORBUTTON, WM_CTLCOLOREDIT, WM_CTLSOLORSTATIC.......

Christian Graus12-Jan-02 11:39

Save device context to file

12-Jan-02 11:39

WM_CTLCOLOR has the value 0x0019.

Christian

I have come to clean zee pooollll. - Michael Martin Dec 30, 2001

Sonork ID 100.10002:MeanManOzI live in Bob's HungOut now

11-Jan-02 20:28

I'm still trying to learn this whole device context stuff in windows.

Here is my Visual C++ 6.0 problem with an MFC application: I've got some DC that has some stuff drawn to it, and I want to output said DC (or actually just a portion of it) to a .bmp file. How in the world would I do this?

Re: Save device context to file

Christian Graus12-Jan-02 1:23

12-Jan-02 1:23

You actually want to output the bitmap that is selected into the DC, and the answer is in the FAQ.

Christian

I have come to clean zee pooollll. - Michael Martin Dec 30, 2001

Sonork ID 100.10002:MeanManOzI live in Bob's HungOut now

SQL Server

Mazdak11-Jan-02 18:26

Mazdak

11-Jan-02 18:26

I used SQL server to design database for my application,I use this line of code to make connection:

hr = m_pConnection->Open(L"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Name;",L"",L"",-1);

and everythings work properly.

Because I want to use this application on another computer and deploy a package for it,
I think I should changed the "Open" function .I used this but it does not work:

hr = m_pConnection->Open(L"Provider=SQLOLEDB.1;Data Source=D:\\MSSQL7\\Data\\Name_Data.MDF;",L"",L"",-1);

(SQL server make "Name_Data.mdf" for my database).Should I use this file?What should I change in my code
to use my application in another computer?

Re: SQL Server

l a u r e n11-Jan-02 21:29

MFC MULTITHREADING CLIENT

11-Jan-02 21:29

i use odbc links on the client machines ... can your method not use the same?

---
"every year we invent better idiot proof systems and every year they invent better idiots ... and the linux zealots still aren't being sterilized"

11-Jan-02 18:16

i am doing an assignment related to ftpclient appication..
as a download manager.. like getright or download accelerator plus..
i have problem regarding multiple dialog box opening per thread.
if only one dialog box is opened it it is working fine,
but for multiple dialog box data of one dialog box is mixing with another one.

have any solution?

Re: MFC MULTITHREADING CLIENT

Nish Nishant11-Jan-02 20:28