Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updatable RDO (SQL Statement to long)
Message
 
À
14/06/1999 14:06:24
Gregory Figueroa
General Nutrition Corporation
Leetsdale, Pennsylvanie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00229589
Message ID:
00229604
Vues:
15
Maybe this could help....
Kamal

VFP Help File:
-------------------
SYS(3055) – FOR and WHERE Clause Complexity
See Also

Sets the complexity level of the FOR and WHERE clauses in commands and functions that support those clauses.

Syntax

SYS(3055 [, nComplexity])

Returns

Character

Arguments

nComplexity

Specifies the complexity level. The valid range for nComplexity is 320 to 2040. The default value is 320. If you specify an odd value, it is rounded down to the closest even integer.

Remarks

If you receive the error 1308 - Insufficient Stack Space or 1812 - SQL: Statement Too Long, you can increase the FOR and WHEN clause complexity to help prevent the error.

For example, calling TABLEUPDATE( ) for a local table or view that doesn’t use key fields generates a long WHERE clause to find the update row. The default number of fields supported in the WHERE clause is 40. If you receive the error 1812 - SQL: Statement Too Long, you should either use a key field for the update or increase the complexity of the WHERE clause with SYS(3055). If you use SYS(3055), increase its value to 8 times the number of fields in the table:

= SYS(3055, 8 * MIN(40, FCOUNT( )))

If SYS(3055) is issued without the nComplexity argument, its current setting is returned.

The following commands and functions support the FOR or WHERE clauses:
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform