There are additional fields in the currently open table before the select. It has about three extra logical fields that are required to the form. I tried your method, but it blew me out. I am going to try to modify it somemore to see if I can get anywhere.
>Hello,
>
>Let's make sure I'm following you here. Are you saying you have an existing table structure, which contains all the fields in your SELECT statement, plus some additional ones?
>
>How about:
>
>*-- DUPLICATE ALL DATA INTO A SQL-STATEMENT FOR TRANSFER --*
>SELECT a.inv_no,a.part_code,a.part_desc,b.mold_code,b.mat_code,a.part_qty,a.part_cost ;
> FROM order_items a, part_file b ;
> WHERE a.inv_no = cInvoiceNumber AND a.part_code=b.part_code ;
> INTO CURSOR MySqlCursor
>select existingTable1
>append from dbf("mySqlCursor")
>
>
>This will work as long as the field names are the same. If they are not the same, you can use the AS clause after each field in the SELECT to give each field a different name.
>
>HTH...
>
>>
>>1: I tried that, but did not work because I need to use the structure in the other free table
>>
>>2: Does that not require a lot of memory. Plus it still overwrites the table structure
>>
>>3. Overwrites the structure.