Subject | Currency Fields, Displaying $ |
---|---|
Author | jaguarius2003 |
Post date | 2004-05-10T21:59:33Z |
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.
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.