Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove record validation rule
Message
 
 
To
28/06/2011 09:50:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01516499
Message ID:
01516515
Views:
44
>How can I remove the record validation rule in a table from program?
>Thanks

Have your checked ALTER TABLE command syntax?

SET CHECK lExpression3
Specifies the table validation rule. The lExpression3 parameter must evaluate to a logical expression and can be a user-defined function or a stored procedure.

ERROR cMessageText3
Specifies an error message for the table validation rule in lExpression3. Visual FoxPro displays this message when the table validation rule generates an error. The message displays only when data is changed within a Browse window or Edit window.

DROP CHECK
Removes the table validation rule.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform