Sqlite unrecognized token while inserting of hex values

[rex]

Hello every one i have a small doubt i am inserting some hex value into sqlite db but i am getting a unrecognized token error while inserting value like 000c, 03f4 , 038b but when i am inserting values like 0017 , 0023 , 0384 etc there is no error the data is saved properly to the db... as per my analysis only when there is some alphabet in the hex value i am getting a unrecognized token error.
when there is only numbers in the value it is inserted into the data base.
this is the part of code where i am saving the data into db.

if(temperatureHexdata.count()>=200)
	{
		temperatureHexdata.append(QTime::currentTime().toString("hh:mm:ss"));
 
	m_query.exec("begin transaction Trans");
	QString newsQuery = "insert into allhexdata";
	newsQuery += " values (";
	for(int q = 0; q < temperatureHexdata.count() && q<200;q++)  
	{
			newsQuery += QString("%1").arg(temperatureHexdata[q]) + ", ";
	}	 
	newsQuery += "'" + QString("%1").arg(temperatureHexdata[200]) + "', ";
	newsQuery.remove(newsQuery.length() - 2, 2);
	newsQuery += ")";
	//qDebug() << temperatureHexdata;
        qDebug() << "Query=" << newsQuery;
	if(!m_query.exec(newsQuery))
		{
			qDebug() << m_query.lastError().text(); 
		}
		m_query.exec("commit transaction Trans");
		temperatureHexdata.clear(); 
	}

if(temperatureHexdata.count()>=200)
	{
		temperatureHexdata.append(QTime::currentTime().toString("hh:mm:ss"));

	m_query.exec("begin transaction Trans");
	QString newsQuery = "insert into allhexdata";
	newsQuery += " values (";
	for(int q = 0; q < temperatureHexdata.count() && q<200;q++)  
	{
			newsQuery += QString("%1").arg(temperatureHexdata[q]) + ", ";
	}	 
	newsQuery += "'" + QString("%1").arg(temperatureHexdata[200]) + "', ";
	newsQuery.remove(newsQuery.length() - 2, 2);
	newsQuery += ")";
	//qDebug() << temperatureHexdata;
        qDebug() << "Query=" << newsQuery;
	if(!m_query.exec(newsQuery))
		{
			qDebug() << m_query.lastError().text(); 
		}
		m_query.exec("commit transaction Trans");
		temperatureHexdata.clear(); 
	}

To copy to clipboard, switch view to plain text mode 

pls tell me if i am doing something wrong. ..

thank you

[tbscope]

What type of data can you put in that column?
If the db column only accepts integers, that might be your problem.

[rex]

Hello sir this is how i am creating the columns for the table. It is varchar so it should't be a problem no sir..

for( int i=0 ; i<200 ; ++i )
		{
	        	HexData += QString("Thermo%1 varchar(250) ").arg(i) + (i==199 ? "" : ",");
		}
QString dbt = QString("create table if not exists allhexdata( %1, Time_InterVal varchar(16));").arg(HexData);
query.exec(dbt);

for( int i=0 ; i<200 ; ++i )
		{
	        	HexData += QString("Thermo%1 varchar(250) ").arg(i) + (i==199 ? "" : ",");
		}
QString dbt = QString("create table if not exists allhexdata( %1, Time_InterVal varchar(16));").arg(HexData);
query.exec(dbt);

To copy to clipboard, switch view to plain text mode 

thank you

[Lykurg]

The problem is, that in here

for(int q = 0; q < temperatureHexdata.count() && q<200;q++)  
	{
			newsQuery += QString("%1").arg(temperatureHexdata[q]) + ", ";
	}

for(int q = 0; q < temperatureHexdata.count() && q<200;q++)  
	{
			newsQuery += QString("%1").arg(temperatureHexdata[q]) + ", ";
	}

To copy to clipboard, switch view to plain text mode 

you missed to place the single quotation marks ('). Thus all input are threaten as integers. Use

QString("'%1'").arg(/*...*/);

QString("'%1'").arg(/*...*/);

To copy to clipboard, switch view to plain text mode 

Or consider using prepare() and bindValue() to avoid such mistakes.

[rex]

Hello Lykurg sir thank you so much.. that solved the problem..
i wanted to know why is it treated as a integer if we don't use the single quotation mark.

regards

[Lykurg]

i wanted to know why is it treated as a integer if we don't use the single quotation mark.

Well that's the common SQL syntax: No quotation -> number, quotation -> string. And that is undependent from the type of the field. You also can add an integer to an INT field with

INSERT INTO `foo` (`id`) VALUES ('123');

INSERT INTO `foo` (`id`) VALUES ('123');

To copy to clipboard, switch view to plain text mode 

So to avoid problems always use quotation marks.

[rex]

ok sir thank you again. .. I understood it now..

regards