Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Binaries » View Thread |
Messages 1 to 3 of 3 total |
detaill browser |
Thu, Jul 31 2008 7:03 AM | Permanent Link |
"Norbert Stellberg" | Hello,
following problem: I have: A Table: Artikel Table Fields: Kunden, Artikel In this table are kunden and artikel: Name1 123456789 Name1 177456788 Name1 223456789 Name1 223456777 Name2 123456789 Name2 123456788 Name2 223456789 Name2 223456777 A browser and a edit filed named Edit300 What I want is: The kunde is Name1 Now I will see, which artikel has name1 ======> not a problem Now I will see, which artikel has name1 with this number begin with 1 S := 'Name1'; DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL = '+QuotedStr(Edit300.Text); DBTable1.FilterOptions:=[]; DBTable1.Filtered:=True; When I put in Edit300 a "1", the browser is empty. But I will see in Browser 123456789 173456788 Now the next in edit300 : "17" Now I will see in the browser: 173456788 I have made some experiments with this DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL = '+QuotedStr(Edit300.Text); DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL >= '+QuotedStr(Edit300.Text); DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL <= '+QuotedStr(Edit300.Text); But the result is not ok. Can you help me ? with best regards Norbert |
Thu, Jul 31 2008 7:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Norbert
Minor point - try to pick the right newsgroup to post to - this one is meant for attachments - I would suggest dbisam.general for this sort of question. Assuming that Artikel is a string field, and Edit300 will always have the starting characters for Artikel rather than some in the middle or at the end then your best solution is DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL LIKE ' + QuotedStr(Edit300.Text+'%'); Roy Lambert |
Thu, Jul 31 2008 8:02 AM | Permanent Link |
"Norbert Stellberg" | Hello,
> Minor point - try to pick the right newsgroup to post to - this one is > meant for attachments - I would suggest dbisam.general >for this sort of > question. Sorry, I meant this was the right group. > DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL LIKE ' + > QuotedStr(Edit300.Text+'%'); I am excite ! It's work very well. Thank you very much. with best regards Norbert |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |