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.  Call a procedure form Infogix Assure

    Employee
    Posted 08-06-2020 06:57

    Hi,

    I have a procedure that has to be run before I can capture data from the view I'm going to work with, in infogix assure.

    I'm not sure if I'm right , but any query, other than a select query in layout, throws an error. Has anyone faced this situation before, is there any way we can solve this or is there a built in solution for this in infogix assure?

    Please help!

    Thanks.



  • 2.  RE: Call a procedure form Infogix Assure

    Employee
    Posted 08-13-2020 11:24

    Assure's database layouts were coded with SELECT statements in mind. While some other forms of statements could work, they're designed around getting data back directly. Some more information on this can be found in the post below:

    https://support.infogix.com/hc/en-us/community/posts/360049033174-Assure-9-2-3-DB-Layout-sql-statements