MySQL Forums
Forum List  »  Connector/ODBC

Re: mysql odbc parameters
Posted by: Ivan Lora
Date: February 05, 2021 01:27PM

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.

Options: ReplyQuote


Subject
Written By
Posted
February 05, 2021 08:51AM
February 05, 2021 09:42AM
Re: mysql odbc parameters
February 05, 2021 01:27PM
February 05, 2021 02:22PM
February 08, 2021 06:35AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.