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].

Parameters

sqlWhere

an SQL condition (without the WHERE keyword)

Returns

TRUE if no error occurred

Throws

[DataSelectException]