Problem Executing Query from QT

[pranavpunjabi]

First of all thanks for the support.

Ya i know that theres some syntax error in the query but I'm not able to figure it out as i can run the same query successfully from the terminal. Anyways, I'm posting the relevant lines of code below :

QSqlQuery query(mRemoteDB);
 
QString queryStr = QString("SELECT nsdqaohlcv.open, nsdqaohlcv.hightime, nsdqaohlcv.high, nsdqaohlcv.lowtime, nsdqaohlcv.low, nsdqaohlcv.close, nsdqaohlcv.volume, nsdqaohlcv.trades FROM \"nsdqaohlcv\", \"stock\", \"calendar\" WHERE nsdqaohlcv.stock_id = stock.stock_id AND nsdqaohlcv.date_id = calendar.date_id AND stock.symbol = '%1' AND calendar.date = ( SELECT MAX(date) FROM \"calendar\" WHERE EXTRACT (DOW FROM date) >= 1 AND EXTRACT(DOW FROM date) <= 5  AND date < 'today' AND isholiday IS NULL)").arg(mStockname);
 
bool retVal = query.exec(queryStr);
 
if(!retVal){
		QString errMsg = QString(	"Error executing query: %1\n"
			"Error Message from Database: %2"
			).arg(queryStr).arg(query.lastError().text());
		mpError->setMessage(errMsg, Error::Critical);
	}

QSqlQuery query(mRemoteDB);

QString queryStr = QString("SELECT nsdqaohlcv.open, nsdqaohlcv.hightime, nsdqaohlcv.high, nsdqaohlcv.lowtime, nsdqaohlcv.low, nsdqaohlcv.close, nsdqaohlcv.volume, nsdqaohlcv.trades FROM \"nsdqaohlcv\", \"stock\", \"calendar\" WHERE nsdqaohlcv.stock_id = stock.stock_id AND nsdqaohlcv.date_id = calendar.date_id AND stock.symbol = '%1' AND calendar.date = ( SELECT MAX(date) FROM \"calendar\" WHERE EXTRACT (DOW FROM date) >= 1 AND EXTRACT(DOW FROM date) <= 5  AND date < 'today' AND isholiday IS NULL)").arg(mStockname);

bool retVal = query.exec(queryStr);

if(!retVal){
		QString errMsg = QString(	"Error executing query: %1\n"
			"Error Message from Database: %2"
			).arg(queryStr).arg(query.lastError().text());
		mpError->setMessage(errMsg, Error::Critical);
	}

To copy to clipboard, switch view to plain text mode 

[ChrisW67]

SQL uses single quotes to delimit strings not double quotes.


Edit: I reread the query. Disregard this comment.

[pranavpunjabi]

I just remover the double quotes from the table names but still the query does not gets executed