Phillip Cannon wrote:
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
Maybe:
SELECT CAST(i.COSTPRICE as Decimal(10,2)) as "COSTPRICE" FROM i WHERE
ITEMNO=234451
--
Bc. Jiri Cincura
http://www.ID3renamer.com/ | http://www.x2develop.com/
ICQ: 314711544 | Yahoo!: x2develop
http://blog.vyvojar.cz/jirka/ | http://photo.cincura.net/
-------------------------------------------------------
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
