Ok, Here is the problem. I need to implement view to enforce a rule I have. I have the following SQL statement:
CREATE VIEW v_new_cable
AS SELECT Make_ID, Model_ID, PurchaseDate, Equipment_ID, Description, Vendor_ID, Image_ID
FROM Inventory$
WHERE Equipment_ID = '3' -- The number 3 represents a cable.
Anyway I check the syntax and that checks out ok. Then I get an Alert Message saying that:
The Query Designer does not suppor the CREATE VIEW SQL Contruct.
What does that mean and how do I fix this?
Thanks!
CREATE VIEW v_new_cable
AS SELECT Make_ID, Model_ID, PurchaseDate, Equipment_ID, Description, Vendor_ID, Image_ID
FROM Inventory$
WHERE Equipment_ID = '3' -- The number 3 represents a cable.
Anyway I check the syntax and that checks out ok. Then I get an Alert Message saying that:
The Query Designer does not suppor the CREATE VIEW SQL Contruct.
What does that mean and how do I fix this?
Thanks!
Facebook
Twitter