Copy data of table tps

[FOlivera]

How can I copy data of several tables tps at other table tps

thanks for your help
Francisco Olivera

 

[Gaudalier]

Well, Francisco Olivera (Do I know ya???), there are several solutions, depending on your target file:

1. If The "Others" have the same Declaration as the target file, I mean, if you have Several Instances of the same file; an Alias and a Simple process like this will do:

!Target, PRE(TAR)
!AliasTarget,PRE(ALIASTAR)
Target{PROP:NAME}='C:\Target.tps'
Access:Target.Open
Access:Target.UseFile

AliasTarget{PROP:NAME}='C:\Source.tps'
Access:Target.Open
Access:Target.UseFile

LOOP UNTIL ACCESS:AliasTarget.next()
  TAR:RECORD = ALIASTAR:RECORD  !COPY ALL FIELDS
  !TAR:RECORD :=: ALIASTAR:RECORD  !copy fields w/same label
  Access:Target.PrimeRecord()   !prime any autoinc. field
  Access:Target.Insert()        !Insert Any Field.
END
Access:Target.Close
Access:AliasTarget.Close

Well, the code above is very simplist, you must to ensure any key that has relation to child files to correctly RI that files.

Any ways, hope this help ya!.

bye. -----
carabez@hotmail.com