Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only