Temp Table reset

spiky_golden

Hi,

I Have a strange issue, I have 2 temp tables (of custom type). I Load the first one with some data from 2 other tables. Then I copy Temp Table 1 to Temp Table 2. With "Temp Table 2.COPY(Temp Table 1);" When I check Both Table have the same COUNT. I Need to add more lines from differente table and differente filters in the Temp Table 2. When I call my function to adde more lines the COUNT of Temp Table 2 is now zero. Both Table are set in Globals. I even try to pass Temp Table 2 to my function with the var attribute set. No lock.

Do you have any idea?

kapamarou

Read this to see if it helps...

viewtopic.php?f=23&t=32098&start=0

spiky_golden

It Clear a lot of point that I have missed. For First a temp record is actualy a varaible in memory so when allocate it's only the skeleton of the objet (I should have known that!). I was hoping to have a quick way to fill the 20k items on one line...

I guest I have some loop to do!

Thanks.

kapamarou

You're welcome.