Thread: Money type and kylix

Money type and kylix

From
"Eduardo"
Date:
   I m trying to use a field with type money in a kylix application, but it doesn't work. It always says: "dbx error: incompatible type".
   Is it possible to use the money field with kylix or do i have to search for another solution?

Re: Money type and kylix

From
"Josh Berkus"
Date:
Eduardo,

>    I m trying to use a field with type money in a kylix application,
>  but it doesn't work. It always says: "dbx error: incompatible type".
>  
>    Is it possible to use the money field with kylix or do i have to
>  search for another solution?

Umm .. this is a PostgreSQL list.  Are you using Kylix with PostgreSQL? 

If so, you need to use the data type NUMERIC(#,#) to emulate a "money"type.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco