If I just specify one payroll it works perfectly fine. However If i specify a list i get issues with the next-rowid and setting the restart-rowid for the next batch, I believe this is because the query has changed and it doesn't know the rowid anymore. I get a message "Cannot reposition query to specified rowid (7331)"

When I first developed this I initially used a list so I can ensure that I still use the required index on the table and don't break it by using a lookup function within the query.

I'm a bit stumped on how I can ensure i process all the required payrolls but ensuring that batching will work and the index will remain in tact.

Anyone have any ideas? Only one left I have is to try and maintain the context of where i am in the DO loop between fetches of data.

Thanks

Paul

Paul Mowat

Principal Software Developer

Advanced Business Solutions

You have posted to a forum that requires a moderator to approve posts before they are publicly available.