|
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
|
|
|
|
|
I said i found for you morning but I losed it Im sorry in fact I see your questions about speed (i think more 15 question ) and I searched but I losed Im sorry.
|
|
|
|
|
|
This is not and IDE, not need to comment your lines?
//-----Why the hell you add these extra pipes and slashes? Doesn't it look aweful ?----//
<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[![Jig | [Dance]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif) ]--
[My Current Status]
Link2006 wrote:Let's take it outside of CP
Jeremy : Please don't.I would love to see this.I'm making the popcorn already.
|
|
|
|
|
but I think in VC we use //statement not //statement//
|
|
|
|
|
// hey but adding a // at the end of the comment line says that the comment is over. We use in our VC++  //
/* you get me or not */ ?? ;P 
<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[ ]--
[My Current Status]
Link2006 wrote:Let's take it outside of CP
Jeremy : Please don't.I would love to see this.I'm making the popcorn already.
|
|
|
|
|
in my header file i wrote this code:
class CMyDlg : public CDialog
{
public:
int varCount;
vector<<int> intVec;
}
and in the cpp file wrote this code :
void CQMDlg::OnGetvarCountButton()
{
for(int i=0;i!=varCount;i++)
{
intVec.push_back(i);
}
}
there is no error in compilation but when i press that specific button, program hangs.
can somebody help me?
thanks
|
|
|
|
|
Have stepped in to the code ? what varCount is expected to initialize with? Probably its not initializing properly and going into loop.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
