Цитата(silver47 @ 23.4.2011, 18:46)

query.prepare("INSERT INTO [sometable] (NAME) VALUES (:name)");
query.bindValue(":name", "Something'Something");

INSERT INTO [sometable] (NAME) VALUES (:name)

query.prepare("insert into tags values(artist, title, album) "
                      "VALUES (:artist, :title, :album)");

...
QString tags("insert into tags values('Something', 'Something''Something', 'Something')");
...

query.prepare("INSERT INTO [sometable] (NAME) VALUES (:name)");
query.bindValue(":name", "Something'Something");

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
  db.setDatabaseName(":memory:");
  if (!db.open()) {
      QMessageBox::critical(0, qApp->tr("Cannot open database"),
          qApp->tr("Unable to establish a database connection.\n"
                   "This example needs SQLite support. Please read "
                   "the Qt SQL driver documentation for information how "
                   "to build it.\n\n"
                   "Click Cancel to exit."), QMessageBox::Cancel);
  }
  QSqlQuery query;
  query.exec("create table tags (artist text, "
                                "title text, "
                                "album text)");
  QString tags("insert into tags values('Something', 'Something'Something', 'Something')");
  query.exec(tags);

  model = new QSqlRelationalTableModel(this);
  model->setTable("tags");
  model->select();

  QTableView *view = new QTableView;
  view->setModel(model);
  view->resizeColumnsToContents();
  view->resize(700,400);
  view->show();