Originally Posted by
cristiano
it would like to effect update of id_test in clause SQL WHERE
Do you mean something like this?
query.exec( "UPDATE tabletest SET date_time=now() WHERE " + dataTable->filter() );
query.exec( "UPDATE tabletest SET date_time=now() WHERE " + dataTable->filter() );
To copy to clipboard, switch view to plain text mode
or
query.prepare( "UPDATE tabletest SET date_time=now() WHERE id_test = :id" );
query.bindValue( ":id", ... );
query.exec();
query.prepare( "UPDATE tabletest SET date_time=now() WHERE id_test = :id" );
query.bindValue( ":id", ... );
query.exec();
To copy to clipboard, switch view to plain text mode
Bookmarks