Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread strange problem with Trigger behavior
Fri, Feb 10 2006 5:18 PMPermanent Link

"Ralf Bertoldi"

example : 1 table.. 100 records

field1 - autoinc
field2 - ...
....


Cient SQL: "DELETE FROM mytable WHERE field1 BETWEEN 80 AND 90"


Serverside  "AfterDelete" Trigger:

first fired event: delete No.80
(... update mytable SET anything... WHERE myfield = 5) same table but
none of the records that should be deleted..

second event is No 82 and not 81 (?)
every second record is skipped during delete.
No error message that anything is not deleted... so, every 2nd trigger
event has no function at all... a lot of data became corrupted that
way...

... please.. it's really urgent, cause I use a lot of triggers and
procedures.. if they don't work as expected...(?)

TIA
ralf
Fri, Feb 10 2006 8:46 PMPermanent Link

"Ralf Bertoldi"
the only workaround I found is to write every record in a single
statement..

SQL.Text := "DELETE FROM mytable WHERE...=80;
      DELETE FROM mytable WHERE..=81;
      DELETE FROM mytable WHERE..=82;......"


regards,
ralf
Mon, Feb 13 2006 11:27 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ralf,

Handling via email - waiting on input data.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Feb 21 2006 9:36 PMPermanent Link

"Ralf Bertoldi"
Tim,

> Handling via email - waiting on input data.

any news of the trigger behaviour?
sent twice the sample application.

TIA
ralf
Wed, Feb 22 2006 5:21 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ralf,

<< any news of the trigger behaviour? sent twice the sample application. >>

All of my responses to you keep bouncing (I've tried all three email
addresses that you've sent).  I need to get from you the source data that
you are using to recreate the problem.  I've tried it here with data that
I've created and it doesn't skip any records.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Feb 22 2006 9:23 PMPermanent Link

"Ralf Bertoldi"
> All of my responses to you keep bouncing (I've tried all three email
> addresses that you've sent).  I need to get from you the source data
> that you are using to recreate the problem.  I've tried it here with
> data that I've created and it doesn't skip any records.

mmhh..(?)
sent it 2 times by email and uploaded it to your website as "New
incident Report"...

just uploaded a sample to the binaries..


regards,
Ralf
Wed, Feb 22 2006 9:47 PMPermanent Link

"Ralf Bertoldi"
Tim,

I don't know why,..
just tested the example again (now) with build 5 and it's working as
expected..

I'll have a closer look at it...

ralf
Wed, Feb 22 2006 10:02 PMPermanent Link

"Ralf Bertoldi"
> I don't know why,..
> just tested the example again (now) with build 5 and it's working as
> expected..
>
> I'll have a closer look at it...

so, now I'm totally confused......
I made the test's in my "workaround" edition....Smile

It's still there... (build4+5)

can you reproduce the beaviour?

maybe I have an error anywhere in my code.. but I can't find it..

TIA
ralf
Thu, Feb 23 2006 12:25 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ralf,

<< so, now I'm totally confused......
I made the test's in my "workaround" edition....Smile

It's still there... (build4+5)

can you reproduce the beaviour? >>

No, I cannot.  I don't have the proper data to do so, which is why I've
asked for the data from you several times now.  And please don't post the
example project anymore - I don't need it, I need your data (you sent me an
empty table).

--
Tim Young
Elevate Software
www.elevatesoft.com

Image