Subject | Problem with 4_2_Fr |
---|---|
Author | John Tomaselli |
Post date | 2002-02-08T16:11:08Z |
I came accross on odd problem after I updated to 4_2_Fr from Fn. It took
quite awhile to define the problem so I could communicate with a known
sample.
1) Go to the Contact sample and add a lookup to the qrContact query like
below and change the necessary properties to keep it live.
SELECT ID , LASTNAME , FIRSTNAME , CON_TYPE
, ADDR1 , CITY , USASTATE , USAZIP , USAPHONE
, EMAIL , GENDER , BDAY , BUSNAME , BUSADDR1
, BUSCITY , BUSUSASTATE , BUSUSAZIP
, BUSUSAPHONE , PICTURE , COMMENT , ADDDATE
, CHGDATE
, ct.con_typ_name
FROM CONTACT c
JOIN CONTACT_type ct on
(c.con_type=ct.con_typ_name)
FOR UPDATE
2) add the following to the keyDescLinks on the qrType querry.
(con_typ_name=con_typ_name)
3) Compile project and modify any record on the contact table.
4) Exception appears: FieldName: Contract.con_type not found
5) Note: The records does get modified.
John
quite awhile to define the problem so I could communicate with a known
sample.
1) Go to the Contact sample and add a lookup to the qrContact query like
below and change the necessary properties to keep it live.
SELECT ID , LASTNAME , FIRSTNAME , CON_TYPE
, ADDR1 , CITY , USASTATE , USAZIP , USAPHONE
, EMAIL , GENDER , BDAY , BUSNAME , BUSADDR1
, BUSCITY , BUSUSASTATE , BUSUSAZIP
, BUSUSAPHONE , PICTURE , COMMENT , ADDDATE
, CHGDATE
, ct.con_typ_name
FROM CONTACT c
JOIN CONTACT_type ct on
(c.con_type=ct.con_typ_name)
FOR UPDATE
2) add the following to the keyDescLinks on the qrType querry.
(con_typ_name=con_typ_name)
3) Compile project and modify any record on the contact table.
4) Exception appears: FieldName: Contract.con_type not found
5) Note: The records does get modified.
John