C / C++ / MFC

3-Oct-05 3:22

Hello everybody,
I have next problem :

I have a MFC Dialog based application and i am retrieving some info from a *.mdb database using CDatabase and CRecordSet classes. I am doing this without any problems.
But my question is how to add a new record in this database ?
My code looks like this :

CDatabase database;
CString   sSQL;
CString   sName,sSurname,sID;
CString   sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)";
CString   sFile = "c:\\db1.mdb";
CString   sDsn;
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);

TRY
	{
		database.Open(NULL,false,false,sDsn);
		CRecordset recset( &database );
                // Here i want to add for example new record
                // "ID=5" , "Name=Jon" , "Surname =Doe ".
		database.Close();
	}
CATCH(CDBException, e)
	{
		// If a database exception occured, show error msg
		AfxMessageBox("Database error: "+e->m_strError);
	}
END_CATCH;

I guess i'm supposed to use AddNew() ,Requiry(),Update() functions.

MSDN says : "AddNew prepares a new, empty record using the recordset's field data members. After you call AddNew, set the values you want in the recordset's field data members. " - how can i set the values ???

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

-- modified at 9:22 Monday 3rd October, 2005

vikas amin3-Oct-05 3:54

3-Oct-05 3:54

Hi how ru
this is Vikas again

put this code in the Try block
CString SqlString;
// write the query and attach to the SqlString
database.ExecuteSQL(SqlString);

This is the simple way but i dont think u have
a static data , Meaning u r going to get data
from the user and then add it to the database
right for that u need to use format string that
is bit syntatic .

ok
take care

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

ddmcr3-Oct-05 4:06

3-Oct-05 4:06

could you be more explicit?
can you provide sample code ?

thanks

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

-- modified at 10:14 Monday 3rd October, 2005

vikas amin3-Oct-05 4:36

Re: CRecordSet ? - adding new records [modified]

3-Oct-05 4:36

Try to use the query i have given u
in this code in the TRY block

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

database.Exectue(SqlString);

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

ddmcr3-Oct-05 5:33

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

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.

ddmcr3-Oct-05 5:54

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

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

ddmcr3-Oct-05 5:51

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

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

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