Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL - Alter table
Message
De
09/02/2004 06:51:45
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
09/02/2004 03:27:19
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00875358
Message ID:
00875386
Vues:
16
>Hi all,
>Just need to confirm, will using alter table function fire insert triggers of tables?
>Thanks in advance.
>yau

I think it will fire update trigger, but not insert trigger. But better do some tests.

I do my table updates through an APPEND FROM in an empty copy of the table; this, of course, would fire the Insert trigger.

You can make your trigger functions dependent on a variable:
* Trigger function, saved in stored procedures,
* called from Table-Insert or Table-Update
if type glOmitTriggers = "L" and glOmitTriggers
  return
endif
...
...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform