Who knows? Here is an excerpt from the article.
CAUSE=====
There is a fixed limit to how complex the WHERE clause of a query can be.
It is limited to 200 simple expression elements or less (where one element
is a variable reference, or a function call, etc.). With the WhereType view
property set to KeyAndModified, and then updating all the fields will
generate an UPDATE query that exceeds the WHERE clause limits.
Sometimes I think Fox likes to mess with us just enough to make it interesting:>)
>Where type = 3 (key and modified fields)
>
>
>>How did you have 'SQL Where Clause Includes' set. The artice said 'Key and Modified' caused the problem because the resulting Where Clause exceeded 200 simple expression elements.
>>
>>>Wait a second.....I just tested a remote view with 60 updateable fields under VFP5 and it works fine.
>>>
>>>>Nice pickup, Terry!
>>>>
>>>>No wonder I didn't think there was a problem....I'm using 6.
Previous
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