Re: Transparent drawing - C / C++ / MFC Discussion Boards

Re: CRecordSet ? - adding new records [modified]

ddmcr3-Oct-05 5:33

ddmcr

3-Oct-05 5:33

I've added next code in TRY block

...
CString name,surname;
name="Jon";
surname="Doe";
int nID=200;
SqlString.Format("INSERT INTO Table1 (ID,Name,Surname) VALUES (%d,%s,%s)",nID,name,surname);

database.ExecuteSQL(SqlString);
...

but i get exception thrown , with message box : "Database error. Too few parameters.Expected 2"

after i modified the code like this :

SqlString = "INSERT INTO Table1 (ID,Name,Surname) VALUES ('200','jon','doe') ";

everything is ok ,do you know whats wrong with the previous code Confused | :confused:

thanks for help Cool | :cool:

[Fixed]

I found out why exception was thrown.
Instead of :

SqlString.Format(_T("INSERT INTO Recordset_name(ID,Name,Surname) VALUES<br />
(%d,%s,%s)"),i_ID,c_Name,c_surname);

I had to write :

SqlString.Format(_T("INSERT INTO Recordset_name(ID,Name,Surname) VALUES<br />
('%d','%s','%s')"),i_ID,c_Name,c_surname);

"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill

-- modified at 15:50 Monday 3rd October, 2005

Re: CRecordSet ? - adding new records

hairy_hats3-Oct-05 5:24

hairy_hats

3-Oct-05 5:24

Hi Giorgi,

I use http://www.codeproject.com/database/caaadoclass1.asp[^]

With those classes, you first need to open a transaction in CADODatabase, then call AddNew in CADORecordset, then call CommitTransaction in CADODatabase to commit the changes to the database. Your classes might be similar. You also need to make sure that you have select and editing privileges in the database!

HTH.

Re: CRecordSet ? - adding new records

ddmcr3-Oct-05 5:54

ddmcr

3-Oct-05 5:54

thanks

I'll take a look

"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill

Re: CRecordSet ? - adding new records

Ghasrfakhri3-Oct-05 5:41

Ghasrfakhri

3-Oct-05 5:41

Hi To add new Record
1. open RecordSet
2. Call AddNew()
3. Assign values to field variables (rs.m_Name = "John";)
4. Call Update()
but in this case I think your Recordset is readonly,you most open it using ODBC or DSN.
Iman Ghasrfakhri

-- modified at 11:41 Monday 3rd October, 2005

Re: CRecordSet ? - adding new records

ddmcr3-Oct-05 5:51

ddmcr

3-Oct-05 5:51

Ghasrfakhri wrote:
(rs.m_Name = "John";)

thanks but,

I don't know how to declare m_Name variable and bind it to "Name" Field

"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill

-- modified at 11:52 Monday 3rd October, 2005

Re: CRecordSet ? - adding new records

Ghasrfakhri3-Oct-05 5:57

Ghasrfakhri

3-Oct-05 5:57

if you use VS 6.0 use Class Wizard to create a new class With bass CRecordset class, the CW ask you about your DB select DAO & select your DB. it do that for you.
& if you use VS .Net Choose Create new Class & Select ODBC classes, it is the same.

Iman Ghasrfakhri

Transparent drawing

Jagadeesh VN3-Oct-05 2:55

Jagadeesh VN

3-Oct-05 2:55

Hi,

I have two tiff images and I am loading them into CBitmap using GDI Bitmap class. I am using one of the image to paint the background of a dialog and its working fine. Now I would like to use the second image to draw on top of the first. The second image has some transaparent areas and those areas should be replaced with the image in the back( first image).

I tried several examples in Codeproject, But I am getting the transaparent area filled with blue.

Can someone pl. guide me on doing this.

Thanks
San

"A robust program is resistant to errors -- it either works correctly, or it does not work at all; whereas a fault tolerant program must actually recover from errors."

Re: Transparent drawing

vikas amin3-Oct-05 3:24

vikas amin

3-Oct-05 3:24

Try to create a new view which is
overlapped on the dialogbox.
The first image should be in CStatic
control.
The second image should be manually
drawn on the view by editing the
function OnDraw(CDC* pDC).
This might work but dont know about
the windows message realted to it.

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

Re: Transparent drawing

C^hris L^osinger3-Oct-05 6:28

C^hris L^osinger

3-Oct-05 6:28

try article Q79212 in the MSDN

Cleek | Image Toolkits | Thumbnail maker

Re: Transparent drawing

Lane Yu3-Oct-05 19:22

Lane Yu

3-Oct-05 19:22

Maybe you can use TransparentBlt() in NT. This is an easiest way to paint with a transparent color.

word addin

a0kboy3-Oct-05 2:12

a0kboy

3-Oct-05 2:12

Hi there,
I have an addin to ms Word written in visual c++ implementing the IDTExtensibility2 interface.
I sink events properly and launch my functions...
My question is..how can I call those functions from a different c++ project?(that should be possible)
need I to register them as word native functions, can I use messages to call them?...

thanks and happy codding
AB.

Bitmap dialog

rajeev823-Oct-05 2:04

rajeev82

3-Oct-05 2:04

Hello Friends,
I'm developing an application in which there are few dialog boxes and i decided to make them colourful using bitmaps,So i used the OnEraseBkGnd function to load the bitmaps .but there was an mismatch between the dialog size and bitmap size so i decided to capture the size of the dialog and the bitmap,after which i repainted the dialog calling the BitBlt function many number of times.
Is there anyother way to load the bitmaps so that i dont have to call the BitBlt function more than once.I've attached the piece of code what i'm using now.it'd be great if someone could help me in this...
BOOL dialog::OnEraseBkgnd(CDC* pDC)
{

CBitmap bmp;
CBitmap *ptrBmpOld;
CDC dcMemory;
BITMAP bm;
CRect rect;
int i, j;
int nHor, nVer;
bmp.LoadBitmap(IDB_BITMAP1);
bmp.GetBitmap(&bm);
GetClientRect(rect);
nHor=rect.Width()/bm.bmWidth+1;
nVer=rect.Height()/bm.bmHeight+1;
dcMemory.CreateCompatibleDC(pDC);
ptrBmpOld=dcMemory.SelectObject(&bmp);
for(i=0; i<nhor; i++)
{
for(j="0;" j<nver;="" j++)
{
pdc-="">BitBlt
(
i*bm.bmWidth,
j*bm.bmHeight,
bm.bmWidth,
bm.bmHeight,
&dcMemory,
0,
0,
SRCCOPY
);
}
}
dcMemory.SelectObject(ptrBmpOld);
return TRUE;
}

Rajeev

-- modified at 8:05 Monday 3rd October, 2005

Re: Bitmap dialog

Mircea Puiu3-Oct-05 2:28

Mircea Puiu

3-Oct-05 2:28

You could use CStatic objects, to which you set the bitmaps using SetBitmap(HBITMAP hBitmap)

SkyWalker

-- modified at 8:28 Monday 3rd October, 2005

Re: Bitmap dialog

vikas amin3-Oct-05 2:51

vikas amin

3-Oct-05 2:51

Hey Rajeev
How ru ?

Just dont use any type of coding .
Put a CStatic control for displaying
the bitmap u want.
This will be more siple .

enjoy

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

Re: Bitmap dialog

vikas amin3-Oct-05 3:40

vikas amin

3-Oct-05 3:40

Yeh ur true Rajeev
As the the OnEraseBkgnd will be oftenly called
if ur going to do BitBlt in that function the
5speed will be slow .
Have u tried to use the same code with OnDraw
member function.
U can aslo try to add the code on WM_INITDIALOG.

take care
send me the feedback when u have dont it. Blush | :O

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

how many message maps in MFC

Santosh Kumar793-Oct-05 1:52

Santosh Kumar79

3-Oct-05 1:52

how many message maps in MFC
please give me answer.

Thank you CodeProject Smile | :)

Re: how many message maps in MFC

toxcct3-Oct-05 2:01

toxcct

3-Oct-05 2:01

to get an answer, you might ask a correct question...

Santosh Kumar79 wrote:
please give me answer.
please give me a question to answer...
D'Oh! | :doh:

TOXCCT >>> GEII power
[toxcct][VisualCalc]

-- modified at 3:20 Tuesday 4th October, 2005

Re: how many message maps in MFC

David Crow3-Oct-05 2:44

David Crow

3-Oct-05 2:44

Have you looked through MFC's source files?

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

Re: how many message maps in MFC

vikas amin3-Oct-05 3:09

vikas amin

3-Oct-05 3:09

Pls explain in Detail ???

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

Re: how many message maps in MFC

Ghasrfakhri3-Oct-05 5:52

Ghasrfakhri

3-Oct-05 5:52

Too many.

Search WM_ messages in MSDN you can get your answer Wink | ;)

Iman Ghasrfakhri

Re: how many message maps in MFC

Prakash Nadar3-Oct-05 6:41

Prakash Nadar

3-Oct-05 6:41

3 I guess. 1 for CDialog and 1 for CWnd and 1 for hummm. dont know.

-prakash

Re: how many message maps in MFC

Jose Lamas Rios3-Oct-05 15:47

Jose Lamas Rios

3-Oct-05 15:47

--
jlr
http://jlamas.blogspot.com/[^]

Re: how many message maps in MFC

ThatsAlok3-Oct-05 17:50

ThatsAlok

3-Oct-05 17:50

Jose Lamas Rios wrote:
42

Hi Jose....how you reach to the fiqure of 42? Poke tongue | ;-P

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers,
Alok Gupta
VC Forum Q&A :- I/ IV

Re: how many message maps in MFC

Jose Lamas Rios3-Oct-05 20:08

Jose Lamas Rios

3-Oct-05 20:08

ThatsAlok wrote:
Hi Jose....how you reach to the fiqure of 42?

Probably a bad joke, but since you ask... Smile | :)

I asked Deep Thought, of course!

"I checked it very thoroughly," said the computer, "and that quite definitely is the answer. I think the problem, to be quite honest with you, is that you've never actually known what the question is."

See The Answer to Life, the Universe, and Everything[^]

--
jlr
http://jlamas.blogspot.com/[^]

Re: how many message maps in MFC

ThatsAlok3-Oct-05 20:40

ThatsAlok

3-Oct-05 20:40

Jose Lamas Rios wrote:
See The Answer to Life, the Universe, and Everything[^]

Great Smile | :)

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers,
Alok Gupta
VC Forum Q&A :- I/ IV

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