At 03:51 PM 6/12/2005 +, you 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"
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 connectio
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
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 co
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
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 connec
