Subject | Wildcard for Firebird |
---|---|
Author | Leonardo Nakahara de Oliveira |
Post date | 2005-01-21T13:41:38Z |
Hello all,
I'm developing an application on .Net using the
FirebirdNETProvider-1.6.3-NET1.1 found on the Firebird site.
So, i need to make a query like that:
"select from <table> where <field> like '<something_the_user_wrote>%'"
The problem I get is: Dynamic SQL Error. SQL error code = -104 - Token
unknown - line <x>, char <y> %
That means the firebird doesn't recognize the % wildcard inside the
program lines or that the FirebirdNETProvider is not working correctly
or that the wildcard used inline the program has to be other.
Does anyone know how to solve this problem?
I work with C# on .Net Framework.
Thanks in advance
I'm developing an application on .Net using the
FirebirdNETProvider-1.6.3-NET1.1 found on the Firebird site.
So, i need to make a query like that:
"select from <table> where <field> like '<something_the_user_wrote>%'"
The problem I get is: Dynamic SQL Error. SQL error code = -104 - Token
unknown - line <x>, char <y> %
That means the firebird doesn't recognize the % wildcard inside the
program lines or that the FirebirdNETProvider is not working correctly
or that the wildcard used inline the program has to be other.
Does anyone know how to solve this problem?
I work with C# on .Net Framework.
Thanks in advance