Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MM Security with SQL Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00391395
Message ID:
00392352
Vues:
8
>The only thing I could find was Thread # 370647, which deals with stored procedures for the ID table. I already have these. The ones that I am missing are for the users, groups and usgrlink tables. They are all RI (Referential Integrity) stored procedures. Have you reproduced these in SQL?
>
>Kind Regards,
>
>Mat

Nope. I havn't looked too closely at the RI for these, but it wouldn't be too difficult to recreate the triggers in SQL Server. Unfortunately, SQL Server doesn't support cascading update and deletes so you're forced to do things with triggers. Too complicate matters, triggers that emulate cascading deletes won't fire if you have foreign key constraints. Migrating to SQL Server requires a little bit of getting used to. Also, check your tables to see what kind of null values your fields are set to. The default is set to not accept NULL values when upsizing a database. This can also cause problems.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform