One table won't $update, why?

[Ben Butler]

>From our friend google:

The maximum number of columns is 32767 in a table. The default setting for
SQLITE_MAX_COLUMN is 2000. The maximum number of bytes in the *text* of an
*SQL* statement is limited to SQLITE_MAX_SQL_LENGTH which defaults to
1000000. You can redefine this limit to be as large as the smaller of
SQLITE_MAX_LENGTH and 1073741824.

So you should be ok if less than 2000 columns?

Ben

On Sat, 1 Aug 2020, 23:02 Das Goravani, <goravanis at gmail.com> wrote:

>
> Ben, Thanks for the speed and reply. I wish !  But I only have one record
> in the table, it adds just fine, won’t update.. I feel the word “yet”
> applies.. because I have another large one that is working.. I feel I have
> to strip out some of the lists, tedious work, to their own table and in my
> case file because I use the CRB, until it’s lean enough to fit back into
> the pragmatics of “working”.. I feel it is simply too large.. but I feel
> that begrudgingly because they are all mostly small fields, humble columns,
> it’s not a library or book text project.. its a typical constants file..
> mostly booleans, I use 32 bit integers for same, many small char fields,
> too, but 42 lists, mostly small, some large
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>