ACCELL/UNIFY nested comb. field question 
Author Message
 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



Sun, 08 Sep 1996 09:56:14 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Unify DBLOAD on record with COMB key field

2. Unify/Accell C-Hooks for Text fields

3. Accell/Unify question

4. UNIFY 5.0/ACCELL IDS ENTER screen question

5. Sybase/Unify Accell Programming Opportunities-University of Pittsburgh Medical Center

6. Unify Accell/Vision Newsgroup?

7. Accell / Unify users?

8. Unify/Accell Lock Manager Init Failure!

9. UNIFY/ACCELL Mailing List

10. Comments on UNIFY/Accell

11. Comments on Unify/Accell

12. Looking for comments on Unify's Accell 4GL and other tools


 
Powered by phpBB® Forum Software