hello friends, i have a small problem. I am retrieving some temperature data from a embbeded system on rs232 terminal which i am saving into a db.. I have done everything but i am having problem with aligning the data from a bulk db to make it into under stable form. How can i push exactly 2944 chars from a string to db one row at a time, cause here one master frame of data is 2944 chars since i am using QString mid to remove the frame id from the retrieved data from the db, when the data is continued from the 1st row to 2nd the count is missed and the aligning is not proper.. I know this problem will be solved if in case i save 2944 chars each row in the db.. should i use datstr.resize(2944); or datstr.count(2944) so that only so many chars are saved into it before i push the data into the data base..
i am appending continuous data into QString stfram; before i save it to the data base. how can i restrict the data to 2944 chars in each row in the db while saving into the db sir.

Qt Code: 
  1. QString sq("INSERT INTO Bulkdb values(%1, %2)");
  2. 				sq = sq.arg(rcount)
  3. 					.arg("'" + stfram + "'");
  4. 					m_query.exec(sq);
  5. 					rcount++;
  6. 					stfram.clear();
To copy to clipboard, switch view to plain text mode 

thank you