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?
Regards
Phil
-------------------------------------------------------
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
