Hello,

I´m new in programming and I don´t understood it yet well.
But I have the standard table tccom115 (in LN) with fields: pfbp, cban and bano. It is possible group the dates only by first filed = pfbp.

How can I group the table (and then the session too) by another filed? For example by "bano". The field "bano" is no grouping column=no index.

Could somebody give me the muster of script?

Thanks and regards,
T.

select *
from tccom115
where tccom115._index 1 between {<values from} and {<values to>}
group by bano, pfbp, cban,
order by bano, pfbp, cban

Sorting in the session can only be done by means of an index.

"Arijke" is right, I missed the session part in your posting, sorry. So the only way is to add an extra index on your tccom115 table, however I do not reccomend modifying standard table. Futhermore you need the development kit to makes changes to tables.

as u are in programming in LN, u can take a look at query.extension's functions in help.
Maybe it can show u some ways to control and filter data in a session.