query infoset problem

[Former Member]

Hi Gurus,

I hope this is the right place to ask about queries and infosets.

I added an additional field to a infoset which I can use in the query.

It's an additional field and it's a field from a different table. (Main infoset is from CATSDB, and the new field is from PRPS table).

In the output list I see the data correctly presented, but the selections screen value is not taken into account.

I tried editing several coding blocks, but I cannot 'skip' a record e.g. if it's not validated by the new selection option...

[Former Member]

That should be taken into account..

Have generated your infoset in SQ02 before generating query in SQ01.

Hope you have maintained proper join condition in infoset.

G@urav.

[Former Member]

Hi G@urav,

thank you for your very fast reply. I added additional fields to the Dbase, join is greyed out in the menu...

[Former Member]

Hi,

Please adjust the infoset (You will find the adjust button on the top of infoset menu)...

Then try to activate and generate the infoset and then the query.

This will solve your issue

Regards

Shiva

[Former Member]

Hi Shiva,

I tried that, but that also didn't solve the issue I'm afraid...