Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Why automaticly in append/insert mode
Sun, Jun 7 2009 1:43 PMPermanent 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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

Image