MySQL Forums
Forum List  »  Connector/ODBC

Re: mysql odbc parameters
Posted by: Peter Brawley
Date: February 05, 2021 02:22PM

> 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.

Yes, do you understand though that your @ prefixes in column names need to be got rid of?

> select * from myTable
> where myField = 100
> In SQL Server it works perfectly but in MySQL it doesn't filter anything.

Such queries work fine for all of us in MySQL. There's something else wrong in what you're doing. For us to understand what that is, you'll need to supply all the detailed steps that get you there.

About that, why are you using Connector/ODBC instead of Connector/Net with Visual Studio?

Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.