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