>>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.