Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it possible to prevent field validation from running?
Message
From
23/10/2003 15:36:35
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:
00841778
Views:
29
Hi Larry,

Thanks for the suggestion. I'm not sure its gonna do in a multiuser environonment though. The help file doesn't seem to mention exclusive use of the table, but, isn't it required...after all isn't this the same as modifying the structure?

Mike

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform