Browse on prop:sql

Hi All,

I want to fill a browse with an sql statement like this:


Self.View{prop:sql} = ‘select xmlid, xmlTag , xmltagwaarde from xml002 where xmlid=1’


The code is in the reset embed. But it ad’s the records up on all the existing records. How can I clear the browse so only my prop:sql records remain?

Regards Joep