1 Reply Latest reply: May 15, 2014 9:53 AM by joey RSS

    SQL Tables Question

    Dubrey _

      Does Monarch have a limit on the size that a field can be in the table view - Such as 256?


      Currently my programmer has it set at 420 and everything is blank in the field.  When it was set lower, I had information contained in the fields.

        • SQL Tables Question

          From the technical specifications in the help manual:


          Character field length     254 characters

          Memo field length     65536 characters

          Numeric field length     17 characters (15 significant digits, a negation sign and a

          decimal point, up to 9 decimals).

          Date field length     8 characters


          I'd bet that you are dealing with a character field, and hitting the 254 limit.