topic Re: Problem in comparing two character fields in Application Development and Automation Discussions

Problem in comparing two character fields

Former Member — Thu, 29 Nov 2007 09:54:39 GMT

Hi Everybody,

I have to compare two fields. Like CDPOS-NEW and CDPOS-OLD. These are character fields. I am getting error in Extended ProgramCheck as following

Greater than/less than comparisons with character type operands may not be portable

(Message can be hidden using: "#EC PORTABLE).

But Actually those 2 field values(CDPOS-NEW and CDPOS-OLD.) in CDPOS table ,are date fields .What I should I do to compare these two fields which are in character format.

Thanks,

Suresh.

Re: Problem in comparing two character fields

Former Member — Thu, 29 Nov 2007 09:59:40 GMT

DATA : a TYPE char10 VALUE 'DBCD',

b TYPE char10 VALUE '4234',

c TYPE char10 VALUE '3456',

d TYPE char10 VALUE 'ADA',

e TYPE char10 VALUE '234567'.

IF b GT c. "this case checks for numeric values

WRITE 😕 'B is bigger'.

ELSE.

WRITE 😕 'C is bigger'.

ENDIF.

IF a GT d. "this case checks for alphbetical order

WRITE 😕 'A is bigger'.

ELSE.

WRITE 😕 'D is bigger'.

ENDIF.

IF strlen( a ) GT strlen( d ). "this case checks for no of chars

WRITE 😕 'A is bigger'.

ELSE.

WRITE 😕 'D is bigger'.

ENDIF.

IF a GT c. "this case first alph then numerics

WRITE 😕 'A is bigger'.

ELSE.

WRITE 😕 'D is bigger'.

ENDIF.

regards

karthik

Re: Problem in comparing two character fields

Former Member — Thu, 29 Nov 2007 10:01:15 GMT

If I got you right, it might work if you move the data to help-fields typed as date and compare these fields instead of the character fields.

Re: Problem in comparing two character fields

Former Member — Thu, 29 Nov 2007 10:05:02 GMT

Use the function module to compare two date values rather then comparing them directly

Regards,

Prashant