PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/12/2014 4:10 PM by  mterlesky
Querying multiple infosets - duplicate warning
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
mterlesky
IT Analyst
PHS
New Member
(4 points)
New Member
Posts:2


Send Message:

--
09/12/2014 4:10 PM
    Hello - I've created an infoset in order to query the results of two other infosets following the instructions in this post:

    https://www.lawsonguru.com/Forums/t...fault.aspx

    I can run this query against the tables in MS SQL Server Mgmnt Studio with no issues. It returns merged data from the two infosets.

    select a.COLUMN0,b.COLUMN1,a.COLUMN1,a.COLUMN2,a.COLUMN3
    from INFOSET_1086 b, INFOSET_1087 a
    WHERE a.COLUMN0=b.COLUMN0


    When I place this code into my third infoset, I receive the following warning:

    (dataengine: 1011) Ignoring attempt to add duplicate row to infoset.


    If I sample on the third infoset, it shows only data from infoset_1087 only.

    Any help on this would be greatly appreciated!

    Thanks
    Matt
    You are not authorized to post a reply.