how to put the same value in a "reset" field in all records of a DB

[barbaras]

Hi,

1- I would like to put the same value, let's say "0", in a field (named "reset") in all the records of the entire DB.

2- Is it any way to save the answer of a message(OK or cancel or whatever) in a field, in order to do something like : IF field = "OK" do blah blah..etc.

Thanks a lot, in advance for your help.

[Chuck]

1:

One way is to use the replace command or script step. You need to be on a layout that has the field you want to change. Click into the field and enter the value you want all the fields to have. Then choose Replace from the Records menu. The default choice will be to use the contents of the field in your current record, so go ahead and click "Replace".

If this is a one time operation, this is probably the way to do it. If the system is being hosted and there are users accessing records at the time you do the replace, however, those records could be locked, and the replace won't happen on those records. If this could be the case, perform a search for the records that didn't have the replace done (by entering Find mode, entering a 0 into the field and clicking the omit checkbox in the status area) and try doing the replace again on just those records. Or go to each record in turn and try to do it manually.

2.

I usually have a field which I call gDialogResult which is a global text field. After having a Show Message script step, the very next script step is Set Field [ gDialogResult, Status( CurrentMessageChoice ) ]. Then I use an If [ gDialogResult = "OK" ] and so on to decide what steps to take next.

Chuck

[barbaras]

thank you chuck !

everything works fine.