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
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
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