topic Re: query infoset problem in Application Development and Automation Discussions

query infoset problem

Former Member — Wed, 08 Oct 2008 09:27:04 GMT

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 — Wed, 08 Oct 2008 09:29:13 GMT

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 — Wed, 08 Oct 2008 09:31:00 GMT

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 — Wed, 08 Oct 2008 09:32:24 GMT

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 — Wed, 08 Oct 2008 13:18:53 GMT

Hi Shiva,

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