Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's an SQL compliant application???
Message
 
 
À
29/02/2000 09:44:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00339070
Message ID:
00339078
Vues:
15
>Hello
>
>How can you be confident to say that your application are SQL server compliant while you only used VFP databse with it.
>
>This application is based 100% on Views, is this enough to declare it as SQL compliant???
>
>Any suggestion wil help

That determination can be quite subjective. Is someone asking you to document that your application meets certain specifications? Does your customer have a definition of what they mean by SQL Compliant? I am sure others can add to this list, but some things come to mind. I would think this has more to do with database design.

1. All tables have PKs.
2. All child tables have a FK reference to parent table[s]
3. Referential integrity is enforced

I guess you could also document data validation rules, triggers and stored procedures.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform