Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View updateable fields limit
Message
De
16/11/1998 14:02:12
 
 
À
16/11/1998 13:52:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00157828
Message ID:
00157930
Vues:
19
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
Fil
Voir

Click here to load this message in the networking platform