Problem with QSqlQuery and the .arg of a QString[SOLVED]

[jano_alex_es]

On the other hand, the next code:

QString name = 'Alex';
QSqlQuery data(*pointer_my_database->GetDBPtr());
data.prepare(QString("SELECT id FROM users WHERE iaccesslevel=:iaccesslevel AND sname = :sname"));
 
data.bindValue(":sname", name);
data.bindValue(":iaccesslevel", CSQLUsers::AL_PUPIL);
data.exec();
 
bool test1 = data.first();
bool test2 = data.isValid();
bool test3 = data.isSelect();

QString name = 'Alex';
QSqlQuery data(*pointer_my_database->GetDBPtr());
data.prepare(QString("SELECT id FROM users WHERE iaccesslevel=:iaccesslevel AND sname = :sname"));

data.bindValue(":sname", name);
data.bindValue(":iaccesslevel", CSQLUsers::AL_PUPIL);
data.exec();

bool test1 = data.first();
bool test2 = data.isValid();
bool test3 = data.isSelect();

To copy to clipboard, switch view to plain text mode 

gives me false, false and true again :S

[Lesiok]

Why You have

QString name = 'Alex';

QString name = 'Alex';

To copy to clipboard, switch view to plain text mode 

not

QString name = "Alex";

QString name = "Alex";

To copy to clipboard, switch view to plain text mode 

???

[jano_alex_es]

Because I was testing, testing, testing and testing, and I though "maybe the problem is in the double-mark, SQL uses simple so let's try". The compiler said nothing, I though it was the same.

Thanks, definitly your solutions were right and the last problem was that.

[wysota]

The compiler said nothing, I though it was the same.

I see someone is using a lousy... eee.... Microsoft compiler.

[jano_alex_es]

what can I say, the company chooses the compiler :P