Maybe:
SELECT CAST(i.COSTPRICE as Decimal(10,2)) as "COSTPRICE" FROM i WHERE
ITEMNO=234451
Jiri, thank you for the suggestion but i have tried this along with many
other variations of the query but to no avail :-(
The database has dialect 1 or 3 ?? ( by the error message it looks
like it's 1 can you rebuild the database using dialect 3 and retry )
Carlos, Unfortunatly the database is already being used by another program
so i cannot really rebuild the db with a different dialect without risking
protential problems in the original program. What is confusing me is that
i can run this query in IB Admin & IB Manager on the same database with out
any problems.
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
