in wrkqry translate -1 to '負' .....

[pl421]

hi ,dear

In wrkqry ,which methods can translate -1 to '負' and translate +1 to '正' ?

thanks.

[jamief]

Re: in wrkqry translate -1 to '負' .....

we cant see this character '負' can you post an image please use this tool

thanks

http://www.mirekw.com/winfreeware/mwsnap.html

jamie

[pl421]

Re: in wrkqry translate -1 to '負' .....

hi ,jamie.

if the value of this field is -1,i want to use character 'y' to describe '-1' and display it('y') in my qry.any ideas?


thanks .

[jamief]

Re: in wrkqry translate -1 to '負' .....

I cant think of a way to do that in query, it would be rather eeasy in RPG. But
I am far from an expert in query.....

any ideas out there maybe using two queries and result fields somehow?

jamie

[FaStOnE]

Re: in wrkqry translate -1 to '負' .....

The ONLY way I know you can do this is by splitting it up into separate Queries.

Qry 1:
Define a Result field (Char_Y as 'Y')
Select all records where Field = -1
Select output to QTemp/Qry1

Qry 2:
Define a Result field (Char_Z as 'Z')
Select all records where Field = +1
Select output to QTemp/Qry2

Qry 3:
Join Qry1 and Qry2
(include selects/sorts, etc)
Select output to QTemp/Qry3

Qry3 should then contain your desired output

hth