Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: Blackfish SQL/Core Engine    [ Add a report in this area ]  
Report #:  73925   Status: Reported
Cannot update timestamp columns in triggers
Project:  JDataStore Build #:  8.0.2902.10471
Version:    6 Submitted By:   David Clegg
Report Type:  Basic functionality failure Date Reported:  5/13/2009 4:56:42 PM
Severity:    Serious / Highly visible problem Last Updated: 5/13/2009 10:49:11 PM
Platform:    All platforms Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
Using BlackfishSQL for .NET, if you attempt to update the value in a timestamp column in a BEFORE INSERT or BEFORE UPDATE trigger, the value is not applied to the row when
it is saved.
Steps to Reproduce:
- Download and unzip BSQLTrigger.zip
- Copy the assembly in .\TestTriggers\bin\Debug to the directory where your BSQL assemblys normally reside (or configure BSQL to search the directory where it currently resides)
- Using a RDBMS tool (such as Data Explorer), connect to .\TestTriggers\Data\Test.jds
- Execute the following DML statements:
INSERT INTO TEST_TABLE (STRING) VALUES ('Test');
SELECT * FROM TEST_TABLE;

Expected: The returned row should show the current timestamp at the time of insertion in the TRIGGER_STRING and TRIGGER_TIME columns
Actual: Only the TRIGGER_STRING column has the correct value.

- Execute the following DML statements:
UPDATE TEST_TABLE SET STRING = 'TEST2';
SELECT * FROM TEST_TABLE;
                              
Expected: The returned row should show the current time in the TRIGGER_STRING and TRIGGER_TIME columns
Actual: Neither column has the correct value (see http://qc.codegear.com/wc/qcmain.aspx?d=73926)



Workarounds
None
Attachment
TestTriggers.zip
Comments

Tomohiro Takahashi at 5/13/2009 10:53:05 PM -
This is Build No field you set.
> 8.0.2902.10471

Are you using Blackfish SQL for .NET which comes with Delphi 2007(RAD Studio 2007)?
If so, could you please change Project field, Version field and Area field like QC#66197?

Server Response from: ETNACODE01