Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
T-SQL Trigger/SQL Server 7.0
Message
 
À
26/06/2002 11:37:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00672424
Message ID:
00672510
Vues:
16
>Hiya Geo,
>
>One thing you could try is to write a quickie VFP tool to generate the triggers for you. Shouldn't take you more than an hour to do it. This way, you could just compare every field in your trigger, but you wouldn't have to code it all, the tool would do it for you.
>
>~Bonnie

I've been thinking, "This would be cake in VFP". Unfortunately, VFP isn't in the loop in this one, and it's got to be written in T-SQL. BOb Archer did point out (on the SQL Server forum) that there's a function there, COLUMNS_UPDATED(), that looks like it could be the solution. Don't know yet, because I haven't tested.

Thanks for the feedback, though.
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform