How do I detect if a VIEW is present in a database?

[rpp]

Hi Experts,

How do I determine (programatically) if a VIEW is present for within a DBC?

I am trying to create one if it is not found, and if so then I plan to use it.

Thanks in advance.

Richard

 

[markdenby]

Hi Richard,

You can use the INDBC function.

E.g.

? INDBC('someview', 'VIEW')

Mark

 

[Mike Gagnon]

Other than the usefull suggestion markdenby has made, you could also use:

Open Database myDatabase
=ADBOBJECTS(myViews, "View")

Which gives you an array of all views in the database and do an ASCAN on the array to locate the name of the view you are looking for.



Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[rpp]

I new there had to be a command similar to that of USED() or FILE() that I could query to see if my view was in the DBC.

At this time the INDBC() will do nicely.

I looked for something like it however I had no idea what it would be called.

Thanks Experts