Copy field's contents

[forskare]

How can I copy the contents of fld1 or fld 2 to fld3? I've been working at this for awhile, tyring to copy, post, etc. So far I'm baffled.

Thanks,

kenn

[Tom Cone Jr]

RE: Copy field's contents

Ken there are several different ways this might be done. Can you describe the context for what you want, including:

1) are all 3 fields in the same table?
2) are they on the same form?
3) when do you want the copy to occur? (when cursor leaves field2? when record is saved? when record is changed?)
4) how do you want changes and deletions handled?

-- tom

[forskare]

RE: Copy field's contents

Tom,

1. They are in the same table
2. The 1st 2 fields, where data would be entered are on the same form. The 3rd field, where the data should be copied to, only needs to be used for storage as a basis for reporting.
3. The copy can occur at any time.
4. There is not likely to be a change but in the event there should be, the copy could replace the value.

Thanks,

Ken

[drgarytraub]

RE: Copy field's contents

you should be able to do something like:

field1.value=field2.value
parent.commit()

field3 can be wriiten to in the same way, but if you want it just for storage, and hidden from the user, then you can hide it in several ways, but I do this:

go into the field's properties, and change the backround and font colors of the field to be the same as the background color of the form; also, be sure the border is set to no border. Then, remove tab stop, and make the field read only and disable it (all through the field's properties). Lastly, move the field out of the way (I move it to the upper left corner), and drag it to a very small size so it doesn't cover any other form objects.

I hope this helps.

Gary

[forskare]

RE: Copy field's contents

Gary,

Field3 will not need to be on the form at all. I'll only need it when creating an expression at report time.

field1.value=field2.value
parent.commit()

I interpret the expression to mean the value in field1 will = the value in field 2. What I need is to have the field1.value or the field2.value copied to field3. I don't understand how the above expression will do that.

Thanks,

kenn

[Tom Cone Jr]

RE: Copy field's contents

You said 'The copy can occur at any time.'

This confuses me. If the tab order during data entry is field1, then field2, and the user keys something into field1, do you want to copy it to field3 as the cursor moves from field1 to field2? Do you want to wait for field2? What if both field1 and field2 have data? Which to copy to field3?

Color me confused...

-- tom

[forskare]

RE: Copy field's contents

Tom,

If feild 1 has data, field 2 will be empty and visa versa.

ken

[drgarytraub]

RE: Copy field's contents

Ken:

field3 can be on the form as a covenience to make the copying easier. What we need to know is when do you want the copying done. If you want it to occur as you enter or leave a field, then put code in the field's event. For example, you can put
field3.value=field.value
parent.commit()

in the OnDepart event of field1. Try it out. It will work.

Gary

[martinwcole]

RE: Copy field's contents

if the three fields are in the same file, then I might write something like this, at your desired event, whether it is a button or whatever:

tbl=table.current(1)
'' number respresents which file in the set where 1 is the parent, 2 is the first child, etc.

tbl.field3=rtrim(tbl.field1) + " " + rtrim(tbl.field2)
parentform:field3.refresh()
end

''if you want field3 to grow each time you could say
tbl.field3=rtrim(tbl.field3) + " " + rtrim(tbl.field1) + " " + rtrim(tbl.field2)

[Dan Blank]

RE: Copy field's contents

Or if this is to happen at every occurance for every record, I would go to field rules. Make Field 3 a calculated field.

Use this calculation in the expression.
rtrim(field1)+rtrim(field2)

That should do it
Dan

[forskare]

RE: Copy field's contents

Dan,

Arguement is incorrect data type. Yet all three feilds are date fields. Will that make a difference?

Thanks,

kenn

[martinwcole]

RE: Copy field's contents

scratch the parentform:field3.refresh(). just noticed that it doesn't need to be on the form.

another option is go the the file's field rules, events tab, and then all the way to the top to the file itself, rather than one of the fields, and then to the "cansaverecord" event. and enter something like this:


tbl=table.get("yourfilename")
tbl.field3=rtrim(tbl.field1) + " " + rtrim(tbl.field2)

this language is absolutely wonderful
following is a snippet i use for maintaining an audit trail file, (entered in fieldrules):

''cansaverecord event
tbl=table.get("payment history")
dim mode as n
mode=tbl.mode_get()
if mode = 2 '1=change, 2=enter
tbl.date_added=date()
elseif mode=1
tbl.date_changed=date()
else
end
end if

[martinwcole]

RE: Copy field's contents

if field1 and field2 are date fields then field3 needs to be a character field - amend the code to the following:

tbl.field3=dtoc(tbl.field1) + " " + dtoc(tbl.field2)

the result looks like this:
"09/03/2000 08/03/2000"

[forskare]

RE: Copy field's contents

I zipped up the table and attached it to this post.

Thanks

ken

[forskare]

RE: Copy field's contents

OOPS, forgot to attach it.