hello baaner,

in select statement if we are using
as set with 1 rows
what is the meaning of this statement

thanx in advance

"as set with 1 rows" will return one and only one record regardless of what the "where" statement may otherwise yield.

The "order by statement" if used, will determine which record if the is more than one candidate is yeilded by the where statement.

Note you could also say as set with 10 records or some other number if that made sense.

I have found this "set statement to be very useful when looking up records such as pricing and cost tables to find the appropriate date to use in the key.

Terry

Refer to the link for more info -

SET specification (http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_set_specification)

thanx for the reply