Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Views to MAS 200 Database

Status
Not open for further replies.

PriceDon

IS-IT--Management
Sep 4, 2007
5
US
thread637-1405340

I have created an SQL linked server to my MAS200 database, this all works fine. I then created a blank database with a view to AP_Vendor. The SQL syntax I used to create the view was:
CREATE VIEW Vendors AS
SELECT * from OPENQUERY(MASLINK, 'SELECT * FROM AP_Vendor')

My problem is when I try an access the data, I don’t see the view. I’m wondering if it has something to do with a no primary key.
Does anyone have any idesas?

Thank you
Don Price
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top