Copying fields and insert sysdate

[Pushkin]

Hello,

I would like to know how you can copy one field in to another? So eg. you have ID1 and it also have to go in ID2.

I also want to know how you can put the sysdate in a field.

Thanks in advance

 

[lewisp]

Can you be more specific what you require here. I presume this is forms. Are you wanting to populate a non-base table field? Do you want sysdate to appear automatically when inserting a new record?

For the ID use a post-query trigger to copy one field to another:

:block.field2 := :block.field1;

For the sysdate put $$DATE$$ or $$DATETIME$$ in the default value property of a date or datetime field.

 

[Pushkin]

I would like to copy one id into another and then write the 2 fields into a db. The first id is a sequence and the other one is a copy of it.
I want that the date is automaticly inserted into the field.

I'm using webdb instead of forms, but I assumed that this works the same way.