John, Are you getting the error when you run the form in the designer (dataset is read only) or when you simply run the form? Is your view defined correctly in an "on before design action" or in an "on before start EEP" when you're in the designer (in other words does it have data)? Have you checked for duplicate objects on your form using the "Object List" or "Object Inspector" if you have EE? Have you tried recreating the form from scratch? Sometimes that's the only way to clean some obscure hickey.
Claudine :) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Docherty Sent: Sunday, February 10, 2008 12:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB LookupListBox Error Karen Thanks for your reply. I have a version of this form which uses the table, and not a view. The same error occurs. The column in question is a computed column on a computed column,(both using the SRPL function to strip out certain characters - I used two columns in the interests of 'clarity'), but as far as I can see I am not trying to modify it at that stage it is just being used in the lookup. I havent changed anything (as far as I am aware) I have just tried this on some databases I was working on some months ago and the error also occurs with these now (I didnt notice it occurring when I used these previously, mind you....). The other question is, why will RBase not save the eep name, insisting on leaving the On Click action blank. It was there when I first opened these up to investigate the problem, but cannot be saved back again. It all seems a little unusual. Regards, John Docherty From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, 11 February 2008 5:29 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB LookupListBox Error John: I notice you say that this is based on a view, but it's unclear whether the lookup is based on a view, or whether the form itself is based on a view. If the latter, is there any chance you made a change to the view that makes it not-editable? Like putting an "order by" clause on it? Karen 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. The other problem with this box is that it will not save the name of the 'on click' eep. I have tried deleting the box and re-creating it, however the same problems arise. Any suggestions as to what may be causing these problems would be much appreciated. (I am using 7.6.2.30102.) Thank you.
