×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Copy data of table tps

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

RE: Copy data of table tps

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

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.

Join Us             Close