I guess posting on a Saturday that most of you missed this! Anybody got any thoughts?
Thanks & regards, Alastair. ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "R:Base ListServer" <[EMAIL PROTECTED]> Sent: Saturday, October 12, 2002 2:33 PM Subject: Forms question: Updating fields from variables > Back in the deep and distant past my (often faulty) memory tells me that the > way that you could/should set up variables and columns on a form to extract > the value of a column into a variable field and then return the altered > value to the column was like this in the forms variables editor: > > VariableName = ColName > other variables > ColName = .VariableName > > What seems to happen now - and it may have done it this way for ages as I > haven't tried this for ages - is that all the variables seem to get updated > on leaving each field so that the first defined variable overwrites the > change rather than the column getting updated. > > These are the relevant variables on the form that I'm currently working on: > > 10. INTEGER vIntMin = (IMIN(Running_Time)) > 11. INTEGER vIntSec = (ISEC(Running_Time)) > 12. TIME vCombinedTime0 = 0:00:00 > 13. TIME vCombinedTime1 = (ADDMIN(.vCombinedTime0, .vIntMin)) > 14. TIME vCombinedTime2 = (ADDSEC(.vCombinedTime1, .vIntSec)) > 15. TIME Running_Time = .vCombinedTime2 > > When I edit with the form I get this: > > Variables 10 & 11 extract the integer value of minutes and seconds and > display them correctly on the form. > Variables 12 & 13 correctly combine the values into time values. > The Running_Time field displays correctly. > > However, when I change the values in the vIntMin or vIntSec fields what > happens is that the fields revert to their original values on leaving them > and so the form changes nothing when leaving the row. > > The variable fields are set for data to be entered or changed. > > I know that I can use an EEP to do the update but has something changed over > the years that I've missed or am I missing something obvious? > > Thanks in advance for any help, > Regards, > Alastair. > > ---------------------------------- > A D B Burr, > St. Albans, UK. > ---------------------------------- > [EMAIL PROTECTED] > ---------------------------------- > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
