[Kexi] Kexi 2.2 PostgreSql driver not deciphering money type
Hi, It seems that the kexi postgresql driver could not deciphering / understand / encode money. In this case this table tblData. CREATE TABLE tblData ( Croptypevarchar (32), Age int, Areafloat, TRV int, SCOST money, PCOST money, P1P2float, SLOGfloat, PULPfloat, CFREV money, LCOST money, TCOST money, SACOST money, RCOST money ); Thanks, Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Geting Kexi2.2 SVN source only for patching purposes
On 20 September 2010 07:28, Noli Sicad nsi...@gmail.com wrote: Hi, It seems that this instruction is just patching, http://kexi-project.org/wiki/wikiview/index@kexi2.2_patches.html#msaccess_large_memo I think a lot of problem getting this done. I don't have even Qt build system. Any compiled binary that we can download just to use the new feature / fixes. Hi Noli, I think the most efficient way would be to ask maintainer of your package to apply the patch. I announced availability of all the patches ASAP on proper announcement channel. -- regards / pozdrawiam, Jaroslaw Staniek http://www.linkedin.com/in/jstaniek Kexi KOffice (http://kexi-project.org, http://identi.ca/kexi, http://koffice.org) KDE Software Development Platform on MS Windows (http://windows.kde.org) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Kexi 2.2 PostgreSql driver not deciphering money type
Hi I assume you are talking about the migration of a pg database to a kexi database? At the moment there is no check for the money type, and kexi has no direct mapping for this type. I guess the nearest would be a double, but conversion from money double isnt straightforward ( http://www.postgresql.org/docs/8.3/static/datatype-money.html ) because the output is local specific. I will have a play and see if its possible. Cheers Adam Noli Sicad wrote: Hi, It seems that the kexi postgresql driver could not deciphering / understand / encode money. In this case this table tblData. CREATE TABLE tblData ( Croptype varchar (32), Age int, Area float, TRV int, SCOST money, PCOST money, P1P2 float, SLOG float, PULP float, CFREV money, LCOST money, TCOST money, SACOSTmoney, RCOST money ); Thanks, Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi