Assure DQ

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.

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