Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's an SQL compliant application???
Message
 
 
To
29/02/2000 09:44:26
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00339070
Message ID:
00339078
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform