DataSelect.setRowSelectionConditionSql

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.