Data Cell update limit on Table Views

GregHertling
New Contributor III

Hi, is there a limit on the number of cells that can be updated through Table Views?  We have a large table, 250 rows by 140 columns.  When we try to update all values at once, there are many cells that do not update.  When we only load 10 or so rows at a time, it updates all values correctly.

thanks,

Greg

1 REPLY 1

Krishna
Valued Contributor

@GregHertling  - In General SQL can handle 1024 Columns, in OS there could be a limitation either you need to reach to support or you can perform a trail and error. BTW Dumping all data in single table does not good design. Try to Normalize the table and use join to pull the data. Hope this helps.

Thanks
Krishna