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:
00392367
Vues:
8
>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.

Thanks James,

Mat
Matthew Kennedy
Decision Support Technology Inc.

"I try to take one day at a time, but sometimes several days attack me all at once." ~ Ashleigh Brilliant

New Jersey Dot Net User Group
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform