Multiple Fields In Query Don't Work In C++ Builder 6

I am using C++ Builder 6 and I want to query more than one field/column in my query to a table of my MySQL database. Let's say, I have a table named 'users' and my table has the fi

Solution 1:

The guide you link to uses SQLite and not MySQL as in your code.

I am suggesting that the files will be different for each DBMS.

Although MySQL can be used directly with it's own drivers employing MySQL's api, using ODBC with MySQL might allow the use of the components.

Solution 2:

I found that the problem was the wrong dbExpress Driver for MySQL. Dll dbxopenmysql50.dll might work right only with MySQL v5.0. DevArt dbExpress Driver for MySQL could be used for higher versions than v5.0 of MySQL.