Subject Re: [IBO] Currency Fields, Displaying $
Author Helen Borrie
At 09:59 PM 10/05/2004 +0000, you wrote:
>Hi, I am using a TIB_StoredProc to pull some values back from a stored
>procedure in my database.
>
>I want the fields to display in the program with a dollar sign, like
>$10.00 in a TIB_Edit.
>
>I added in FieldDisplayFormat RETREM=$,0.00 but I keep getting an
>error "4159.9 is not a valid integer value"
>
>I am NOT using integers, all the fields are double precision - why
>does it try and make it an integer? I also tried specifying the field
>as currency, but that didn't help.
>
>I probably am missing something simple, but if someone can help please do.

If you are using IBO 4.3Aa, there's a bug in FieldsDisplayFormat that is
causing this. If this is the case, email me privately in the next 24 hours
and I'll send you a link where you can download a patch.

Helen