>I tried this but got the same result...:(
>
>

>SELECT * FROM bp_eng_t;
>union all;
>SELECT * FROM bp_eng_o;
>into CURSOR temp
>

>
>>>How can I merge two tables?
>>>I tried to merge two tables(thier sturctures are identical) with the command "union" but it failed.
>>>I got an error message which says the memo file(fpt) is missing.
>>>
>>>Thanks,
>>>Tamas
>>
>>Memo file is FPT :-)
>>use UNION ALL instead.
>>When you use just union SQL Engine tries to filter duplicated records this operation is invalid for Memo, BLOB etc. fields.


What is the error?
Because this works for me:

CREATE CURSOR Crs1 (Fld1 I, Fld2 M)
FOR lnFor = 1 TO 10
    INSERT INTO Crs1 VALUES (lnFor, REPLICATE("A", lnFor))
NEXT
CREATE CURSOR Crs2 (Fld1 I, Fld2 M)
FOR lnFor = 11 TO 20
    INSERT INTO Crs2 VALUES (lnFor, REPLICATE("A", lnFor))
NEXT


SELECT * FROM Crs1;
UNION ALL;
SELECT * FROM Crs2;
INTO CURSOR crsTesdt


BROWSE NORMAL