Need help of how to execute SQL update query in VC++

[John502]

Hi, I have one SQL query, i want to update it in one database. Please check that SQL query below. update employee set emp_name = 'Ravi' where emp_id = 1 I know that the below query will help me to get the records count.. update employee set emp_name = 'Ravi' where emp_id = 1; Select @@Rowcount Updated But i want to execute this query through my VC++ code.. Cany one help me out how to execute this query and how to retrieve no of records updated count as return value..? Can any one help me out as it urgent requirement for me.. Thanks John.

[Code o mat]

I think you should start here[^].

> The problem with computers is that they do what you tell them to do and not what you want them to do. < > Sometimes you just have to hate coding to do it well. <

[Anil Kumar Arvapalli]

Try Like this char *name="ravi"; int index=1; CString str=_T("update employee set emp_name ="); str.format("'%s' where emp_id=%d",name,index); and pass str as argument to ur Execute query... Hope it is ur answer wat ur looking for it. Can u please tell me what are the settings that we need in project to connect to database from VC++. please share it so that it wil be help full for me please

[David Crow]

John502 wrote:

Cany one help me out how to execute this query...

Have you tried SQLExecute()?

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons