![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 13 of 13 total |
![]() |
Sun, Aug 12 2007 5:18 PM | Permanent Link |
peter van mierlo | Hi Janusz
Found the solutions and used the following code for filtering with the correct result. When the user enters 'weert' in the edit box and hits the enter key the code below is executed and gives me all cities with the string 'weert' dmTables.tbl_plaats.Filter:='wpl_naam like '+QuotedStr('%'+lowercase(RzButtonEdit_wplZoek.Text)+'%'); dmTables.tbl_plaats.Filtered:=true; |
Sun, Aug 12 2007 5:52 PM | Permanent Link |
"Janusz Cyran" | Yes, that's it. Also, it seems to me you can use any function (also Pos())
in callback filter to separate a record subset. Janusz Użytkownik "peter van mierlo" <p.mierlo@planet.nl> napisał w wiadomo¶ci news:7469C414-7D15-43F1-9997-E5E86E2A35A0@news.elevatesoft.com... > Hi Janusz > > Found the solutions and used the following code for filtering with the > correct result. > When the user enters 'weert' in the edit box and hits the enter key the > code below > is executed and gives me all cities with the string 'weert' > > dmTables.tbl_plaats.Filter:='wpl_naam like > '+QuotedStr('%'+lowercase(RzButtonEdit_wplZoek.Text)+'%'); > dmTables.tbl_plaats.Filtered:=true; > |
Mon, Aug 13 2007 2:33 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | peter
You're nearly there ![]() dmTables.tbl_plaats.Filter:='LOWER(wpl_naam) like LOWER('+QuotedStr('%'+RzButtonEdit_wplZoek.Text+'%') +')'; dmTables.tbl_plaats.Filtered:=true; That ensure that it catches everything regardless of case. Roy Lambert |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |