Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 9 System Capacities
Message
De
10/06/2004 09:08:23
 
 
À
04/06/2004 12:32:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Divers
Thread ID:
00909993
Message ID:
00912179
Vues:
14
Just another system limit bump request:

I can have now much more complex queries in VFP9 (no more error 1845: SQL expression is too complex; and now I can use subqueries) but I still hit sometimes the 8192 characters per query limit (Error 18: Line is too long).
The actual solution is to break the query in more separate queries and join them with an additional SELECT statement. But if others also hit this limit and it is easy to enlarge it to say so 65536 characters, I think that we will see this error more rarely.

Note:
SQLServer has also this limit (8000 characters), but only when executing queries created dynamically (via EXECUTE) (because of the VARCHAR limit acctualy), but it can be circumvented by useing string concatenation like: EXEC('name_of_8000_char_string' + 'another_name_of_8000_char_string')
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform