The following code gives everyone an extra day of vacation:

q = new Query()

q.sql = "select * from EMPLOYEE"

q.active = true

do while not q.rowset.endOfSet

   q.rowset.fields[ "VacHours" ].value += 8 

   q.rowset.next() 

enddo