Hi,
I am using the 1.7.1 RC3 and getting a problem using the CAST
statement in my sql. For example trying to execute the following SQL
via the data adapter it gives the error "Metadata update statement is
not allowed by the current database SQL dialect 1" (My dialect is set
to 3 in the connection string which makes this error especially
strange).
SELECT CAST(i.COSTPRICE as Decimal(10,2)) as COSTPRICE FROM ITEM i
WHERE ITEMNO=234451
If i remove the cast it works, Does anyone know what is causing this?
Upon further investigation of the problem i looks like this is being caused
by the Decimal(10,2) part of the statement and not the CAST, i have tried
using Numeric instead but this generates the same error. I assume this is
because the dialect is set to 1 and these are features only usable in dialect
3, but i cannot understand why they work on this database in IB Admin or
IB Manager.
-------------------------------------------------------
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
