Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only
  • 1.  Assure 9.2/3 DB Layout sql statements

    Posted 08-03-2020 11:17

    What are the limitations in Assure Database layout? Can it create temp tables as part of the query?  Edit tables? drop?  Or does it only accept select statements (read only)?  



  • 2.  RE: Assure 9.2/3 DB Layout sql statements

    Employee
    Posted 08-03-2020 11:41

    Technically you can run inserts and other SQL queries via database layouts, but we'd recommend Select statements only since that is the expected use case that we code and test. The layouts expect to receive a result set (data) back from the SQL query, and depending on which database you're connecting to (and sometimes which driver is used), inserts, creates and deletes don't have any data to return, so the layout (and control) won't have anything to capture due to a null result set. This can cause the layout/control to fail, even though the query was already ran. This holds true even if the query was successful since a result set isn't always returned.



  • 3.  RE: Assure 9.2/3 DB Layout sql statements

    Posted 08-03-2020 12:35

    Thank you Gerard