Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it possible to prevent field validation from running?
Message
 
 
To
23/10/2003 15:16:01
Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00841695
Message ID:
00841772
Views:
23
Mike,
While Cetin's syntax was "off the top of his head" *s*, his suggestion was valid. Check out the Alter Table command. You can tell VFP to drop the rules temporarily from the table, do you stuff, then set it back.

HTH.

>Hi Cetin,
>
>Thanks for your input. I did a bit of searching in the VFP help file for DBSETPROP and field rules for tables are read-only so it appears that I can't "set validations off" :(
>
>Regards,
>
>Mike
>
>
>>Off the top of my head :
>>-You could set validations off (dbsetprop)
>>Do your work
>>-Restore validations
>>Cetin
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform