AnsweredAssumed Answered

How to copy fields between two different databases

Question asked by Sumsar on May 17, 2010
Latest reply on May 17, 2010 by aammondd

Title

How to copy fields between two different databases

Post

I have two seperated databases.
How do i copy all info from all the fields in database01 to fields in database02?


This is what i have tryed:

---------------------------------------------------------------
Database01, containing fields:

a1
a2
a3

With a button containing the script:
Copy[Select;database01::a1]
Open File ["database02"]
Perform Script ["pasteintodb02" from file: "database02"]


and Database02 containing fields:

b1
b2
b3

Database02 has the script "pasteintodb02" attached to it:
New Record/Request
Paste [Select; database02::b1

---------------------------------------------------------------

What it does is, that it copy from database01, field a1 and paste it into a new record in database02 in field b1.

What i want is to copy a1,a2,a3 from database01 into (a new record in) b1,b2,b3 of database02.

The problem is that when i use the copy/paste method it will only copy one field not all of them.

 

 

I´m not that good at FM so if you can help, then please be verry graphic about how to do it ;-)


















Outcomes