I was wondering if anyone would be able to help me out with my coding problem. I have created a SELECT-SQL statement and placed it into a cursor. Now I am trying to get that data moved into a temp file so that the user will have the ability to edit the table. Since Fox 6 cannot allow the cursor to be editable, I could see no other way. An array would eventually blow "not enough memory" error. I tried to have it inputed into the table directly, but it would overwrite the structure. Moving it from a cursor to a table is my only thought. Any suggetions or hints? Thanks!!
*-- 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 MySqlCursor
BROWSE
SELECT schedule_temp