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]
