Community
Showing results for 
Search instead for 
Do you mean 
Reply

How could I fix the overflow table problem?

Highlighted
Tuned Listener
Posts: 6
Country: France

How could I fix the overflow table problem?

Hello,

I was adding fields in the opportunity table and at some point I can't find it in the TBL_OPPORTUNITY table in sql server anymore, it turned out that these fields are in an overflow table. How could I fix this so that everything is recorded in the TBL_OPPORTUNITY table?

Thank you in advance.

emergency !!!

Highlighted
Nickel Elite Contributor
Posts: 559
Country: Germany

Re: How could I fix the overflow table problem?

You can't fix that. Once a custom table (="Overflow table") was created in the database, it will stay there. The reason for that new table is very simple: the "basic" table is "full" because you added some fields to your database.
Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de
Highlighted
Tuned Listener
Posts: 6
Country: France

Re: How could I fix the overflow table problem?

But it looks like the base table can go up to 1000 fields while I m only at 37 fields. So there is space available. That is my concern.
Highlighted
Nickel Elite Contributor
Posts: 559
Country: Germany

Re: How could I fix the overflow table problem?

Due to the various field types ACT! can use, a table becomes full far before this theoretical limit is reached. Rest assured that everything is in good order!
Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de
Highlighted
Tuned Listener
Posts: 6
Country: France

Re: How could I fix the overflow table problem?

Ah okay I see! Thank you very much for your answers
Highlighted
New Member
Posts: 1
Country: USA

Re: How could I fix the overflow table problem?

I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work MyAARPMedicare.