use bigtable use smalltable in 0 order candkey scan for eof("smalltable") scatter memvar insert into smalltable from memvar endscan>I was trying to do it more SQL-ish; is that possible? I thought using APPEND would lock the table header and make it less multiuser.
>>use smalltable order candkey >>append from bigtable ; >> for !indexseek(candkey, .f., "smalltable", "candkey")