Alistair, I am assuming you are trying to us the following code in a Form EEP. Several Questions: 1) what function is being performed using the CHKVAR function. Don't these variables always exist. 2) do you need the CTXT function for ever variable. Shouldn't some of them already be a text value.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: Alastair Burr <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, May 13, 2009 1:41:47 PM Subject: [RBASE-L] - Set Var/ChkVar problem Can anybody see/explain why this is not working: SET VAR vFormData TEXT = NULL SET VAR vFormData = + ('Form Name:' & (IFEQ( (CHKVAR('RBTI_FORM_FORMNAME')), 1, (CTXT(.RBTI_FORM_FORMNAME)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Form Alias:' & (IFEQ( (CHKVAR('RBTI_FORM_ALIAS')), 1, (CTXT(.RBTI_FORM_ALIAS)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Form Mode:' & (IFEQ( (CHKVAR('RBTI_FORM_MODE')), 1, (CTXT(.RBTI_FORM_MODE)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Component ID:' & (IFEQ( (CHKVAR('RBTI_FORM_COMPID')), 1, (CTXT(.RBTI_FORM_COMPID)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Data Type:' & (IFEQ( (CHKVAR('RBTI_FORM_DATATYPE')), 1, (CTXT(.RBTI_FORM_DATATYPE)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Table Name:' & (IFEQ( (CHKVAR('RBTI_FORM_TBLNAME')), 1, (CTXT(.RBTI_FORM_TBLNAME)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Column Name:' & (IFEQ( (CHKVAR('RBTI_FORM_COLNAME')), 1, (CTXT(.RBTI_FORM_COLNAME)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Column Value:' & (IFEQ( (CHKVAR('RBTI_FORM_COLVALUE')), 1, (CTXT(.RBTI_FORM_COLVALUE)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Variable Name:' & (IFEQ( (CHKVAR('RBTI_FORM_VARNAME')), 1, (CTXT(.RBTI_FORM_VARNAME)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Varaible Value:' & (IFEQ( (CHKVAR('RBTI_FORM_VARVALUE')), 1, (CTXT(.RBTI_FORM_VARVALUE)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Variable Dirty:' & (IFEQ( (CHKVAR('RBTI_FORM_DIRTYVAR')), 1, (CTXT(.RBTI_FORM_DIRTYVAR)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'DB Grid Column Name:' & (IFEQ( (CHKVAR('RBTI_DBGRID_COLUMN')), 1, (CTXT(.RBTI_DBGRID_COLUMN)), ' ')) + (CHAR(013)) + (CHAR(010)) ++ 'Form Dirty:' & (IFEQ( (CHKVAR('RBTI_DIRTY_FLAG')), 1, (CTXT(.RBTI_DIRTY_FLAG)), ' ')) + (CHAR(013)) + (CHAR(010)) ) PAUSE 2 USING .vFormData RETURN I hope that the mail system doesn't wrap it too badly! Individual variables will work but not all together. CompID seems to be the first failure. Thanks in advance for any help, Regards, Alastair ---------------------------- Alastair Burr St. Albans, UK. [email protected] -----------------------------
