field size limit error

Classic Servoy
1

Hi all,

I have a solution where with about 50 fields text fields are so. Each field can allow up to 1500 characters.

However, I’ve been getting and error after entering test data at about the 6th or 7th field. The error message is :

com.servoy.j2db.ApplicationException: Cannot save form data
com.servoy.j2db.dataprocessing.DataException: Cannot create a row of size 9544 which is greater than the allowable maximum of 8060.

Apparently, SQL server 2000 has a row size limit of 8060

Has anyone encountered this problem? or know of a workaround?

2

I don’t know much (or anything) about SQL Server but why don’t you work with one master row and one related row per field.

3

It’s just the way it is. It is a limitation of SQL Server 2000.