topic Re: Problem with Query-Infoset in Application Development and Automation Discussions

Problem with Query-Infoset

marcelom_bovo — Tue, 21 Apr 2009 16:31:06 GMT

Hi People,

Im trying to make a query(infoset), but I'm having a problem,

The user is gone to put the company code and the Financial Transaction(from VTBFHA), and i have to show in the result the last date from the table VTBFHAZU, and if there is no line in the table VTBFHAZU, I won't show the company code and the Financial Transaction.

How can I do that, because IF a link then with a JOIN in the infoset, it will bring me more than 1 line if the VTBFHAZU has more than 1 with the same Financial Transaction, but if I dont JOIN then, the report may bring me results without date.

The question is, how can i delete lines from the display table.

Tks

Re: Problem with Query-Infoset

Former Member — Tue, 21 Apr 2009 16:40:28 GMT

Hi,

Please try this..in the infoset you can write additional coding..in the event...RECORD PROCESSING/END-OF-SELECTION (before list)...and filter the data..

Thanks

Naren

Re: Problem with Query-Infoset

marcelom_bovo — Wed, 22 Apr 2009 01:01:42 GMT

yes, but, how can I code that?

for example, I could do: DELETE ADJACENTE DUPLICATE ENTRIES FROM,

or Loop at table, and delete the ones wich has the field empty.

but from wich table?

Re: Problem with Query-Infoset

marcelom_bovo — Wed, 22 Apr 2009 12:34:57 GMT

I Tried to debug the program to get the tables, but didnt work(the name was %dtab).

for exemplo:

Now, I'm making a query that sums the values of an amount, its working, but the lines are duplicated.

I have to delete the duplicated lines.

Tks.

Re: Problem with Query-Infoset

marcelom_bovo — Wed, 22 Apr 2009 20:13:19 GMT

Hi again,

I made it

In SQ01, i changed the output layout rom basic list to statistic, and then it worked like a DISTINCT command.

Thanks guys