hhamilton-src/fmrd-desktop — Issue #109: Fix syntax errors in embedded SQL 
Author: hhamilton-src
Created: 2012-01-03 02:03:32+00:00
State: open
Labels: Normal, SQL

There are syntax errors in the SQL code that filters the Teams model for the competing teams in a football match:

teamQueryString = QString("country_id IN"
"(SELECT country_id FROM tbl_hometeams WHERE match_id = %1"
"UNION SELECT country_id FROM tbl_awayteams WHERE match_id = %1)").arg(match_id)

The result is erroneous SQL and an empty combobox.

Ensure that there are spaces in the multi-line strings so that the SQL code is written properly.