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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement