triggers through RB => SQL IDEA TO DO

[Ruslan Zasukhin]

On 15/11/07 11:22 AM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:

> Hi List, Ruslan,
> 
> is there a way to access a trigger through RB?
> What I mean is, I want to disable some (or) all triggers, do
> something, and then enable them again.
> 
> Something like this :
> 
> for i = 1 to MyDB.TableCount
> for j = 1 to MyDB.Table(i).TriggerCount
> MyDB.Table(i).Trigger(j).Enalbed = False
> next j
> next i
> 
> Or is there any other way?

Hmm,

I think may be this can be good idea to add into SQL such task.
But in general way with sense as:

DISABLE TRIGGERS
    [name LIKE xxxxx]
    [FROM TABLE with name LIKE nnnnn]


-- 
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]