Newbie Power Objects Problem

From: <ksilverstein_at_crs.stjude.org>
Date: 1995/10/06
Message-ID: <1995Oct6.114915.1_at_crs>#1/1

I'm a newbie OPO user and am having a problem. In an ORACLE database I have a person-event table with fields: client number,

                                person_id number,
                                event_date date
     primary key (client, person_id) 

and
person-test table with fields: client number,

                                person_id number,
                                test  varchar2,
                                test_date date, 
                                test_result number

    primary key (client, person_id, test, test_date)     foreign key (client, person_id) references person-event table

I want to create a master-detail form with person-event the master   and person-test the detail showing all the test results   of a particular test for the person shown in the master that were done   after the event_date displayed in the master.

I created a form and bound the fields in person-event to it

   defined the DefaultCondition property to select the persons of interest   create a repeater and bound the person-test table field to it.

Am I correct that I can only designate one field each in the LinkMasterColumn property and the LinkDetailColumn and must capture the constraints defined by the other field in the foreign key some other way.

I've tried to use the DefaultCondition on the repeater to do this if I define the DefaultCondition property as

   test='TEST_NAME' and client=0 and test_date > '01-AUG-95'

      everything works fine
 but I get error "ORA-00904: invalid column name" if I use:    test='TEST_NAME'

     and client=frmPersonEventTest.CLIENT.Value 
           and  test_date >=frmPersonEventTest.event_date.Value

 if I use methods:
   test='TEST_NAME'
    and client=frmPersonEventTest.GetRecordSet.GetColVal("CLIENT")       and test_date >= frmPersonEventTest.GetRecordSet.GetColVal("EVENT_DATE")   I get errors "SQL-00149: An open parenthesis is not allowed in this context",

           and "BAS-01100: ERROR executing method inherited from system" (I have to hit the OK button 3 times to get out

Obviously I'm not approaching this correctly. How do I get this to work?

TIA Received on Fri Oct 06 1995 - 00:00:00 CET