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
