saving a forms calculated field

[Alex Levy]

I have a calculated field on a form that I want to save to a corresponding field in which the table is based. Basically, I am computing sub-total, discount, tax etc. on a form and have fields in the table for the same. I have seen before where a value can be transferred in this situation.

Any hints are appreciated.

Alex Levy

[Tom Cone Jr]

RE: saving a forms calculated field

Alex,

Context is everything.

/begin hint

If the table(s) that you need to update are the same as the table(s) upon which the current form is based, they're already open. Otherwise your script will need to open them.

Once a destination table is open you must determine whether the correct record is 'current', assuming the record is already present in the table. Otherwise, you would want to begin entering a new record, right? If you are working with the tables that support your form what you see on screen should tell you which record is 'current'. If the record pointer in the destination table is not positioned at the desired record, your script would make an index primary, and then do a fetch_find to position the table to the desired record, thereby making the desired record current.

next your script must determine whether the table is in change mode already, or can be placed in change mode. The goal is to put it in change mode so you can write values from your form into the current record.

Then your script should assign the calculated value(s) to each field. you can batch fields in the same record if you wish. Then, depending on what you want, you can leave the table in change mode, so that other input might be received, or, more commonly, you'd commit the changes to the table.

If you need to update fields in more than one table you must repeat the same sequence for each of them.


/end hint

[Alex Levy]

RE: saving a forms calculated field

Evrything is done and works ok about synchronizing the record with the current record. I guess what I am trying to figure out is how to "assign" a value of a calculated memory variable to a field ?

[Tom Cone Jr]

RE: saving a forms calculated field

Alex,

The discussion in the xbasic reference manual on

tbl.change_begin()

will help. The second example illustrates how simple character strings can be assigned to a field. In your case you don't want to assign a literal string of characters, so you wouldn't use quote marks. Instead of surrounding the string with quote marks, just use your variable's name (without quote marks of course).

-- tom

[Ohlen Cartmell]

RE: saving a forms calculated field

Since you want to save these values, why not make them field rule calculated fields? Then they'll always be a part of the table and the current record.

[Alex Levy]

RE: saving a forms calculated field

Yes, that is what I could not remember. Program is updated and working correctly.

Thanks

Alex