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]
