Problem with Automatically Retrieve Fields

[danysabo]

Hello,

I have following sql query inside iReport query window:

select ca.* from carassignment cajoin car c on ca.carId = c.id and c.status in ($P!{STATUSES})

I have problem when 'Automatically Retrieve Fields' option is checked, it says that I have error in SQL syntax. But if I compile report with that query, everything is fine. Problem is the mark '!', but I need that mark to avoid inserting single quota character.

I think this is bug, iReport need not report that I have error in SQL syntax.

I'm sorry if this problem is already reported, I didn't find it searching the forum.

Regards,

Daniel Sabo

[mrcaffeine]

There is a special syntax for IN and NOT IN in SQL queries. See Lucian's post here: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=70649