SQL command and QString?

[SunnySan]

I would like to get the last ID of the table (plandfile)
I got the SQL code for it which gives me a nice single string under:

SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)

SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)

To copy to clipboard, switch view to plain text mode 

what would be the best way to transform this to a QString??
Is there a method of QSqlquery which return a String??
Please help
Thanks

[wysota]

See QSqlQuery::value() and QVariant::toString().

[SunnySan]

I have tried to test it

QVariant variant;
		QSqlQuery query;
		query.exec("SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)");
		variant= query.value(0);// also try with 1
		QString plandfileID;
 
		plandfileID=variant.toString();
		 QMessageBox::about(this, tr("Value of ID"),plandfileID);

QVariant variant;
		QSqlQuery query;
		query.exec("SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)");
		variant= query.value(0);// also try with 1
		QString plandfileID;

		plandfileID=variant.toString();
		 QMessageBox::about(this, tr("Value of ID"),plandfileID);

To copy to clipboard, switch view to plain text mode 

but I receive nothing in the QString.
I tested the SQL alone, works fine.
No Error but I m not sure why it's not working???

[wysota]

You have to call QSqlQuery::next() before you start reading values.

[sadjoker]

Something like this:

QSqlQuery query;
QString plandfileID;
 
query.exec("SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)");
 
while (query.next()) {
	plandfileID = query.value(0).toString();
}
 
QMessageBox::about(this, tr("Value of ID"),plandfileID);

QSqlQuery query;
QString plandfileID;

query.exec("SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)");

while (query.next()) {
	plandfileID = query.value(0).toString();
}
              
QMessageBox::about(this, tr("Value of ID"),plandfileID);

To copy to clipboard, switch view to plain text mode 

[fnmblot]

This is how I get the last entry.

QSqlQuery query("SELECT uid from main");
query.last();

QSqlQuery query("SELECT uid from main");
query.last();

To copy to clipboard, switch view to plain text mode 

Then I set that to be the max of my uidSpinbox

fvui.uidSpinBox->setMaximum(query.value(0).toInt());

fvui.uidSpinBox->setMaximum(query.value(0).toInt());

To copy to clipboard, switch view to plain text mode 

[jacek]

This is how I get the last entry.

QSqlQuery query("SELECT uid from main");
query.last();

QSqlQuery query("SELECT uid from main");
query.last();

To copy to clipboard, switch view to plain text mode 

Then I set that to be the max of my uidSpinbox

You select the whole table to get one specific record? What a waste of resources. Also the database returns records in a random order.

To get the maximum uid use: SELECT MAX(uid) from main

[jacek]

I got the SQL code for it which gives me a nice single string under:

SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)

SELECT id FROM plandfile WHERE id=(SELECT MAX(id) FROM plandfile)

To copy to clipboard, switch view to plain text mode 

You don't need a subquery here. Just use "SELECT MAX(id) FROM plandfile" and you'll get the max id.

[SunnySan]

thanks all
the final working code

QSqlQuery query;
		      QString plandfileID;
		      query.exec("SELECT MAX(id) FROM plandfile");
		      while (query.next()) {
		   		          plandfileID = query.value(0).toString();
		   	      }
		     QMessageBox::about(this, tr("Value of ID"),plandfileID);

QSqlQuery query;
		      QString plandfileID;
		      query.exec("SELECT MAX(id) FROM plandfile");
		      while (query.next()) {
		   		          plandfileID = query.value(0).toString();
		   	      }
		     QMessageBox::about(this, tr("Value of ID"),plandfileID);

To copy to clipboard, switch view to plain text mode 

where id is the primary key of the table plandfile

if you improve the code please let me know

[wysota]

Sure. Replace "while" with "if".