>>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
>
I enclosed the error message..