Natasha
6th February 2003, 08:35
I am tring to create display session, which should change query.extension at button click

before.program:
comp = get.compnr()
query.extension = "tfacp200.tpay in (tfacp.tpay.advance, tfacp.tpay.unallocated) and tfacp200.balh <> 0"

choice.user.0:
on.choice:
query.extension = "tfacp200.tpay in (tfacp.tpay.advance, tfacp.tpay.unallocated)"
rebuild.query()

But I can't refresh screen immediately. I tried: display.all(), wrebuild(0), refresh.curr.occ()
for i = 1 to filled.occ
refresh.curr.occ()
endfor
Byt it is all useless

any idea?

Gerhard Wandl
6th February 2003, 08:48
perhaps with: "execute(first.set)"

Natasha
6th February 2003, 08:53
thanks, it's works

jaapzwaan
6th February 2003, 10:45
execute(first.set) will always go to the first records in the view. So, this will show different records if you are at the bottom of a large list.
execute(find.data) will do a reread of the database from the point where you were.
Therefore I advice to use execute(find.data). This is also the command that is called for the "Refresh F5" menu entry.

Regards,
Jaap Zwaan

osofusion
5th September 2014, 16:48
try with that:
query.extension.where = "tfacp200.tpay in (tfacp.tpay.advance, tfacp.tpay.unallocated)"
rebuild.query()


Regards