Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 6 of 6 total

Fri, Jun 13 2008 5:03 PM	Permanent Link
Isaac	Hello, In my application in some point I depend on getting the old and new values of a field using triggers, How I can do the same with elevatedb ? Thanks
Fri, Jun 13 2008 5:10 PM	Permanent Link
"Raul"	Use OLDROW and NEWROW in trigger body Raul "Isaac" <no@no.com> wrote in message news:9C725535-79E9-4A4A-997C-A930AA70A49E@news.elevatesoft.com... > Hello, > In my application in some point I depend on getting the old and new values > of a field using triggers, How I can do the same with elevatedb ? > > Thanks
Fri, Jun 13 2008 5:19 PM	Permanent Link
Isaac	Raul wrote: > Use OLDROW and NEWROW in trigger body > > Raul Is there triggers in elevatedb ? I did not see any in the database manager !!!
Fri, Jun 13 2008 5:22 PM	Permanent Link
"Raul"	Yes - for INSERT, UPDATE and DELETE see http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=10&topic=151 Raul "Isaac" <no@no.com> wrote in message news:AD9DB8F0-EFF7-4E6D-8111-429019467562@news.elevatesoft.com... > Raul wrote: >> Use OLDROW and NEWROW in trigger body >> >> Raul > Is there triggers in elevatedb ? I did not see any in the database manager > !!!
Fri, Jun 13 2008 5:26 PM	Permanent Link
"Raul"	Forgot to mention that in DBManager you have to expand the table in treeview and you should see "Columns","Constraints", "Indexes" and "Triggers". Selecting triggers lets you create/alter and dropthem. Raul "Raul" <raul@raul.ca> wrote in message news:D72024B4-2A40-4945-9D9C-B2766792CBC0@news.elevatesoft.com... > Yes - for INSERT, UPDATE and DELETE > > see > http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=10&topic=151 > > Raul > > "Isaac" <no@no.com> wrote in message > news:AD9DB8F0-EFF7-4E6D-8111-429019467562@news.elevatesoft.com... >> Raul wrote: >>> Use OLDROW and NEWROW in trigger body >>> >>> Raul >> Is there triggers in elevatedb ? I did not see any in the database >> manager !!! > >
Fri, Jun 13 2008 6:58 PM	Permanent Link
Isaac	Raul wrote: > Forgot to mention that in DBManager you have to expand the table in treeview > and you should see "Columns","Constraints", "Indexes" and "Triggers". > > Selecting triggers lets you create/alter and dropthem. > > Raul > > "Raul" <raul@raul.ca> wrote in message > news:D72024B4-2A40-4945-9D9C-B2766792CBC0@news.elevatesoft.com... >> Yes - for INSERT, UPDATE and DELETE >> >> see >> http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=10&topic=151 >> >> Raul >> >> "Isaac" <no@no.com> wrote in message >> news:AD9DB8F0-EFF7-4E6D-8111-429019467562@news.elevatesoft.com... >>> Raul wrote: >>>> Use OLDROW and NEWROW in trigger body >>>> >>>> Raul >>> Is there triggers in elevatedb ? I did not see any in the database >>> manager !!! >> > > Many Thanks