• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 5195 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Dell V7.02: Properly delete custom view

fatih.eroglu
over 7 years ago

Hello i have created a custom view with the schemaextenion tool.

Unfortunately I have a small mistake in my view and I need to recreate it.
How can I properly delete a custom view? Any Ideas?

I figured out 2 Stored-procedures in the Database "QBM_PViewDrop" and "QBM_PTableDrop" which sounds like that what i need, but I am not sure about.

Thanks Fatih

  • 0 over 7 years ago
    Hi Fatih,
    You need to delete a corresponding entry from DialogTable along with all corresponding entries from DialogColumn.
    There might be some more dependencies but you'll see them while trying to delete records from DialogColumn.

    Paul.
  • 0 over 7 years ago
    Hello Paul,

    you right. You need to delete the entries from your view in following tables:

    -DialogObject
    -DialogColumnGroupRight
    -DialogColumn
    -DialogTableGroupRight
    -DialogTable

    And finally a compile of the database.

    Thanks, Fatih