|
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.
|
|
|
|
|
How exactly have you initialized varCount?
Your loop has a problem:
for(int i=0;i!=varCount;i++)
while i is not equal to varCount, thats just asking for trouble. Try changing it to
for(int i=0;i<varCount;i++)
|
|
|
|
|
thank you guys.
yes, my problem was in varCount initialization.
and i have another problem. when i write
intVec.
the property container menu of intVec doesn't appears.
|
|
|
|
|
Intellisense doesn't work ? That doesn't really matter, does it ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Many times, deleting .ncb file in project folder and rebuilding application do work.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
