Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Statement Too Long Error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00023951
Message ID:
00024116
Vues:
36
>I have apparently been running into some limits on the size of local updatable views. My views update fine as long as not too much data is entered. However, after data is entered in about 30 character fields with an average length of about 20, I get an "SQL Statement too Long" error.
>
>I can increase the amount of data updatable by forcing the changes or changing the wheretype clause of my views. However, these methods are not acceptable to my customer.
>
>What are the actual limits on the size of a view? Do I need to divide my views? Any other ideas?
>
>Thanks for the help!
>
>Tom Waltz

Your problem is not the size of the generated view.
The problem is the size of the command line use to generate this view.
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform