How to Copy a table into Temp table

Hi,

I copy a table into temp like this:

repeat

temp.init;
temp.COPY(Orig);
temp.insert;

until Orig.Next = 0

this is very slow and i was wondering if there a better way?

There isn’t

I’m afraid I agree … .

There is no way to generate a INSERT INTO temptable SELECT * FROM table… from C/AL (or how was it again?).

May be a bit shorter:

repeat

temp := Orig;

temp.INSERT;

until Orig.NEXT = 0;

But this isn’t going to be faster, I guess…