Open Forum

 View Only
  • 1.  Dexterity and SQL views

    Posted 30 days ago
    Hello all,

    I have an urgent issue I need to resolve.

    I have 4 production databases, all identical (4 different countries).

    I have made an update to a custom view within SQL and added the extra columns to the table definition within Dexterity.

    When I run the application in 3 of the databases, all is working correctly (good news for me).

    However, one database (the biggest and most heavily used) is not working.  When I try to access the view using a simple form, I get the following error:




    Now, as I said, every database is identical (schema wise).  I have copied the same dictionary to every location and dropped and recreated the view in every database, but I am still getting this error.

    I need to have this resolved before Christmas so I am getting desperate.

    Does anyone have any ideas what might be causing the issue.

    The view name and table definition are identical across all databases.


    Regards,

    Mark Fraser
    IT Applications Manager

    ------------------------------
    Mark Fraser
    IT Applications Manager
    TR Pty Ltd
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Dexterity and SQL views

    Posted 29 days ago
    Problem resolved.  I discovered that when I recreated the stored procedures for the view, they didn't actually change for one database.

    I did that using a program within our application to drop and recreate the procedures and ran the same program against each database.

    Not sure why that happened but now it is found, I can upgrade that installation to the latest version of our software.

    ------------------------------
    Mark Fraser
    IT Applications Manager
    TR Pty Ltd
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role