Combine and Insert Text among databases

[johnnyng]

Hi,

I am new to script but found it very much interesting. I have two questions that I can't solve from Help or Manual:

1. I want to combine a few text fields in a database1 so that I can copy the combined text into another field in databse2, how can I combine text?

2. I managed to copy and paste the text of a field from one database into another, but when I need to add the text into the field, I want to add into the field but not clearing out the original text in the field (becuase it's a field to hold both historic and new notes of communication). I also need to add the new text at the top of the field but the default in FM will add the text at the end. Any trick in doing so?

Thanks very much.

[LiveOak]

Use a Set Field() command referencing both a record in the current file and a record in another file using a relationship. Using Set Field, you can concatenate fields in any order:

Set Field (FieldA, FieldA & FieldB)

Set Field (FieldA, FieldB & FieldA)

If you need to do this for multiple records, you can either put the Set Field() in a loop or use the Replace command with a calculated result.

-bd

[johnnyng]

Hi LiveOak,

Thanks and I have just make it works. However, there is another one here - when a user click a button in DB1, it will trigger a script in order to add a new record in DB2, I used the Pause/Resume Script () to allow the user the enter data into the record. There is a Continue button be fault from system which is fine, but there is also a Cancel button. So when a user click this button, he can stop the script, minimize the db2, and go into the other dbs hosted in the same server, do you know how to avoid this? Thanks.

BR

Johnny

[johnnyng]

Thanks Kurt. I tried it with "on"...too messy the day I guess.

Regards

Johnny

[Kurt Knippel]

quote:

---

Originally posted by johnnyng:

Hi LiveOak,

Thanks and I have just make it works. However, there is another one here - when a user click a button in DB1, it will trigger a script in order to add a new record in DB2, I used the Pause/Resume Script () to allow the user the enter data into the record. There is a Continue button be fault from system which is fine, but there is also a Cancel button. So when a user click this button, he can stop the script, minimize the db2, and go into the other dbs hosted in the same server, do you know how to avoid this?

---

Allow User Abort [off] script step will remove the cancel buttons.