Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding table validation rule
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01406956
Message ID:
01406995
Views:
27
>>BTW, I could not find how to add TABLE validation rule.
>
>Prepare a simple DB with all procedures you wan. Then use GENDBC and check what code it generates :-)

I found the table validation rules, BTW: (in How to: Create Record Validation Rules topic)

ALTER TABLE Employee SET CHECK Hire_Date >= birth_date + (18 * 365.25) ;
ERROR "Employees must be 18 years or older by date of hire."
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform