Hi all!

I'm trying to fetch a record set from a postgreSQL database. Connection to the database was established successfully but when i try to fetch a recordset using a QSqlTableModel i obtain this error: "Unable to find table prod_lotto".
The table "prod_lotto" exist in the selected database and is correctly initialized.
Here is the code relative to the QSqlTableModel:
Qt Code: 
  1. ptrProductionModel = new QSqlTableModel(this, currentConnection);
  2.   ptrProductionMapper = new QDataWidgetMapper(this);
  3.   ptrProductionModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
  4.   ptrProductionMapper->setModel(ptrProductionModel);
  5.  
  6.   // Setup the production table
  7.   ptrProductionModel->setTable("prod_lotto");
  8.   ptrProductionModel->setSort(lot_number, Qt::AscendingOrder);
  9.   ptrProductionModel->setHeaderData(lot_id, Qt::Horizontal, tr("Lot id"));
  10.   ptrProductionModel->setHeaderData(lot, Qt::Horizontal, tr("Lot"));
  11.   ptrProductionModel->setHeaderData(lot_model, Qt::Horizontal, tr("Lot model"));
  12.   ptrProductionModel->setHeaderData(lot_number, Qt::Horizontal, tr("Lot number"));
  13.   ptrProductionModel->setHeaderData(customer, Qt::Horizontal, tr("Customer"));
  14.   ptrProductionModel->setHeaderData(order_date, Qt::Horizontal, "Order date");
  15.   ptrProductionModel->setHeaderData(site, Qt::Horizontal, tr("Site"));
  16.   ptrProductionModel->setHeaderData(guarantee_start, Qt::Horizontal, tr("Guarantee start"));
  17.   ptrProductionModel->setHeaderData(cabinet_model, Qt::Horizontal, tr("Cabinet model"));
  18.   ptrProductionModel->setHeaderData(front_model, Qt::Horizontal, tr("Front model"));
  19.   ptrProductionModel->setHeaderData(lot_id, Qt::Horizontal, tr("Lot id"));
  20.   ptrProductionModel->setHeaderData(banknote_reader, Qt::Horizontal, tr("Banknote reader"));
  21.   ptrProductionModel->setHeaderData(banknote_reader_num, Qt::Horizontal, tr("Banknote reader num."));
  22.   ptrProductionModel->setHeaderData(money_reader, Qt::Horizontal, tr("Money reader"));
  23.   ptrProductionModel->setHeaderData(money_reader_num, Qt::Horizontal, tr("Money reader num."));
  24.   ptrProductionModel->setHeaderData(hopper, Qt::Horizontal, tr("Hopper"));
  25.   ptrProductionModel->setHeaderData(hopper_num, Qt::Horizontal, tr("Hopper num."));
  26.   ptrProductionModel->setHeaderData(card_dispenser, Qt::Horizontal, tr("Card dispenser"));
  27.   ptrProductionModel->setHeaderData(card_dispenser_num, Qt::Horizontal, tr("Card dispenser num."));
  28.   ptrProductionModel->setHeaderData(card_system_model, Qt::Horizontal, tr("Card system model"));
  29.   ptrProductionModel->setHeaderData(card_system_model_num, Qt::Horizontal, tr("Card system model num."));
  30.   ptrProductionModel->setHeaderData(code_card, Qt::Horizontal, tr("Code card"));
  31.   ptrProductionModel->setHeaderData(card_release, Qt::Horizontal, tr("Card release"));
  32.   ptrProductionModel->setHeaderData(card_release_num, Qt::Horizontal, tr("Card release num."));
  33.   ptrProductionModel->setHeaderData(test_date, Qt::Horizontal, tr("Test date"));
  34.   ptrProductionModel->setHeaderData(tester, Qt::Horizontal, tr("Tester"));
  35.   ptrProductionModel->setHeaderData(notes, Qt::Horizontal, tr("Notes"));
  36.   ptrProductionModel->setHeaderData(active_flag, Qt::Horizontal, tr("Active flag"));
  37.   ptrProductionModel->setFilter("FLAG_ATTIVO = 1");
  38.   ptrProductionModel->select();
To copy to clipboard, switch view to plain text mode 

I think that is a problem with QSqlTableModel::setTable function. Can anyone help me?

Best regards.
Andrea