Create Triggers

[Ruslan Zasukhin]

On 1/6/07 4:48 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> Hi List, Ruslan
> 
> This weekend I'll be looking into the new functions (triggers &
> procedures).
> A few questions already:
> 
> Q1: Is there an API way to create triggers and procedures ?
> 
> It looks like there is only the SQL way.

Yes only SQL way.

Reason? First of all it is much more hard add new API methods to all existed
ADKs and their docs.

 
> Q2: When using the SQL way does VDatabase.ExecuteSQL ("Create
> Trigger......") return something as a result indicating succes or
> failure
> or do just Try...Catch Vexceptions ?

exception

> Q3: Can one create,alter and delete  triggers and procedure at any
> point in time during the lifetime of a database, or does this "have"
> to be before inserting records ?

At any time of course

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]