topic unicode error in Application Development and Automation Discussions

unicode error

Former Member — Fri, 17 Apr 2009 12:15:55 GMT

Hi ,

For following syntax -

SHIFT S_AUSVN-LOW LEFT UP TO 10.

I am getting this error -

"10" must be a character-type data object (data type C, N, D, T or STRING)

How to solve this problem ?

Former Member — Fri, 17 Apr 2009 12:18:02 GMT

Put 10 in single quotes ...

SHIFT S_AUSVN-LOW LEFT UP TO '10'.

Former Member — Fri, 17 Apr 2009 12:22:10 GMT

Hi,

SHIFT is a string operation and can be only used with string or character fields.

The format is :-

SHIFT <c> BY <n> PLACES.

Thanks,

Daya

Former Member — Fri, 17 Apr 2009 12:25:18 GMT

SHIFT S_AUSVN-LOW LEFT UP TO '10'.

This will try to shift the string to left till '10' Occurs in String. Just Use quotes.

If you want to shift by 10 places use:

SHIFT S_AUSVN-LOW LEFT BY 10 Places.

Regards,

Gurpreet