Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
>Hi All,
>
>Is there a limit to the number of fields a view can handle, in this case 40?
>If I increase the size of the table/view to 41 fields, regardless of name or type, and then use SCATTER/GATHER MEMVAR, any action on the view thereafter, such as SKIP, generates a 'SQL: Statement too long' error. Same with SCATTER/GATHER TO/FROM ARRAY. If I use REPLACE v_fieldname WITH m.variable, and run through it that way, it works fine. It just doesn't seem to like GATHER MEMVAR.
>
>Any idea why?
>
>Thanks.
>
>Luke
The cause is that the SQL statement to save the changes into the source table is too long because of a whereclause that is too loong.
Try the following
DBSETPROP("MyView","VIEW","WHERETYPE", 1)
It will generate a SQL statement matching the record on the key field only.
Walter,
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