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 "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 "SELECT name, part1, part2 FROM mytable", then the sensible value for sql_where would be "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 "##-1::int" for example), see the GdaSqlParser 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