ACCELL/UNIFY nested comb. field question
I have in one table, C_ADDR (addresses for a given customer):
*CA_ckey COMB C_addr_key
CA_Cno C_no NUMERIC 5 C_addr_cust
CA_no NUMERIC 2 C_addr_no
and in another, CA_CTCT (contacts for that address):
*CAC_ckey COMB C_ad_ctct_key
CA_CAck CA_ckey COMB C_ad_ctct_cust
CAC_no NUMERIC 2 C_ad_ctct_no
The forms for entry are called, respectively, c_addr and c_ctct. When
ZOOMing from the first form to the second, I need to specify part of
the second table's key for FIND and ADD operations. I have tried:
BEFORE FORM
SET c_ctct:$C_ad_ctct_cust:CLEAR_FIND_EXP TO c_addr:$C_addr_key
SET c_ctct:$C_ad_ctct_cust:CLEAR_ADD_EXP TO c_addr:$C_addr_key
This doesn't work because the forms do not contain the combination
fields. (That data type is not allowed on forms.) I have tried:
BEFORE FORM
SET CA_CTCT.C_ad_ctct_cust:CLEAR_FIND_EXP TO C_ADDR.C_addr_key
SET CA_CTCT.C_ad_ctct.cust:CLEAR_ADD_EXP TO C_ADDR.C_addr_key
This produces the following errors:
PRE COMPILER ERROR: Current token : "."
( 21) SET CA_CTCT.C_ad_ctct_cust:CLEAR_FIND_EXP TO C_ADDR.C_addr_key
^
ACPL ERROR: The 'TO' keyword was expected.
PRE COMPILER ERROR: Current token : "."
( 21) SET CA_CTCT.C_ad_ctct_cust:CLEAR_FIND_EXP TO C_ADDR.C_addr_key
^
ACPL ERROR: A variable was expected.
PRE COMPILER ERROR: Current token : "."
( 21) SET CA_CTCT.C_ad_ctct_cust:CLEAR_FIND_EXP TO C_ADDR.C_addr_key
^
ACPL ERROR: The Statement was not expected.
PRE COMPILER ERROR: parser skipping to next statement
I have also tried:
BEFORE FORM
SET CA_CTCT:$C_ad_ctct_cust:CLEAR_FIND_EXP TO C_ADDR:$C_addr_key
SET CA_CTCT:$C_ad_ctct_cust:CLEAR_ADD_EXP TO C_ADDR:$C_addr_key
This compiles, but when I try to ZOOM, the program reports that the
form "CA_CTCT" is not active. Of course, CA_CTCT is the table, not the
form.
I have tried some other approaches, but none of them work. Your help
would be greatly appreciated.
(Please email)
--
Ottawa, Ontario, Canada
