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
Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
Avid Poster
Avid Poster
Seriously, you're a posting maniac!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!

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: 3362
3 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
New Poster
New Poster
Congrats on posting!
Engaged Poster
Engaged Poster
Wow, you're on a roll!
3 Avid Poster
Avid Poster
Seriously, you're a posting maniac!
3 Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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