Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unanswered: Cannot Create new View!!!

    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!

  2. #2
    Join Date
    Jul 2003
    Posts
    45

    Re: Cannot Create new View!!!

    What are you using to write the query, i.e. what editor?
    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  3. #3
    Join Date
    Jul 2003
    Posts
    3
    I am creating a new view. (right click new view)

    I am then typing in the following into the middle white box.

    (I'm a new to SQL Server)

  4. #4
    Join Date
    Jul 2003
    Posts
    45
    Dont know the answer to that one..try posting a question on this forum.....:

    http://www.sqlservercentral.com/foru..._Title=General
    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  5. #5
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    when you use enterprise manager to create a view:
    - to enter the select statement in the middle box
    - click the save button in the left top
    - enter the new for the view and press ok

    If you want to type your complete statement yourself, you can use the Query Analyzer.
    Johan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •