Hey Thomas and Scott!

I missed the *, but in fact, in the program, i put:
"select * from <table> where <field> like '<something>%'".

The missing * is not the problem at all. The error i gave is the
problem.

And I tried with the * as a wildcard.

So, the query would be: "select * from <table> where <field> like
'<something>*'"

But it also returns an error: Dynamic SQL Error. SQL error code =
-104
unexpected end of command.

Thomas Steinmaurer wrote:

>Hi,
>
>
>
>>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?
>>
>>
>
>The LIKE usage is fine, but you are missing a field list in your SELECT
>statement.
>
>Is this just a typo in your email or your real SELECT statement?
>
>Try:
>
>select * from ...
>
>
>
>
>Best Regards,
>Thomas Steinmaurer
>LogManager Series - Logging/Auditing Suites supporting
>InterBase, Firebird, Advantage Database and MS SQL Server
>Upscene Productions
>http://www.upscene.com
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>