![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Sun, Jun 7 2009 1:43 PM | Permanent Link |
Peter van Mierlo | hi,
For searching i use the following code: dmTables.tbl_taak.Filter:='LOWER(taak_acties) like LOWER('+QuotedStr('%'+RzButtonEdit_Zoek.Text+'%') +')'; dmTables.tbl_taak.Filtered:=true; which works good for me. Then there a standard filters which the user can select from a menu, a filter looks like this: cFilter:='In behandeling'; dmTables.tbl_taak.Filter:='taak_status=''In behandeling'' '; dmTables.tbl_taak.Filtered:=true; RzStatusPanel_Aantal.caption:='Aantal = '+intTOstr(dmTables.tbl_taak.RecordCount); When i use the last one, the table goes in append/insert mode. And after showing all records a again there are everytime 2 record append to the table. What causes this problem ? |
Sun, Jun 7 2009 2:21 PM | Permanent Link |
Peter van Mierlo | After more searching and trying to reproduce the appending it happends when calling this
code below dmTables.tbl_taak.filter:=''; dmTables.tbl_taak.Filtered:=false; RzStatusPanel_Filter.Blinking:=false; RzStatusPanel_Filter.Caption:='Filter = Niet actief'; RzStatusPanel_Aantal.Caption:=''; if RzButtonEdit_Zoek.Focused then RzButtonEdit_Zoek.clear else RzButtonEdit_Zoek.text:='Zoeken naar...'; |
Mon, Jun 8 2009 3:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Peter,
<< When i use the last one, the table goes in append/insert mode. And after showing all records a again there are everytime 2 record append to the table. What causes this problem ? >> Something else besides what you posted. Could you post the complete unit that is involved ? Somewhere there's an event handler that is causing a behavior that you don't expect. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jun 9 2009 4:03 PM | Permanent Link |
Peter van Mierlo | Hi Tim,
I can also send you the tables and .exe file so you can see what it is doing (let me know). There's a search field see procedure TFormMain.RzButtonEdit_zoekKeyDown. After entering a NON EXISTING value the user gets a message that no records are matching. After that a procedure called FilterOpheffen is called to clear and disable the filter. After that there are 2 new empty records added. I can't figure out what's or where it's going wrong. The datamodule contains no events for the table which is used and there are no appends or inserts in code for this table. Regards Peter "Tim Young [Elevate Software]" wrote: Peter, << When i use the last one, the table goes in append/insert mode. And after showing all records a again there are everytime 2 record append to the table. What causes this problem ? >> Something else besides what you posted. Could you post the complete unit that is involved ? Somewhere there's an event handler that is causing a behavior that you don't expect. -- Tim Young Elevate Software www.elevatesoft.com Attachments: frmMain.pas |
Wed, Jun 10 2009 4:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Peter,
<< I can also send you the tables and .exe file so you can see what it is doing (let me know). >> I would need the project code to examine what the issue may be. Unfortunately, there's no way for me to analyse it using just the .exe. << I can't figure out what's or where it's going wrong. The datamodule contains no events for the table which is used and there are no appends or inserts in code for this table. >> I can't see anything obvious in your unit, but I suspect that the problem is related to the Edit calls that are peppered around in various events. I would put breakpoints on them all, and see when each is getting called, if at all. -- Tim Young Elevate Software www.elevatesoft.com |
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 ? ![]() |