And, to restate what Razzak has mentioned: you cannot manipulate the values in a computed column. Any form edit controls that are not read-only, or PROPERTY commands that attempt to change the value in the computed column may well generate an error.
Finally, you may have hit the nail on the head yourself below: as further development work is done on RBG7x, actions which might used to work may now not work because they shouldn't have worked in the first place, and the code is being (appropriately) tightened. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Docherty Sent: Monday, February 11, 2008 12:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB LookupListBox Error Razzak, Thanks for your replies. I will do as you have suggested and will let you know what I find. To answer your easy questions though, the column in question is a computed column, (on a computed column - perhaps not the most elegant solution) and I could change it using Data Designer to match the definition in another table, but the form isn't trying to change it at all it just links the two tables. (I had sent the sample earlier though so I hope I am not wasting anyone's time - the fact that this worked earlier with 7.5 and doesn't now just suggests that something has changed, or maybe that what I could 'get away with' in earlier versions is not possible now.) Thank you. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Monday, 11 February 2008 5:53 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB LookupListBox Error At 04:23 AM 2/10/2008, John Docherty wrote: >I have a DBLookupListBox which has worked previously without >problems, however I now get an unnumbered error message stating >"Field de5 cannot be modified" when I click on an item in the >list. de5 is the data field (column), from a view, specified in >the listbox property. John, Have you changed the definition of the "de5" column? Is it a "Computed" column? If the "de5" is a computed column, you cannot update/modify the computed column. Forcing to update the computed column using DB Edit control in a form will result in that -ERROR- message. FYI, computed column(s) are updated automatically. Very Best R:egards, Razzak.
