C / C++ / MFC

22-Sep-06 0:10

How can i write a select SQL statement for the DB that uses the string from CEdit1 ?
lets say database name : "Names_City" class : CNames_City
col 1 : "name"
col 2 : "city"
col 3 : "country"

CString sName , sCity , sCountry;
CEdit1 : "m_name" sName;
CEdit2 : "m_city" sCity;
CEdit3 : "m_country" sCountry;

1) i have onChange for "m_name .When i write some txt in m_name i need to search in "Names_City > name = and if it matches i need the city in m_city and the country in m_country "
2)when i write in m_city and then in m_name i need to search in "name","city" and if m_name == "name" and m_city == "city" i need "country" in m_country.

* Remember i have ~260.000 Records ;

thank you in advance !

*please show me an example !

Smile | :)

Bravoone

toxcct22-Sep-06 0:13

toxcct

22-Sep-06 0:13

how many times will you ask this ?

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

Bravoone_200622-Sep-06 0:17

22-Sep-06 0:17

1000000 if i have to !
because i need help !
Laugh | :laugh:

Bravoone

toxcct22-Sep-06 0:19

toxcct

22-Sep-06 0:19

Bravoone_2006 wrote:
1000000 if i have to !

that's not how CP works...

you should really read THIS[^] first ! Suspicious | :suss:

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

Christian Graus22-Sep-06 0:22

22-Sep-06 0:22

Does it occur to you that your time could be better spent listening to the answers you have recieved ? Is this your homework ? Are you being paid to write this code ? Both of those things are OK ( although I shudder to think that you're being paid to do this ), and even if neither were true, we'd still be telling you to think for yourself. The difference is, I wonder if you're being paid, or if you have an assignment due, what you're doing with the time between questions, as you're obviously not trying to solve your problem yourself.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Hamid_RT22-Sep-06 1:19

22-Sep-06 1:19

wow he ask repeated Big Grin | :-D

WhiteSky

Christian Graus22-Sep-06 0:19

22-Sep-06 0:19

You have two realistic options.

1 - go somewhere that you can pay someone to write this for you
2 - start to listen to what people tell you, answer what they ask you, and allow yourself to be guided to a solution.

Bravoone_2006 wrote:
*please show me an example !

We really cannot. We still need to know how you're connecting to the database. We really need to know what part of this you're having trouble with. Do you not know any SQL ? Have you considered learning some in the time you've instead spent asking this over and over in this forum ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Bravoone_200622-Sep-06 0:34

22-Sep-06 0:34

ok i have try to read something but i dont understand thats way i need an example , and is for me ONLY not for money for money i do something else not programing i am hardware engineer not software !
and i want to make a program for me and i dont no . 4 hours ago i found this solution because i have try to find a solution for 2 months who can pay you 2 months to do nothing ???????

My database is on to another computer i named server !
Server ->

my computer :
ODBC -> My program !

(VisualFoxPro 6.0 database )(driver) name : "Name_City" <-on ODBC

and i still need help ! because i dont have a choice !

Bravoone

Christian Graus22-Sep-06 0:52

22-Sep-06 0:52

OK, so you're using ODBC to FoxPro ( it's coming back to me now ). You must know how to pass SQL to your database, because you're already retrieving data, right ?

The text in your CEdit box can be retrieved using GetWindowText. Then, it will be in a CString, which you can use to build your SQL query.

CString SQL = "Select * from tblName where field = '" + str + "'"

Where tblName is the table, field is the field in the table, and str is the CString you filled with GetWindowText.

That your database is on another PC is irrelevant to your ability to pass the SQL string through to it. I was more asking if you're using ADO, DAO, etc.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Bravoone_200622-Sep-06 1:02

22-Sep-06 1:02

i m not use ado,dao !
i will test what you say !
tanks !

Bravoone

Christian Graus22-Sep-06 1:04

22-Sep-06 1:04

No worries. If you substitute the right terms in that SQL, it will work.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Bravoone_200622-Sep-06 1:31

22-Sep-06 1:31

i have done this :

void CNcontabile::OnChangeName()
{

CString sCod ,csFoundCity;

CDatabase_1BunView1* pBun = new CDatabase_1BunView1();

if (!pBun->Open())
return;
if (pBun->IsOpen())
{

CString SQL = "Select * from tblName where field = '" + sCod + "'";

while(!pBun->IsEOF())
{
m_name.GetWindowText(sCod);
m_city.SetWindowText(SQL);

}

}

pBun->Close();

}

but its not work !

i have try to make this in database ! but only were can let me is : edit stored procedure in visualfoxpro 6.0 were i have the database

: Select * from tblName where field = '" + sCod + "'

but is not work were is wrong ?

Bravoone

Hamid_RT22-Sep-06 1:33

22-Sep-06 1:33

why it doesnt work?

WhiteSky

Christian Graus22-Sep-06 1:39

22-Sep-06 1:39

I"m sorry, there's a fundamental problem here, which I doubt anyone can solve. You appear not to have heard anything I said, and just hoped for a magic bullet that you could put in your code without any thought at all.

Bravoone_2006 wrote:
if (!pBun->Open())
return;
if (pBun->IsOpen())

Isn't this redundant ?

Bravoone_2006 wrote:
CString SQL = "Select * from tblName where field = '" + sCod + "'";

1 - I told you at least twice you needed to change the names to reflect the actual names in your database
2 - you have failed to assign any value to sCod, despite being told several times by several people over several days how to do so

Bravoone_2006 wrote:

while(!pBun->IsEOF())
{
m_name.GetWindowText(sCod);
m_city.SetWindowText(SQL);

}

I'm sorry, but I've helped a lot of people over a lot of years, I've never been this speechless. I'd love to help you, but I really don't think it's possible. I'd advocate paying someone to write this code for you, or giving up on C++ and learning VB.NET.

I honestly mean that.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

David Crow22-Sep-06 4:08

David Crow

22-Sep-06 4:08

I can no longer contain myself...

Laugh | :laugh:

Yes I am on the floor laughing!

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

David Crow22-Sep-06 4:11

David Crow

22-Sep-06 4:11

Bravoone_2006 wrote:
CString SQL = "Select * from tblName where field = '" + sCod + "'";

Is your database/recordset supposed to magically see this?

What type of object is CDatabase_1BunView1?

Bravoone_2006 wrote:
while(!pBun->IsEOF())

When does this loop ever terminate? Typically you'd need some sort of "move next" statement.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

Hamid_RT22-Sep-06 1:28

22-Sep-06 1:28

I think he needs to learning sql

WhiteSky

Christian Graus22-Sep-06 1:40

22-Sep-06 1:40

I did suggest that in the first place.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Bravoone_200622-Sep-06 2:11

22-Sep-06 2:11

lets see : i dont want to learn SQL only to work this thats it , way to learn SQL ... only for this ? what is the ... only need help for this thats all !
can you help me with this?

Bravoone

Hamid_RT22-Sep-06 2:36

22-Sep-06 2:36

Its not true if you learn sql it will helpful for you and you want to write a database program so you need to know things about sql

WhiteSky

Christian Graus22-Sep-06 10:16