USE IN ( SELECT("qm_cond")) USE IN ( SELECT("qm_cond_table")) USE qm_cond IN 0 ALIAS qm_cond_table SELECT * FROM qm_cond_table into CURSOR qm_cond READWRITE ; WHERE f_query_id like qm_list.f_query_id+'%' INDEX ON F_QUERY_ID TAG F_QUERY_ID SET ORDER TO TAG F_QUERY_ID ... SELECT qm_cond_table APPEND FROM DBF('qm_cond')>Looking for ways to make my code more efficient or at least not as embarressing.
>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_ID >>
>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 temp >>