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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao