Saving and storing data,QtSql

[salmanmanekia]

Hi,
i have a question is it possible to save and store data so that whenever the application starts it can be loaded by using QSqlTableModel..or by anyother QtSqls ??

[Lesiok]

Yes, it is possible. Read about QSettings, especially about QSettings::registerFormat.

[Lykurg]

if you want use SQL just create a SQLite database and use it whenever you want.

[salmanmanekia]

the question i am asking doesnt directly corresponds with the heading of topic..but still it is somehow regarding the same problem so i will ask it here..
whats the problem in this piece of code..the table view changes from total white screen to a screen with a hash sign at the begiinning and whole white

sqlModel->setTable("notes");
	sqlModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
	int row =0;
	sqlModel->insertRows(row,1);
	sqlModel->setData(sqlModel->index(row,0),topicValue);
	sqlModel->setData(sqlModel->index(row,1),dateValue);
	sqlModel->setData(sqlModel->index(row,2),dataValue);
	sqlModel->submitAll();
	tableView->show();

sqlModel->setTable("notes");
	sqlModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
	int row =0;
	sqlModel->insertRows(row,1);
	sqlModel->setData(sqlModel->index(row,0),topicValue);
	sqlModel->setData(sqlModel->index(row,1),dateValue);
	sqlModel->setData(sqlModel->index(row,2),dataValue);
	sqlModel->submitAll();
	tableView->show();

To copy to clipboard, switch view to plain text mode 

[salmanmanekia]

i copied the above code from a book and it didnt worked ...i have modified the code a bit and now it shows the table in my desired orientation but without the datas in it..i will paste it here

constructor
{
..
        sqlModel->setHeaderData(0,Qt::Horizontal,"Topic");
   	sqlModel->setHeaderData(1,Qt::Horizontal,"Date");
   	sqlModel->setHeaderData(2,Qt::Horizontal,"Data");
 
	sqlModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
	sqlModel->insertColumns(column,3);
..
}
 
void NoteBook::addRecord()
{
	sqlModel->insertRows(row,1);
	sqlModel->setData(sqlModel->index(row,0),QVariant(topicValue));
        sqlModel->setData(sqlModel->index(row,1),QVariant(dateValue));
	sqlModel->setData(sqlModel->index(row,2),QVariant(dataValue));
	tableView->setModel(sqlModel);
	sqlModel->submitAll();
	++row;
	tableView->show();
}

constructor
{
..
        sqlModel->setHeaderData(0,Qt::Horizontal,"Topic");
   	sqlModel->setHeaderData(1,Qt::Horizontal,"Date");
   	sqlModel->setHeaderData(2,Qt::Horizontal,"Data");
   	
	sqlModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
	sqlModel->insertColumns(column,3);
..
}

void NoteBook::addRecord()
{
	sqlModel->insertRows(row,1);
	sqlModel->setData(sqlModel->index(row,0),QVariant(topicValue));
        sqlModel->setData(sqlModel->index(row,1),QVariant(dateValue));
	sqlModel->setData(sqlModel->index(row,2),QVariant(dataValue));
	tableView->setModel(sqlModel);
	sqlModel->submitAll();
	++row;
	tableView->show();
}

To copy to clipboard, switch view to plain text mode 

[JD2000]

In addRecord() where are the values of your 3 QVariants being set?

[salmanmanekia]

can u please come again..i didntunderstand...if u mean topicvalue ,datavalue and datevalue..then i have taken a line edit and taken an input from user and stored in it...

[salmanmanekia]

I jus debugged this piece of code and the compiler said no signal generated..
here topic is QlineEdit and i wanna see if the line changes so i can save the values of line to my variable...

if( connect(&topic,SIGNAL(textChanged(QString &)),this,SLOT(setText(QString &))))
		{topicValue = topic.text();}
 
if( connect(&date,SIGNAL(textChanged(QString &)),this,SLOT(setText(QString &))))
   		{dateValue = date.text();}
 
if( connect(&data,SIGNAL(textChanged(QString &)),this,SLOT(setText(QString &))))
   		{dataValue = data.text();
   	 qDebug() << dateValue;
 
}

if( connect(&topic,SIGNAL(textChanged(QString &)),this,SLOT(setText(QString &))))
		{topicValue = topic.text();}

if( connect(&date,SIGNAL(textChanged(QString &)),this,SLOT(setText(QString &))))
   		{dateValue = date.text();}

if( connect(&data,SIGNAL(textChanged(QString &)),this,SLOT(setText(QString &))))
   		{dataValue = data.text();
   	 qDebug() << dateValue;

}

To copy to clipboard, switch view to plain text mode