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