Hi Will,

Apologies. I must have inadvertantly clicked on the 'send' button instead of 'preview' in the first instance.

Your solution is certainly slick, though it does assume that Jimi's filter condition, or data extraction critera, does not have joins or references to other tables.


>Hi Sanjay,
>
>Just FYI, you can edit a message after you have posted it (recent addition) so you can avoid this double posting stuff (I hate it when that happens!)
>
>Also.. Bit of a sledgehammer to crack a nut don't you think? see my post to Cetin.
>
>>Of course you can open 2 tables or more at the same time. Use SQL statements in your loop thus;
>>

>>Create Cursor MyCursor (yourfieldname1 type precision, ...)
>>ADIR(FileList, 'SmallTable_*.dbf')
>>
>>*-- ALEN() will give you the row count of the array fileList
>>For x=1 to ALEN(FileList,1)
>>*-- Open the table in an unused work area
>>  USE FileList[x,1] IN 0
>>
>>*-- Extract your data
>>  SELECT yourFields
>>  FROM (FileList[x,1])
>>  WHERE yourSelectCondition
>>  INTO ARRAY dataArray
>>
>>*-- Insert the data into the Cursor
>>  INSERT INTO DBF('MyCursor') FROM ARRAY dataArray
>>
>>*-- Close files and clean up
>>  USE IN (FileList[x,1])
>>  RELEASE dataArray
>>Endfor
>>
>>
>>

>>Regarding the sort order, you could sort MyCursor after all inserts are finished. You will not be able to sort while inserts are going on since you cannot 'insert before' a record.
>>
>>Cheers