bfx: Field too large for a data item. Try to increase -s. (42)

WayneFrank

WayneFrank

Member
I am running a Progress program which includes the line

OR upper(notes.notes) MATCHES "*FORM 3*"

One of the lines returned is

bfx: Field too large for a data item. Try to increase -s. (42)

When I take out the FORM3 line, the bfx line disappears from the output.

I also have
OR upper(notes.notes) MATCHES "*FORM III*"
but that does not cause the mysterious message.

What is going on here?

I have Version 9.1B of Progress

Thanks, Wayne
 
AFAIK, most likely this error is caused when you blow the limits of character data type variables/database fields. There is a limit how much characters you can store on a field or a variable plus if the field is indexed the limit is much less. AFAIK for indexes in V9 it was somewhere around 115 characters.

Another thing: You are talking about a software that is more than 10 years old and completely unsupported by Progress. You should think about upgrading to a more recent version of OpenEdge 10 for which these limits have been lifted or dramatically increased ( for example there are now LONGCHARs available ... ).

Regards, RealHeavyDude.
 
I did have an IF statement like this:
IF upper(notes.notes) MATCHES "*RUNAWAY*"
OR upper(notes.notes) MATCHES "*RUN AWAY*"
OR upper(notes.notes) MATCHES "*FORM III*"
OR upper(notes.notes) MATCHES "*FORM 3*"

When I broke it into 2 different IF statements it did not give the error any more. Not an ideal solution but it works.
 
You must log in or register to reply here.
Back
Top