Oninit cdi / Archive
Talk to an expert →

problem defining VARIABLE

Posted in 2005

Topics: General Discussion

prady — — source: Usenet: comp.databases.informix

hi, 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

↪ replying to prady
Jonathan Leffler — — source: Usenet: comp.databases.informix

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@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Related threads