Assure DQ

 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