NetTalk Central

Author Topic: FM3 string to text problem  (Read 2763 times)

olu

  • Sr. Member
  • ****
  • Posts: 352
    • View Profile
    • Email
FM3 string to text problem
« on: December 07, 2013, 03:41:56 AM »
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

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: FM3 string to text problem
« Reply #1 on: December 08, 2013, 01:56:50 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: FM3 string to text problem
« Reply #2 on: December 08, 2013, 09:16:25 PM »
I suspect it's telling you the record buffer is limited to 8K for MsSql..