syntax for where clause of select query in vc++ MFC

Question

0.00/5 (No votes)

See more:

I am implementing Project in vc++ 12 MFC. back-end is access database. I want to select all four columns values in one row into four variable.

My query is:

C++

m_txt = "select CompanyName As m_CompanyName, Model As m_Model, OrderNo As m_OrderNo, StreetAddress As m_StreetAddress , Phone As m_Phone, Logo As lg1 from Companies

and I also want to get know how to specify where clause here as

C++

m_txt = "select CompanyName As m_CompanyName, Model As m_Model, OrderNo As m_OrderNo, StreetAddress As m_StreetAddress , Phone As m_Phone, Logo As lg1 from Companies where CompanyName="+s1;

That's how we write query in MySql or Sql server, s1 is variable of string type but in vc++ at + sign it gives error.

please help,it is very urjent

Posted 7-Jan-16 18:34pm

Kishor-KW

Updated 8-Jan-16 0:11am

v4

Add a Solution

Comments

Maciej Los 8-Jan-16 3:13am

How do I concatenate multiple C++ strings on one line? - Stack Overflow[^]
strcat - C++ Reference[^]
String.Concat Method (String, String) (System)[^]

Kishor-KW 8-Jan-16 3:51am

if I do concatenation then it will directly concatenate s1 with query, not the the value of s1.

Jochen Arndt 8-Jan-16 5:18am

What type has the variable m_txt and if it is a char pointer how is memory allocated?

Kishor-KW 8-Jan-16 6:08am

it is of CString type variable, Editbox member variable.

Kishor-KW 8-Jan-16 6:12am

It is a MFC application

Kishor-KW 8-Jan-16 6:20am

On selectchange of listbox I take value of selectedtext into s1 variable which is of type CString. I have to retrive all values in the row of s1(which is entry in on column's row)

int row = m_list.GetCurSel();
if (row < 0)
return;
CString s1;
m_list.GetText(row, s1);

2 solutions

Solution 2

As i mentioned in the comment to the question, all you need to do is to concatenate string!

Go back to C++ basics!

On the other hand, here is a tutorial about Developing Access 2007 Solutions with Native C or C++[^]
How To Invoke a Parameterized ADO Query Using VBA/C++/Java[^]

More resources:
Data Access in Visual C++[^]
Using the CDatabase class to read an Access databases[^]
Retrieving, Writing, and Creating Data in a Microsoft Access File (CDaoDatabase and CDaoRecordset)[^]

Next time, please use "Improve question" widget instead posting another one.

Posted 7-Jan-16 23:54pm

Maciej Los

Comments

Kishor-KW 8-Jan-16 6:22am

Thanks for reply but I already go through all links.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2016-01-07T22:35:00

Solution 1

This is a duplicate of select query to select data into variable in vc++[^], which I already responded to. Please do not repost the same question, it just duplicates work for people.

And, no, it is not urgent.

Posted 7-Jan-16 22:35pm

Richard MacCutchan