SETGANGE doesn't allow more than 3 characters

knaabis

I need to get in my report from CrossReference Table some info with SETRANGE like this:

CLEAR(CrossRef1);
CrossRef1.SETRANGE("Description",CrossRef1."Description"::Box1);
CrossRef1.SETRANGE("Item No.","Item"."No.");
IF CrossRef1.FIND('-') THEN;

I get error message "The text 'BOX1' is too long. Text can have maximum lenght 3 characters."

Luc_VanDyck

What is the Data Type of field CrossRef1.Description? If it is Text, you have to use something like:

CrossRef1.SETRANGE(Description,'Box1');

knaabis

If you mean like this, then also doesn't work...

CLEAR(CrossRef1);
CrossRef1.SETRANGE(Description,'Box1');
CrossRef1.SETRANGE("Item No.","Item"."No.");
IF CrossRef1.FIND('-') THEN;

Chinmoy

Did you change any field ids in the table? It looks like that the field in the SetRange should not be description, because description is a text field, why would you setrange on it with an option. Probably what has happened is there was a field with type Option which has got changed and the description field has somehow got the id of the option field.

Chn

dans

what is the data type and length of the Description field ?

knaabis

i think this is text field, but I'm not sure, because i haven't access in Table design...
This is Item Cross Reference Table - 5717

Chinmoy

Is it possible for you to detect whether there was a change in the Field Ids in this table?

Chn

ufuk

knaabis wrote:

I get error message "The text 'BOX1' is too long. Text can have maximum lenght 3 characters."

The message says CrossRef1.Description is a text field and length is 3 character. But when I read your code description appears as a option field. There is an inconsistency between the error message and the code. Have you been able to compile this object and receive this message after that?

Luc_VanDyck

knaabis wrote:

If you mean like this, then also doesn't work...

CLEAR(CrossRef1);
CrossRef1.SETRANGE(Description,'Box1');
CrossRef1.SETRANGE("Item No.","Item"."No.");
IF CrossRef1.FIND('-') THEN;

Please clarify "doesn't work": can the code be compiled or is the result not what you expected?
Maybe "Box1" is written differently in the CrossRef table.

knaabis

Luc Van Dyck wrote:

knaabis wrote:

If you mean like this, then also doesn't work...

CLEAR(CrossRef1);
CrossRef1.SETRANGE(Description,'Box1');
CrossRef1.SETRANGE("Item No.","Item"."No.");
IF CrossRef1.FIND('-') THEN;

Please clarify "doesn't work": can the code be compiled or is the result not what you expected?
Maybe "Box1" is written differently in the CrossRef table.

Yes...
Box1 and BOX1

Thanks for help!

dans

did the error happen when you run it or when you save it ?

Luc_VanDyck

knaabis wrote:

Box1 and BOX1

CrossRef1.SETFILTER(Description, '%1', '@box1');