Hello:
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?
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 Guzmán Álvarez
Vigo-Spain
http://carlosga.blogspot.com/
-------------------------------------------------------
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
