Hi,

I am facing a strange issue here. I am using a filter with amper variable
like

 WHERE XYZ EQ '&xyz'; 

Here XYZ is a A45 datatype and if I am passing 0000000 as value it is not taking that.

Before this filter I create one more variable with

 -SET &A = IF &xyz EQ '' THEN '' ELSE 'A';

&A get value as '' and after that &xyz behaves as ''.

Please help.

This message has been edited. Last edited by: Kerry,

-SET &xyz='000000';
-SET &A = IF ASIS(&xyz) EQ '' THEN '' ELSE 'A';
-TYPE &xyz &A

Try this, Deepak. Dialogue Manager can't tell the difference between a zero and a space.

Deepak-
You may also want to consider the function ASIS.

That's what I told him, Jim.

Ginny,

Isn't it strange, dialog manager can't tell the difference between a zero and a space. Why webfocus kept this behaviour?

I think that if DM has been working like that since its initial conception, changing it now would potentially break thousands of Production code that may have relying on that particular functionality. It's probably a similiar situation as that of the annoying automatic blank line that just appears after a report HEADING when BORDERs are used; it should be an "easy" fix but I'm guessing they'd rather keep it that way to avoid undesirable side effects in existing code.

Chirag , I believe they might have updated this in 7.7.

Let me check..

Deepak, the way you check for missing or null values in amper variable is not correct.
Either use ASIS function, as mentioned by Ginny or you can try this too

-SET &xyz='0000000';
-SET &A=IF &xyz || 'A' EQ 'A' THEN 'Missing' ELSE &xyz;
-SET &check_1=&xyz.EXIST;
-SET &B=IF &check_1 EQ 0 THEN 'Missing' ELSE &xyz;

-TYPE &xyz &A  &B

The below one works fine. The problem will be only when used with dialogue Manager commands.

-SET &xyz='0000000';
TABLE FILE CAR
PRINT
CAR
COUNTRY
DEALER_COST
COMPUTE CC_1/A45=IF COUNTRY EQ 'ENGLAND' THEN '0000000' ELSE '1111111'; NOPRINT
WHERE TOTAL CC_1 EQ '&xyz';
END

Thanks Everybody for this useful discussion. My problem is resolved.

Regards,
DeepakD