Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
how I can get the old and new values |
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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |