Help: Error 3307 on a simple "For Each" 3 lines of

Posted by jaydalla on 13-Aug-2009 12:03

Anybody knows the Trend database?

I'm getting this:

A Frame Segment has exceeded its limit of 32767 bytes, in  at line # 7. (3307)

When I do this:

FOR EACH sapb NO-LOCK:
    DISP sapb WITH WIDTH 110.
END.

I thought it was the triggers so I changed to this:

DISABLE TRIGGERS FOR LOAD OF sapb.
DISABLE TRIGGERS FOR DUMP OF sapb.

FOR EACH sapb NO-LOCK:
    DISP sapb WITH WIDTH 110.
END.

Same result. For now, I go to Data dictionary, dump entire content, and view result using notepad.

All Replies

Posted by Håvard Danielsen on 13-Aug-2009 13:47

Anybody knows the Trend database?

I'm getting this:

A Frame Segment has exceeded its limit of 32767 bytes, in  at line # 7. (3307)

When I do this:

FOR EACH sapb NO-LOCK:
    DISP sapb WITH WIDTH 110.
END.

This error occurs when a frame is too big for the r-code. It's only 3 lines of code, but you are displaying all fields in the table. I do not know the Trend database, but I'm guessing there are some large extents in the sapb table.

Standard workaround suggestions are:

- Use multiple frames.

- Use dynamic widgets.

- Remove LABELS (with the NO-LABEL option).

Posted by jaydalla on 13-Aug-2009 14:07

That works! I did not think that was a big table (94 fields). I just diplayed the fields that I wanted.

Thanks. Your answer is not in the Progress Knowledgebase. Too bad I don't call Progress Software directly anymore to give them update.

Posted by jaydalla on 13-Aug-2009 14:09

I was surprised by the quick response. Better than calling Progress Support.

Posted by Håvard Danielsen on 13-Aug-2009 14:25

I was surprised by the quick response. Better than calling Progress Support.

Thanks, but I have to point out that this is purely incidental...  On the average Progress Support will have better response time for these kind of questions, but their processes are targeted at handling many calls with optimal result, so you would rarely get an immediate response the way you can on this forum.  

This thread is closed