|
A Unicode string is a short *. I think you need wcout. cout is printing out the memory address of your pointer. You could also use wstring to store the value.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi Christian
Thank you very much for your help!
Regards
ManuStone
|
|
|
|
|
BTW, dictionnary should contain one n. 
Kevin
|
|
|
|
|
Hi Kevin, you are right!
Bye Manu
|
|
|
|
|
Declare the following somewhere:
#ifdef _UNICODE
#define tcout std::wcout
#else
#define tcout std::cout
#endif // _UNICODE
And use tcout instead of cout/wcout.
If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week
Zac
|
|
|
|
|
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 !
Bravoone
|
|
|
|
|
how many times will you ask this ?
|
|
|
|
|
1000000 if i have to !
because i need help !
Bravoone
|
|
|
|
|
Bravoone_2006 wrote: 1000000 if i have to !
that's not how CP works...
you should really read THIS[^] first ! 
|
|
|
|
|
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
|
|
|
|
|
wow he ask repeated
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
i m not use ado,dao !
i will test what you say !
tanks !
Bravoone
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
I can no longer contain myself...
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
|
|
|
|
|
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
|
|
|
|
|
I think he needs to learning sql
|
|
|
|
|
I did suggest that in the first place.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
