Rick Roen wrote:
> I'm not sure if this parsing is done by VS itself of by the FBData factory.
> Do you know?
It's done by VS, unluckily.
I'm using trick, that i wrote select as simple as possible adn then I
rewrite it in Properties window/box, so no reformating is performed.
--
Jiri {x2} Cinc
[mailto:[EMAIL PROTECTED] On Behalf Of
Jiri Cincura
Sent: Friday, January 19, 2007 5:01 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] use UPPER function in select
Rick Roen wrote:
> Select from CONTACTS where ("UPPER"(NAME) like @Name)
Rick Roen wrote:
> Select from CONTACTS where (“UPPER”(NAME) like @Name)
Just shooting, I have here no VS, but shouldn't be there
Select from CONTACTS where (UPPER(NAME) like @Name)
UPPER without quotes?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
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 from CONTACT
VS.NET 2005
I'm trying to add a select command like this to an FBDataTable:
Select 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
