How do i copy TempTable from Actual Table?

yukon

Hi Expert,

How to copy actual table to temptable (Same structure).

I wrote like that.

Declare TempCustomer Record (Temporary - Yes)
Declare Customer Record.

Wrote at OnForm - Trigger.

TempCustomer.RESET;
TempCustomer := Customer;
TempCustomer.INSERT;

Message('%1 %2', TempCustomer.COUNT,Customer.COUNT);

Result : TempCustomer.Count is 1.
Customer.COUNT is 68.

What wrong? I want to copy a whole records. Do i need to loop & insert?
Please explain to me.


Best Regards,
Yukon

reijermolenaar

Yep, loop and insert is the only way.

yukon

Hi reijermolenaar,

Yep, loop and insert is the only way.

Thx 4 your reply,
Anybody know other way, please let me know.


I don't want to loop.](*,)

bbrown

yukon wrote:

Hi reijermolenaar,

Yep, loop and insert is the only way.

Thx 4 your reply,
Anybody know other way, please let me know.


I don't want to loop.](*,)

Why not? You can't handle the records if you don't read them.

matttrax

Yeah, you have to read records individually. It's a RECORD because it refers to one record in the table. There are no Table variables or anything.

Perhaps you could explain what you are trying to accomplish? Maybe a temp table isn't even necessary. Either way, 68 records isn't very much to loop through.

kapamarou

matttrax wrote:

Yeah, you have to read records individually. It's a RECORD because it refers to one record in the table. There are no Table variables or anything.

Perhaps you could explain what you are trying to accomplish? Maybe a temp table isn't even necessary. Either way, 68 records isn't very much to loop through.

On the other hand 68000 records would be too much to load into a temporary variable and who knows what impact that would have.

matttrax wrote:

erhaps you could explain what you are trying to accomplish? Maybe a temp table isn't even necessary

I think starting with the above sentence is the best way to go...

garak

For temp. Tables read this before:

viewtopic.php?f=23&t=35382