Claudine, I have created a new form,X, with two objects, the ListBox (RATES table) and a DBGrid (SCHED table) - when I get a match between the row in the SCHED table (DBGrid) and the RATES table (Listbox), and click on the Listbox the error occurs even though there is no EEP attached. (In fact there are no EEPs anywhere on the form.)
The results look like this:- R>edi usi x where de contains '80 mb' edi usi x where de contains '80 mb' SET VAR RBTI_FORM_COLVALUE TEXT = '80mbpipe' Then the error message appears. This used to work quite well, as the eep would pick up the rates from the RATES table and update the SCHED table with the appropriate data - unfortunately now something has changed. I have checked on numerous versions of the database, some of which are about two years old, so could it be that something has changed with the ListBox control and the use of computed columns ? (I don't think I imagined that this was working, but you never know these days....) Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Monday, 11 February 2008 8:17 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB LookupListBox Error Oh... and trace the form to see where the error is generated... 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.
