Hi,

I already have a dialect 3 database with FB 1.5.2.

Luis

Martijn Tonies wrote:

>Hi,
>
>
>
>>I have my currency fields defined to be a NUMERIC(18,6), but I have
>>precision problems.
>>
>>If I enter this value: -654646 FB stores this: -654646,000000000116
>>Is there any way of avoiding this?
>>
>>
>
>Yes, use a dialect 3 database.
>
>
>
>>What is the best format for currency values?
>>
>>
>
>Numeric, in dialect 3.
>
>
>
>>I can't use this in my apps, because if I compare the user -654646 is <>
>>of the DB -654646,000000000116,
>>and this will cause many conflicts.
>>
>>
>
>With regards,
>
>Martijn Tonies
>Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
>Server
>Upscene Productions
>http://www.upscene.com
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>