🚀 go-pugleaf

>Thanks for the information. But, I cannot seem to make it work the way
>I want. I guess I don't know enough about canGetRow and how to insert
>resulting rows into a temporary table.


The updateSet object's source property can be set to the canGetRow'ed
rowset. Try that, or you might create the temp table with the same structure
as the canGetRow'ed
table, instantiate a query for it, and loop through the canGetRow'ed table,
e.g.:

do while not rowset1.endOfSet
   rowset2.beginAppend()
   for i = 1 to rowset1.fields.size
      rowset2.fields[i].value = rowset1.fields[i].value
   next i
   rowset1.next()
enddo
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.lonestar.texas.net/~moursund
Try these help resources:
http://forumsearch.borland.com:88
http://www.dejanews.com/home_ps.shtml