replacing field content

[tintan]

hi guys

i need a little help here. i'm new to the scripting in FM. please if it's not too time consuming somebody help me with the following:

i have a field f1 like this:

[empty]

[empty]

123

234

345

and then a filed f2 like this:

123

234

345

456

567

what i'd like to do is a script that checks if f1 is empty - if it is does nothing to the f2, but if f1 is different then nothing set f2 to the value of f1

iguess it's not very difficult script to do but i couldn't get it to work.

help please.

franz

[LiveOak]

GoTo Record/Request/Page[first]

Loop

If["notIsEmpty(f1)"]

SetField["f2","f1"]

End If

Goto Record/Request/Page[Exit after last,Next]

End Loop

-bd

[Chuck]

quote:

---

Originally posted by tintan:

hi guys

i need a little help here. i'm new to the scripting in FM. please if it's not too time consuming somebody help me with the following:

i have a field f1 like this:

[empty]

[empty]

123

234

345

and then a filed f2 like this:

123

234

345

456

567

what i'd like to do is a script that checks if f1 is empty - if it is does nothing to the f2, but if f1 is different then nothing set f2 to the value of f1

iguess it's not very difficult script to do but i couldn't get it to work.

help please.

franz

---

SetField["f2",Case( IsEmpty(f1), f2, f1 )]

[tintan]

thanks.