SQLite with Qt4

[MIH1406]

No problem how to get the maximal value in a table?

Thanks

[Grimlock]

Select max(id) form TableName

Select max(id) form TableName

To copy to clipboard, switch view to plain text mode 

Should do the trick.

Or You may try.

QSqlQuery qry;
qry.prepare("SELECT Id FROM TableName Order by Id");
if(!qry.exec())
{
        qFatal("Failed to count records");
        return;
 }
 while(qry.next())
 {
        int index = qry.value(0).toInt();
        if(temp < index)
            break;
        else
            ++temp;
 }

QSqlQuery qry;
qry.prepare("SELECT Id FROM TableName Order by Id");
if(!qry.exec())
{
        qFatal("Failed to count records");
        return;
 }
 while(qry.next())
 {
        int index = qry.value(0).toInt();
        if(temp < index)
            break;
        else
            ++temp;
 }

To copy to clipboard, switch view to plain text mode 

This will get you the first free id.If by any chance You would get some free ids in between due to dropping a row.

[lyuts]

The doc on SQLite says that the keyword is AUTOINCREMENT, not AUTO_INCREMENT. This should take care of your primary key when you insert row without specifying the id.

[MIH1406]

That is a very good point. But where is the SQLite docs?

Thank you
Mohammad

[Lykurg]

But where is the SQLite docs?

www.sqlite.org?