FM3 string to text problem

[olu]

Please can anyone help, as I am using mssql backend for my nettalk application and when I let fm3 create my tables, and set a field string to 10000, which I then expect to convert on the backend to text. but it is just coming up with the error that limit of 8000 exceeded. Please anyone know why this is not working?

[kevin plummer]

It could be an SQL limit you have exceeded - there are limits on number of columns and total size of a record. You may be able to declare the field as a binary or something else to store your value.

[Bruce]

I suspect it's telling you the record buffer is limited to 8K for MsSql..