set_row_selection_condition_sql


Description:

public bool set_row_selection_condition_sql (string sql_where) throws Error

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 = ##-1GdaDataSelect::int AND part2 = ##-2 GdaDataSelect::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["##-1GdaDataSelect::int"]]> for example), see the <link linkend="GdaSqlParser.description">GdaSqlParser</link> documentation, and set_modification_statement.

Parameters:

this

a DataSelect data model

sql_where

an SQL condition (without the WHERE keyword)

Returns:

TRUE if no error occurred