Oooops...my error. Forgot to set up the same code in the form I use for editing records. Works like a charm.
Carey On Sat, Jan 5, 2013 at 9:12 PM, Carey Gagnon <[email protected]>wrote: > Ok...got it: > > > def onValueChanged(self, evt): > selectedCity = self.KeyValue > conn = self.Application.getConnectionByName("norcaddb") > bizCities = self.Application.biz.CitiesBizobj(conn) > crsc = bizCities.getTempCursor() > crsc.execute("select * from dbo.Cities where CityID = %s", ('%s' % > selectedCity)) > dsc = crsc.getDataSet() > recc = dsc[0] > cityName = recc["CityName"] > provincestateName = recc["ProvinceState"] > dabo.ui.setAfter(self.Form.tbProvinceState, "Value", provincestateName) > self.Form.getBizobj().setFieldVal("City", cityName) > > This works when I enter a new record but not when the record is edited. > > > Carey > > > On Sat, Jan 5, 2013 at 8:50 PM, Carey Gagnon <[email protected]>wrote: > >> I use the following to update ui data controls when the dropdownlist is >> changed. I figured I could just and what I need to this function, but the >> field I want to set is back and only and doesn't actually have a form data >> control. I'm not sure of the format for setFieldVal but I think this call >> would give me what I want: >> >> def onValueChanged(self, evt): >> selectedCity = self.KeyValue >> conn = self.Application.getConnectionByName("norcaddb") >> bizCities = self.Application.biz.CitiesBizobj(conn) >> crsc = bizCities.getTempCursor() >> crsc.execute("select * from dbo.Cities where CityID = %s", ('%s' % >> selectedCity)) >> dsc = crsc.getDataSet() >> recc = dsc[0] >> cityName = recc["CityName"] >> provincestateName = recc["ProvinceState"] >> dabo.ui.setAfter(self.Form.tbProvinceState, "Value", >> provincestateName) >> self.Form.setFieldVal((*self*, *fld*, *val*, *row=None*, *pk=None*) >> <---------------- How to set this?????? >> >> >> Carey >> >> >> Depends on how the rest of the code is set up. Just know when a selection >> is made the Choice part becomes the dDropdownList.StringValue. This then >> can be used to set the Value for the City field. >> >>> >>> Adrian Klaver >>> [email protected] >>> >> >> > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/camgtpfgifrne6zfbdoamhrtcuay_m3h5qd4axlb74i_atcv...@mail.gmail.com
