Hello,

I am trying to use report parameters in my SQL query statement. However with strings it seems not to work.

The SQL statement works without the where clause.

It does not work with

<sqlQuery tableName="endresult">
    SELECT * FROM ProgramProjectWorkpackage
    WHERE
               ProgramProjectWorkpackage.Program like '%@Select_Program!%'

</sqlQuery>

However it works with a literal string

<sqlQuery tableName="endresult">
    SELECT * FROM ProgramProjectWorkpackage
    WHERE
               ProgramProjectWorkpackage.Program like '%est%'

</sqlQuery>

Can you let me know how I can solve this...

Thanks

Thanks for the reply.

It seems to work correctly. So Eensys supports "SQL string" handling. Fantastic !

Maybe it would be interesting to have more hands on information on how to use SQLite with Enesys on your support site.

Regards and Tank you

Peter Cattersel.