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
