Shamdasani Nimmi graciously provided me with
a solution. Thanks!!!
-----Original Message-----
From: Shamdasani Nimmi-ANS004
Sent: Friday, January 28, 2000 1:35 PM
To: 'Pauline Chui'
Subject: RE: [ND] Combo Box is not filled with proper data objects
Pauline,
You are getting the cached data. Add code to
yourComboBox_onBeforeDisplayEvent like this:
{
//get a handle to the data object to which the combobox is
attached
CSpSelect theDO = (CSpSelect)
CSpider.getDataObject("comboboxDO");
//clear any dynamic criteria on the data object
theDO.clearDynamicCriteria();
//Add any dynamic criteria, if you have any, here.
//Get a handle to the combobox
CSpComboBox theBox = (CSpComboBox) event.getSource();
theBox.removeAllChildren(true);
theBox.doAutoFill();
return (PROCEED);
}
Hope this helps.
-Nimmi
"Bryant Brabson" <[EMAIL PROTECTED]> wrote:
>
>Here is an example of the sql executed:
>
>62 Jan 28, 2000 at 11:16:54.268 Terse Debug 430 DSRdbmsService
>DSRdbmsService:c:949070331652:w:949070337423:execute
SQL command: |SELECT ALL dbo.PD_DETAIL_VIEW.PRACNO, dbo.PD_DETAIL_VIEW.PRACID,
dbo.PD_DETAIL_VIEW.LNAME,
dbo.PD_DETAIL_VIEW.FNAME, dbo.PD_DETAIL_VIEW.ADDR1, dbo.PD_DETAIL_VIEW.ADDR2,
dbo.PD_DETAIL_VIEW.CITY,
dbo.PD_DETAIL_VIEW.STATE, dbo.PD_DETAIL_VIEW.ZIP FROM dbo.PD_DETAIL_VIEW WHERE
(dbo.PD_DETAIL_VIEW.PRACNO
= 'MSIS 43') ORDER BY dbo.PD_DETAIL_VIEW.LNAME ASC, dbo.PD_DETAIL_VIEW.FNAME
> ASC|
>
>This
>(dbo.PD_DETAIL_VIEW.PRACNO = 'MSIS 43')
>is what is really screwing me up.
>
>One other concern I have is whether I am selecting the value correctly. In the combo
>box's onBeforeDisplayEvent I have setValue
>and select() with the same screwy results.
>Am I supposed to explicitly refresh or clear
>the combo box???
>
>
>
>"Bryant Brabson" <[EMAIL PROTECTED]> wrote:
>>
>>I have a series of 3 pages that update a
>>patient's information. Specifically, they
>>update a patient's physician's info, such as
>>name, address, street, etc. To get to the
>>screen where the physician info is changed,
>>the user searches for a patient on the first
>>page, then selects the desired patient via
>>href on the second page.
>>
>>Everything is fine until the 3rd page where
>>the info is changed. On this page, the
>>patient info is displayed perfectly in text
>>fields. The current physician is to be
>>displayed in a combo box, and this can be
>>updated by selected a new value in the combo
>>box.
>>
>>The combo box is bound to a dataobject that
>>is a SQL Server 6.5 table that holds physician
>>demographic information. The dataobject is
>>set up correctly and I can see no problem
>>with it. The datasource works properly as well.
>>
>>My problem is that previous selections seem
>>to be cached in the PE and used as the
>>criteria for populating the combo box and NO
>>criteria is to be used. This is the info
>>from the log that show me this:
>>
>>37 Jan 28, 2000 at 10:41:55.190 Verbose Debug Thread-10 CPService
> spider.session.CSpSession:c:949070337797:w:949070467027:getValuesFromPE:
values=|[K(^doPhyView.JOIN.ImplantSystem, ^doIPQryPhy.QBE.ImplantProj, ^userProfile,
^doQryLogon.JOIN.ImplantProj, ^doIPQryPatientHist.QBE.ImplantSystem,
^doIPAllPatientHistory.DRILL_DOWN.ImplantSystem),
E((dbo.PD_DETAIL_VIEW.PRACNO = 'MSIS 43'), (dbo.PD_DETAIL_VIEW.SP_DESC LIKE
'Cardiothoracic
Surgery%'),
>>
>>where
>>E((dbo.PD_DETAIL_VIEW.PRACNO = 'MSIS 43'
>>is what is causing me so much grief.
>>
>>I have tried everything from allowing studio
>>to do all of the work to programmatically
>>populating and executing the dataobject
>>that fills the combo box.
>>
>>ANY suggestions would be appreciated!!!
>>
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
