>Hi all,
>
>I am populating a list box with the following SQL:
>
>select branch, ;
> document, ;
> Sn, ;
> date, ;
> transform(amount, "$999,999,999.99"), ;
> (iif((Stop),"STOP",(iif((Void),"VOID",""))))as "Status" ;
>from register into cursor "z" + sys(3)
>
>The idea here is to indicate which checks have had a stop payment or have been voided. Both fields (Stop, Void) are logicals. The truly interesting thing is that sometimes the listbox will populate with "VOID" and "STOP" and sometimes it will poulate with "V" and "S".
>
>Does anybody have a clue what's going?
Does it work any better if you change the "" in the IIF to
" "
, to match the other two? When you do something like this, the first record in the table can determine the width for the rest of the SELECT.