User Activity

  • Modified a comment on discussion Help on HyperSQL Database Engine (HSQLDB)

    Thanks again for your reply. That being the case I think it'd be in order some clarification to the documentation. As it is now it seems to convey some earlier releases don't allow it whyle [non early, current?] releases do. Also elimininating the parts in bold below might help: If a trigger is FOR EACH STATEMENT, then a transient table is created containing all the rows for the OLD state and another transient table is created for the NEW state. The [ REFERENCING <transition table="" or="" variable="">...

  • Posted a comment on discussion Help on HyperSQL Database Engine (HSQLDB)

    Thanks again for your reply. That being the case I think it'd be in orther some clarification to the documentation. As it is now it seems to convey some earlier releases don't allow it whyle [current] releases do. Also elimininating the parts in bold below might help: If a trigger is FOR EACH STATEMENT, then a transient table is created containing all the rows for the OLD state and another transient table is created for the NEW state. The [ REFERENCING <transition table="" or="" variable=""> ] is...

  • Posted a comment on discussion Help on HyperSQL Database Engine (HSQLDB)

    Many thanks, understood. I must be missing something tho... What's REFERENCING NEW TABLE AS ntable purpose meant to be in this context? I might be confused by the guide stating the following in the triggers chapter: If a trigger is FOR EACH STATEMENT, then a transient table is created containing all the rows for the OLD state and another transient table is created for the NEW state. The [ REFERENCING <transition table="" or="" variable=""> ] is used to give a name to the OLD and NEW data row or table....

  • Posted a comment on discussion Help on HyperSQL Database Engine (HSQLDB)

    I'm gettin a -5501 error (ntable not found) when trying to create atriggers like the following: CREATE TRIGGER sometrigger AFTER INSERT ON sometable REFERENCING NEW TABLE AS ntable FOR EACH STATEMENT BEGIN ATOMIC INSERT INTO someothertable (SELECT * FROM ntable); END ; So, how would I go about referencing ntable in a situation like this? Thaks in advance!

  • Committed [158ae9]

    Renamed NetRexxC-3.00 tag to NetRexxC-3.00_prot...

  • Committed [42afb4]

    Also removed the bootstrapping jars from the Ne...

  • Committed [8cea81]

    First release made available by RexxLA at netre...

  • Committed [a388ba]

    Initial RexxLA sources commit. ICU notices adde...

View All

Personal Data

Username:
drequena
Joined:
2006-08-03 17:05:20

Projects

This is a list of open source software projects that D. Requena is associated with:

  • Project Logo jEdit jEdit is a programmer's text editor written in Java. Last Updated:

Personal Tools