QDateEdit and date returned

[cydside]

Hi to All,
I'm using a QDateEdit widget to edit date values from a database, so I display date values as "dd/MM/yyyy" (settting displayFormat). When I finish to update the record the QDateEdit widget returns "yyyy-MM-dd" formtat. Is there a way to change the return value?
Thanks.

[spirit]

try to set display format using setDisplayFormat.

[cydside]

The method setDisplayFormat doesn't work, QDateEdit returns the same formatted value "dd-MM-yyyy"!!!

[spirit]

QDateEdit returns QDate, if you need to convert date to string then use QDate::toString with format==dd/MM/yyyy.

[cydside]

I'm trying to set the format value returned because QDateEdit widget is mapped to a QSqlTableModel!!!

[spirit]

I don't understand what do you want.
can you attach compilable example?

[cydside]

The following code show you how I'm using the QDateEdit widget:

frmEntUsc_AME::frmEntUsc_AME(QSqlRelationalTableModel *model,
   const int &isItNew, QWidget *parent) : QDialog(parent)
{
   ui.setupUi(this);
   this->setWindowFlags(Qt::Dialog | Qt::MSWindowsFixedSizeDialogHint);
   this->setAttribute(Qt::WA_DeleteOnClose);
 
   modelAME = new QSqlTableModel(this);
   modelAME = model;
 
   modelAME->database().transaction();
 
   if (isItNew < 0)
   {
      id = modelAME->rowCount();
      modelAME->insertRow(id);
      ui.dedData->setDate(QDate::currentDate());
   }
   else
   {
      id = isItNew;
   }
 
   ui.dedData->setDisplayFormat("dd/MM/yyyy"); //QDateEdit widget
 
   mapper = new QDataWidgetMapper(this);
   mapper->setModel(modelAME);
   mapper->setItemDelegate(new QSqlRelationalDelegate(this));
   mapper->setSubmitPolicy(QDataWidgetMapper::ManualSubmit);
   //...
   //...
   mapper->addMapping(ui.dedData, 9); // the QDateEdit widget is mapped to a date field
   mapper->setCurrentIndex(id);
 
   connect(ui.btnAnnulla, SIGNAL(clicked()), this, SLOT(revert()));
   connect(ui.btnOk, SIGNAL(clicked()), this, SLOT(submit()));
 
   qDebug() << "frmEntUsc_AME Loaded!";
}

frmEntUsc_AME::frmEntUsc_AME(QSqlRelationalTableModel *model,
   const int &isItNew, QWidget *parent) : QDialog(parent)
{
   ui.setupUi(this);
   this->setWindowFlags(Qt::Dialog | Qt::MSWindowsFixedSizeDialogHint);
   this->setAttribute(Qt::WA_DeleteOnClose);

   modelAME = new QSqlTableModel(this);
   modelAME = model;

   modelAME->database().transaction();

   if (isItNew < 0)
   {
      id = modelAME->rowCount();
      modelAME->insertRow(id);
      ui.dedData->setDate(QDate::currentDate());
   }
   else
   {
      id = isItNew;
   }

   ui.dedData->setDisplayFormat("dd/MM/yyyy"); //QDateEdit widget

   mapper = new QDataWidgetMapper(this);
   mapper->setModel(modelAME);
   mapper->setItemDelegate(new QSqlRelationalDelegate(this));
   mapper->setSubmitPolicy(QDataWidgetMapper::ManualSubmit);
   //...
   //...
   mapper->addMapping(ui.dedData, 9); // the QDateEdit widget is mapped to a date field
   mapper->setCurrentIndex(id);

   connect(ui.btnAnnulla, SIGNAL(clicked()), this, SLOT(revert()));
   connect(ui.btnOk, SIGNAL(clicked()), this, SLOT(submit()));

   qDebug() << "frmEntUsc_AME Loaded!";
}

To copy to clipboard, switch view to plain text mode 

[spirit]

which date format do you use in a database?

[cydside]

I'm using a SQLITE database, the field is declared as TEXT!

[spirit]

why? why is not date?

[cydside]

As you know, SQLITE allow only few datatype :

• NULL
• INTEGER
• REAL
• TEXT
• BLOB