|
Thanks for the link. I was tempted to go with one those here on CP, but since this one comes recommended, and it's on SourceForge (always a good sign) I will use this one.
|
|
|
|
|
I agree with Cedric XML is better
|
|
|
|
|
waldermort wrote: I was tempted to go with one those here on CP, but
are you saying that CPians are not recommandable ?
|
|
|
|
|
INI is old and outdated, but is useful for simple data (strings, integers).
XML is expensive to parse, but does offer the ability to do preliminary type-checking during the parse, as well as schema validation. This is very useful for complex data types.
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 search from CEdit to a database ?
i have CDialog base aplication i use 3 CEdit controls .
Database : Visualfoxpro 6.0 on ODBC name : "name".(1 table , 3 columns)
all i want is to find if the txt from CEdit1 match the txt from database , and if is , the answer i need in CEdit 2 .
ex:
Database table
database type : snapshot.
----------------------------------
| names | city | country |
__________________________________
|george|london | england |
|michael|paris |france |
__________________________________
CEdit1 m_edit1
CEdit2 m_edit2
i write : "george" in m_edit1 and i need "london" in m_edit2.
i have onchange on m_edit1.
please help me !
thank you in advance !
Bravoone
|
|
|
|
|
Flaviu_2006 wrote: how can i search from CEdit to a database ?
1)Read the string from CEdit using the GetWindowText.
2) Read the entries from the database.
3) Compare both these values.
if these values match do something...
Somethings seem HARD to do, until we know how to do them.
_AnShUmAn_
|
|
|
|
|
i have try this :
CString sEdit1,sEdit2;
m_edit1.GetWindowText(sEdit1);
CDatabase_Name* pName = new CDatabase_Name();
if(sEdit1 == pName->m_name)
{
m_edit2.SetWindowText(pName->m_city);
}
yes it works but i have 260.000 records and i have to wait about 6 min. to have an answer !!!!!!
can you help me !
please an example !
Bravoone
|
|
|
|
|
See what just Christian Graus said. You can search for the string in the database that is in the edit box, Create a database query and then fire it...
Thanks...Christian. I just missed that point...
Somethings seem HARD to do, until we know how to do them.
_AnShUmAn_
|
|
|
|
|
how ? i dont have that information !
can you help me , please man !
Bravoone
|
|
|
|
|
_AnShUmAn_ wrote: 2) Read the entries from the database.
3) Compare both these values.
if these values match do something...
This would require reading all rows from the table. Yuck!
"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
DavidCrow wrote: This would require reading all rows from the table
yeah , I very well know that. I replied back with some changes and I guess you didn't read it before posting this one...
Somethings seem HARD to do, until we know how to do them.
_AnShUmAn_
|
|
|
|
|
Do not read the database and compare values in code, write a select statement for the DB that uses the string from CEdit1, so it only returns the match.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
How can i write a select statement for the DB that uses the string from CEdit1 ?
please can you give an example on how can i do this ?
Bravoone
|
|
|
|
|
Do you not know how to write a select statement ? How are you using a database then ?
GEtWindowText gets you the string, then put it in a select. If you don't know any SQL, I recommend learning some, I don't see how you can write DB code without it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
thanks i understand i think ... i will try now .
only need explication !
1000 thanks !
Bravoone
|
|
|
|
|
please help me i don t now how can i do this i have try something with local view in visualfoxpro 6.0 its cool some speed but it is slow however !
my first question can you help me with my first question ?
Bravoone
|
|
|
|
|
I really don't have anything else to offer. I've answered your question - you need to work out how to pass a SQL statement to your DB ( if you're getting back all your data, then you must already be doing this ), and change it to reflect what you're looking for.
You didn't answer my question. Do you know what SQL is ? If not, how are you getting data out ? I've never used FoxPro, so I don't know what tools it offers you, I just know it's a DB, which means, one way or the other, you're using SQL to get data out of it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
|
Bravoone_2006 wrote: SELECT Bun.cod, Bun.cont, Bun.den, Bun.um, Bun.pret, Bun.necesar;
FROM Name!bun;
ORDER BY Bun.cod
You are missing a WHERE clause. Do you know how to use a SELECT statement?
"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
An example of sql Statement
Select name1,name2 from Table1 WHERE (name LIKE '%hello%' or Col='123') AND check IS NOT NULL
|
|
|
|
|
You've already been instructed on how to do this in at least two different ways.
"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Flaviu_2006 wrote: //--------- i need some help please -------------//
hum, yeah, that's definitely a good sumarize of your problem... i think you could add VERY URGENT in it !
|
|
|
|
|
|
You can use from a query and I remember that you said you have 60000 records and I said to you I searched for you for speed and I found a good link but I losed it if you can find this site on this site you can see algorithms for search on databases I guess its very helpful for you
|
|
|
|
|
what site ?
please tell me !!!!!!!!!!!!!
Bravoone
|
|
|
|