Re: mysql odbc parameters

[Ivan Lora]

Thanks for answering

Those conditions help me to send from a report of a -1 when it is All records and if not the value chosen for filtering purposes.

If condition A receives a value of -1 and condition B the same, then the filter would remain.

select * from myTable
where 1 = 1

This example would bring all the records, otherwise the condition would be the name of the field equal to the content of the variable with the @ symbol.

select * from myTable
where myField = 100

In SQL Server it works perfectly but in MySQL it doesn't filter anything.