Re: problem defining VARIABLE

prady wrote: 
     i am pradeep,i am having problem defining variables,i get an
errorwhen i "make"

i have added emaila,emailb,emailc into salecont_ip


DATABASE maindb

GLOBALS

        DEFINE pr_salecont_ip RECORD LIKE salecont_ip.*,

               pr_salesper RECORD LIKE salesper.*,
               pr_saleprod RECORD LIKE saleprod_ip.*,
               pt_saleprodip RECORD LIKE saleprod_ip.*,
               pr_salearea RECORD LIKE salearea.*,
           pr_salreason RECORD LIKE salreason.*,
               pr_sal_ar_name RECORD LIKE sal_ar_name.*,





when i "MAKE" ....I HAVE ERROR



        pr_salecont_ip.sc_emaila,
| fglcomp: The symbol "pr_salecont_ip.sc_emaila" does not represent a
defined va
riable.
| See error number -4369.
        pr_salecont_ip.sc_faxno2,
        pr_salecont_ip.sc_emailb,
| fglcomp: The symbol "pr_salecont_ip.sc_emailb" does not represent a
defined va
riable.
| See error number -4369.
        pr_salecont_ip.sc_faxno3,
        pr_salecont_ip.sc_emailc,
| fglcomp: The symbol "pr_salecont_ip.sc_emailc" does not represent a
defined va
riable.
| See error number -4369.
        pr_salecont_ip.sc_mobile1,


these variables r defined in the tables 


You said you added emaila, emailb, emailc;
your code refers to sc_emaila, sc_emailb, sc_emailc.

One of those two statements is wrong - and the discrepancy is likely the source of the trouble.

RENAME COLUMN salecont_ip.emaila TO sc_emaila;
....



--
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler@xxxxxxxxxxxxx, jleffler@xxxxxxxxxx
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
.