Fix the SQL query parser and these 'Could not parse' messages

[aburningflame]

SELECT DISTINCT CONCAT(invoice_fee_description, IF(fee_charge>0,CONCAT(' ($',fee_charge,')'),'')) fee_code FROM fee WHERE fee_type='DELIVERY' ORDER BY invoice_fee_description, fee_code

Is perfectly valid, but your parser gives me:
Could not parse the SQL select statement for the choices in field: fee_id


THe statement is fine - looks like i have to create a view and base the dropdown off that.

I have had to work around this bad parsing many many times.
It is very frustrating - just let the sql statement go through to the database without your code trying to (badly) verify it - if it doesnt work - my fault.
There have been many times where using nested selects, or functions in the statement doesnt work

[Al Buchholz]

Can you choose the option for stored procedure? I don't think the SQL code is parsed then.

[aburningflame]

Im not sure where this option is.
Remember: I am using the dropdown 'Choices' in dynamic mode.

It's fine, I have it working.
Its just annoying and redudant to have to create a view, when i can already just do a select from the current table and use 1 mysql if statement.
But because of alpha, i need to create a view and base the dropdown on the view.