q = new query()
q.sql = [select * from :dbasesamples:orderitems]
q.active = true
?q.rowset.applylocate("partid= 100"),q.rowset.fields["orderid"].value
q.active = false
q.sql = [select * from :dbasesamples:fish]
q.active = true
q.rowset.next(3)
?q.rowset.applylocate("name = 'Clown Triggerfish'"),q.rowset.fields["id"].value
q.active = false