Copy data of table tps
Copy data of table tps
(OP)
How can I copy data of several tables tps at other table tps
thanks for your help
Francisco Olivera
thanks for your help
Francisco Olivera
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
Computer / IT professional?
Join Tek-Tips Forums!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts - Keyword Search
- One-Click Access To Your
Favorite Forums - Automated Signatures
On Your Posts - Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Talk To Other Members
RE: Copy data of table tps
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