Specifies the SQL condition corresponding to the WHERE part of a SELECT statement which would
return only 1 row (the expression of the primary key).
For example for a table created as <![CDATA["CREATE TABLE mytable (part1 int NOT NULL, part2 string NOT NULL,
name string, PRIMARY KEY (part1, part2))"]]>, and if pmodel corresponds to the execution of the
<![CDATA["SELECT name, part1, part2 FROM mytable"]]>, then the sensible value for sql_where would be
<![CDATA["part1 = ##-1::int AND part2 = ##-2::string"]]> because the values of the 'part1' field are located
in pmodel's column number 1 and the values of the 'part2' field are located
in pmodel's column number 2 and the primary key is composed of (part1, part2).
For more information about the syntax of the parameters (named <![CDATA["##-1::int"]]> for example), see the
<link linkend="GdaSqlParser.description">GdaSqlParser</link> documentation, and
gda.data_select.DataSelect.setModificationStatement.
Specifies the SQL condition corresponding to the WHERE part of a SELECT statement which would return only 1 row (the expression of the primary key).
For example for a table created as <![CDATA["CREATE TABLE mytable (part1 int NOT NULL, part2 string NOT NULL, name string, PRIMARY KEY (part1, part2))"]]>, and if pmodel corresponds to the execution of the <![CDATA["SELECT name, part1, part2 FROM mytable"]]>, then the sensible value for sql_where would be <![CDATA["part1 = ##-1::int AND part2 = ##-2::string"]]> because the values of the 'part1' field are located in pmodel's column number 1 and the values of the 'part2' field are located in pmodel's column number 2 and the primary key is composed of (part1, part2).
For more information about the syntax of the parameters (named <![CDATA["##-1::int"]]> for example), see the <link linkend="GdaSqlParser.description">GdaSqlParser</link> documentation, and gda.data_select.DataSelect.setModificationStatement.