SET TALK ON SELECT modacad.mainkey as mainkey, planning.planextra4 as group, planning.planextra1 as element, planning.planextra3 as weight ; FROM "U:\Questpdm\Data\modacad.dbf", "U:\Questpdm\Data\planning.dbf" ; WHERE modacad.mainkey=planning.mainkey and modacad.mainkey="T56*SS2004*NEIL001*SAMPLE" ; AND planning.lev1=1 ; INTO CURSOR fablinsty SET TALK OFFThen I need to copy those records into a new cursor. I could SQL to a cursor but I need to do the same thing again with another table. Basically I have 2 seperate tables and I want all of the records from both tables into a new table. Therefore I thought I would copy the records from both tables into my newly created cursor.
CREATE CURSOR crsrisk ; (Mainkey c(30), Group C(30), Element C(30), Weight C(10)) APPEND FROM fablinsty FIELDS mainkey, group, element, weightThis causes a problem in that when I run this it is saying that it cannot find fablinsty.