IF used("QM_cond") USE IN qm_cond ENDIF USE qm_cond IN 0 SELECT * FROM qm_cond into CURSOR temp READWRITE ; WHERE f_query_id like qm_list.f_query_id+'%' USE IN qm_cond SELECT * FROM temp INTO CURSOR qm_cond readwrite USE IN temp SELECT qm_cond INDEX ON F_QUERY_ID TAG F_QUERY_ID SET ORDER TO TAG F_QUERY_ID2) do some processing, then want to then update table1.dbf with the records from cursor table1. currently I am co
SELECT * FROM qm_cond INTO CURSOR temp USE IN qm_cond USE c:\rt50vss\data\qm_data\qm_cond IN 0 DELETE FROM qm_cond WHERE f_query_id like qm_list.f_query_id+'%' SELECT qm_cond APPEND FROM DBF('temp') USE IN tempAny suggestions are appreciated