cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract data of a view

Former Member
0 Kudos

Hi,

I'm working with VB.net and SBO 2005. My question is :

How to extract data of a view ?

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Gianluigi,

I want to say by view a virtual table the contents of which are defined by a request.

AlexGrebennikov
Active Contributor
0 Kudos

Hi!

View is just a T-SQL statement stored and saved on the server side. All you need is to query this view using the following syntax:

SELECT <view columns> FROM <view name> WHERE <conditions>

So the syntax is the same as T-SQL SELECT-clause

HTH

Former Member
0 Kudos

Hi Alexey,

Tnx for your help.

Answers (1)

Answers (1)

Gianluigi
Product and Topic Expert
Product and Topic Expert
0 Kudos

What do you call a view ? Do you mean how to read the values in the items of a form ?