walter01
8th December 2008, 10:25
Hi all,

I have a (initially standard) display session shows all records in the standard table.
Can anyone tell me how to skip certain records in the table ?
The form should display all records in the table excluding records that have field seqn set to 0.

kind regards,

Walter

george7a
8th December 2008, 10:34
Hi,

Check the skip.io function (http://www.baanboard.com/programmers_manual_baanerp_help_functions_db_operations_skip_io).

I hope it helps,

- George

walter01
8th December 2008, 10:59
Thanks George,

I used the following code. It works but is this the correct way to solve this ?
Will it create new problems ?


main.table.io:
after.read:
if tdwhc022.seqn = 0 then
skip.io("")
endif

zardoz
8th December 2008, 11:54
this is more performant:

before.program:
query.extension="tdwhc022.seqn <> 0"

walter01
8th December 2008, 12:39
Thanks for the replies.

Walter