SQL "View" with TS?

[Schwede]

Hello,

is it possible to handel a SQL "View" with TestStand or the Database Viewer?

I can see my tables but not the view.

greetings

schwede

[AndreasStark]

In the Database Viewer you need to execute a query to get your VIEW results. For TestStand itself you can modify the database schemes and statements in Configure > Database options or use custom SQL query steps.

Creating a TestStand Database Schema from Scratch 

Best Regards,

[Schwede]

Hello,

that's not what i mean. I have createtd an udl-file to connect to the datatbase. If i call this from excel i see all my tables and the "view".

When i call this from the database viewer i can see only the tables and not the "view".

greetings

Schwede

[AndreasStark]

Did you try changing the Viewer options?

[Schwede]

Thankyou,

this is the first thing, the second is that i can`t write to the database.

If i use a table everything is ok. When i took the view i get an error-message:

-2146825037 The recordset don`t support updating. This can be a problem of the constriction of provider or lock type....

Can you help me with this, too?

greetings

schwede

[AndreasStark]

Does that help?
http://digital.ni.com/public.nsf/allkb/A324D2172DD09C08862570F8004FA3C3?OpenDocument

If not please upload your database scheme so I can try to reproduce it here.

[Schwede]

That doesn`t help.

I have attached the file.

schwede