Database Views

[Former Member]

HI,

Is it possible to use databse views in SBO. Can we access it thru DBdatasource?

Can anyone tell how can this be done?

Thanks

Amudha M.

[barend_morkel2 · Accepted solution]

Hi Amudha,

Yes you can - in your SQL query line type "SELECT * FROM -View-", the same as you would do in query analizer.

Test this in SBO Query Generator - you'll see it works.

(You access the view as if it is a table)

You should be able to access it through DBdatasource - let me know!

[Former Member · Accepted solution]

Thanks Barend,

I tried using the view as if it is a table through DBdatasource.

but no luck. if anyone has the sample code can you post it...

Amudha

[Former Member · Accepted solution]

Hi Amudha,

Are you using your own SQL view?

When you declare your SQL statement and reference your SQL view, include the owner. Here's an example, I tried this and it worked well for me.

select * from <b>bwuser</b>.SBO_SALES_SO

*Note: SBO_SALES_SO is an SBO view.

Hope this helps!

Donna