More info.
This happens when I am in the DataSet designer and enter the commandText.
With a FbDataAdapter I can fill a table with no problem using the same SQL.
I will also check on an ADO ng.
Rick
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Rick Roen
Sent: Friday, January 19, 2007 11:13 AM
To: 'For users and developers of the Firebird .NET providers'
Subject: [Firebird-net-provider] use UPPER function in select
VS.NET 2005
I'm trying to add a select command like this to an FBDataTable:
Select <field list> from CONTACTS where ("UPPER"(NAME) like @Name)
And I get this error:
________________________________________
Failed to update CommandText:
The schema of data returned by your new command could not be retrieved.
Schema of table "CONTACTS" was not changed and might not reflect data
retrieved by your command. The database returned the following error:
Dynamic SQL Error
SQL error code = -804
Function unknown
UPPER
Can I not use UPPER in this context?
Rick
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
