Re: SQL Rule

[Kenneth Downs <ken(at)secdat(dot)com>]

Bert wrote:

> This rule is creating first of all the insert and then i can run an
> Update on this insert, so far its functioning. Your definition is quite
> good but what are doing when you change the table definition? Rewrite
> all Rules?
>  
I actually use a data dictionary processor that automatically generates 
the trigger code and also modifies table structures.  Your example would 
look like this:

table example {
  column { col_A; col_B; }
  column col_C {
    chain calc {
        test { return: @col_A + @col_B; }
 }
}

This tool, called "Andromeda" is available for download if you like, but 
we consider the current version "pre-Alpha".  The entire feature set is 
defined and I use it for all of my projects, but we are still 
stabilizing and documenting.  If you are interested in being a very 
early adopter, drop me a line off-list.
begin:vcard
fn:Kenneth  Downs
n:Downs;Kenneth 
email;internet:ken(at)secdat(dot)com
tel;work:631-689-7200
tel;fax:631-689-0527
tel;cell:631-379-0010
x-mozilla-html:FALSE
version:2.1
end:vcard