Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
T-SQL Trigger/SQL Server 7.0
Message
 
À
28/06/2002 14:51:52
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:
00685126
Vues:
20
Bonnie,
>
>>>>Right now, it looks like I'm going use VFP to generate the scripts I'll need and then insert them via SQL-DMO.<

Just to close up this thread, I first created three tables (for the servers, databases and tables) and set up a relationship between the three. The tables were populated using an SQL-DMO series of calls. This allows me to display the databases and the related tables in to grids. I can then select what tables in what databases I want the triggers generated and inserted. I've got a bit of work left to do on the form, but when its done, I can insert the triggers in a large number of tables very, very quickly. I'm sure that it will come in use in the future.
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