Skip to main content

where condition

Here you can specify a "where condition". The given where condition will be placed within the brackets of a "where" clause. You must not use the "where" at the beginning and the dot at the end of the clause. For example: only the red marked part is to be entered in the input field for getting the following update statement to be built from the input in the "where condition" and other inputs like table name, client, field names and field values:

update usr02 client specified

set:

uflag = 0

locnt = 0

where mandt = '010' and ( uflag > 0 or locnt > 0 ).

Have a look at the table information function behind the small 'i' button near to the input field for the table which is useful for building the "where condition". A double click on a line in the table information dialog transfers the field name into the input field.

####