Problem with integer types and MySQL5

AndyC++ · Post by **AndyC++** » Tue 25 Apr 2006 12:05

Using the following in a filter expression with an integer field in MySQL5 gives an "invalid variant operation".

Something = 5

When something is a INTEGER field. It works ok with MEDIUMINT.

AndyC++

Antaeus · Post by **Antaeus** » Tue 25 Apr 2006 14:09

We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.

Also supply us following information
- Exact version of Delphi, C++ Builder or Kylix
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor