topic Re: general in Application Development and Automation Discussions

general

Former Member — Thu, 26 Apr 2007 10:16:17 GMT

what is the use of selection conditions in views?

Former Member — Thu, 26 Apr 2007 10:19:49 GMT

It is same as the where clause of the select query.

Former Member — Thu, 26 Apr 2007 10:19:55 GMT

To restrict the data selected, selection conditions are use.

e.g.:- compare the the view creation with the select statement.

evrything will be clear to you.

select **** --> filed to select

from tab1 tab2 --> tables to join

on fied1 = field2 --> primary keys

where ****---> whatever comes in where condition are selection conditions

Former Member — Thu, 26 Apr 2007 10:20:26 GMT

Hai,

Selection Condtions makes reduced data(rows) satisying the conditons from the specified tables to be present in the view.

regds,

Rama.Pammi

Former Member — Thu, 26 Apr 2007 10:24:28 GMT

Hi,

Using the Selection Conditions we can give the Table and aFiedl name and the

Operator comparitive value followed by AND /OR operator.

using the selection Condition it will give the condition for that Veiw to get the Data

at the Run time.

It will act as the Where condition to fetch the selected condition values for the View.

Thanks & Regards,

Nelson

Rewar Poins if really helpfull