topic Re: select from view in Application Development and Automation Discussions

select from view

Former Member — Fri, 24 Aug 2007 12:27:00 GMT

hallow

i wont to bring fields from <u>view</u> and i wont to now how i do that?

sample will help

i reward

Regards

Re: select from view

Former Member — Fri, 24 Aug 2007 12:29:29 GMT

i thihk u do that in simple select stetment like in regular table?

thankes

Re: select from view

Former Member — Fri, 24 Aug 2007 12:30:09 GMT

getting data from views is same as from db tables....

just look that u have all required fields in the view.

select <fields>

from <view>

where......

Re: select from view

Former Member — Fri, 24 Aug 2007 12:30:37 GMT

Hi,

Same as u can get data from table.

U can directly used view if it is database view. Or y can double click on view it will display tables list chose your table which fields suitable for u and used it.

Rewards points if it is useful.