dbdef error

 1 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
L G
Advanced Member
Posts: 38
Advanced Member

    Hi

    I am not sure if this is the right subforum

    But we are developing a custom table via dbdef

    The size of the table record is huge

    It has like 4000 alphanumeric characters altogether in one record

    which we will be needing to store comments etc about an particular record

    But I am getting an error

    "Adding a field of this size will make the file size too large"

    Can I change some parameter somewhere that will allow this table to be created

    The underlying database is Oracle 9i

    And the same table can be created under Oracle directly

     

    John Henley
    Posts: 3353
      I think the limit is 3000 characters per database record, and it cannot be changed. You should probably use either Lawson comments/attachments APIs or break up the records with sequence numbers.
      Thanks for using the LawsonGuru.com forums!
      John