Perfect answer! Thanks! To anwer your first question, the columns were getting updated from lookup tables. Part of my confusion (besides my age and the late hours I keep) is that my forms were mostly created by Rbase during the conversion/update process. All my forms had lookup expressions for columns so my converted forms have them. I don't think that is supported anymore, but it works so long as rbase created the expressions for me. Mike
--- On Sun, 5/27/12, Javier Valencia <[email protected]> wrote: From: Javier Valencia <[email protected]> Subject: [RBASE-L] - RE: Best way to update columns not in a form To: "RBASE-L Mailing List" <[email protected]> Date: Sunday, May 27, 2012, 11:27 PM Mike, >>> Updating colums that are present within the form is easy using EEPs. <<< Why do you need an EEP to update a column? If the column is in the form simply change the value in the DB Edit field. >>> But, if the column that needs to be updated is not in the form, then what is the best way to update those columns? <<< A column does not need to be in the form or be visible to be updated. Simply set a variable equal to your Primary Key and then use it to do the update. For example: If you Primary Key is RecNo, create a variable in the form called vRecNo (or whatever you want) and make it equal to the Primary Key, this will store the value of the Primary key of the current row. Now, whenever you want to update any column (in the form or not) simply use: UPDATE your_table_name SET your_col_not_in_form = .vWhatever WHERE RecNo = .vRecNo You can run this command from an EEP in a button, or on row entry, row exit, after saving….or wherever you process flow dictates. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair Sent: Sunday, May 27, 2012 9:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Best way to update columns not in a form Hi All, I have a DB Edit within a scrolling region on a form. Updating colums that are present within the form is easy using EEPs. But, if the column that needs to be updated is not in the form, then what is the best way to update those columns? Should I place the columns within the form and make them invisible (or very small) and then use an EEP to update them? Or is there a better way? TIA Mike
