>>>Hi all,
>>>I just observed a TABLEUPDATE() behavior that suprised me.
>>>If a form has more than 36 controls and user edits 35 control values, TABLEUPDATE() fails. Using AERROR() the message "SQL String too long..." is reported.
>>>If user changes 1-34 controls or changes all controls, TABLEUPDATE() will work. Appending a blank record seems to be immune to the limit/TABLEUPDATE() failure.
>>>
>>>Evidently, VFP creates an SQL select... statement containing a list of all modified fields and this exceeds the 255 char string limit for SQL statements. (I think it's 255).
>>>
>
>This is specifically addressed by SYS(3055); it can be set to a value between 320 (the default) and 2040. There are guidelines in the on-line help.

Not in VFP5. :-)