topic Re: problems on select statement in Application Development and Automation Discussions

problems on select statement

Former Member — Tue, 08 Apr 2008 12:47:44 GMT

Hi Gurus,

Can anyone pls tell me will a select statement on a maintainence view work...................

pls it is urgent.

if it is possible pls tell me how............

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 8, 2008 6:00 PM

Re: problems on select statement

ThomasZloch — Tue, 08 Apr 2008 12:52:09 GMT

and why can't you try this out for yourself?

Re: problems on select statement

Former Member — Tue, 08 Apr 2008 12:53:42 GMT

U cannot write a select on a maintenance view ..

Instead write select on the table for the maintenance view ...

Re: problems on select statement

Former Member — Tue, 08 Apr 2008 12:55:13 GMT

yes it is but u need access key to chenge the maintanece view code .

if you have the key then it is work.

Re: problems on select statement

Former Member — Tue, 08 Apr 2008 12:58:39 GMT

Hi,

the select statement on a maintanence view will work.

for example there is a view called MARCP. just perform a select query giving a condition in your select statement like how you perform for a transparent table. Views are nothing but transparent tables with selected fields between two or more tables.So the data exists in them.

<REMOVED BY MODERATOR>

thanks,

archana

Edited by: Alvaro Tejada Galindo on Apr 8, 2008 6:00 PM

Re: problems on select statement

ThomasZloch — Tue, 08 Apr 2008 13:01:28 GMT

MARCP is a database view.

Selecting on maintenance views is not possible.

Still don't know why the OP can't just try this, takes about 1 minute.

Re: problems on select statement

prasanth_kasturi — Tue, 08 Apr 2008 13:04:55 GMT

write down the select statement as you write for normal tables.

select the fields in the view in the query

regards

prasanth