Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 9 of 9 total |
strange problem with Trigger behavior |
Fri, Feb 10 2006 5:18 PM | Permanent 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 PM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | |
Tue, Feb 21 2006 9:36 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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.... 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ralf,
<< so, now I'm totally confused...... I made the test's in my "workaround" edition.... 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 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |