Hi Jim, Yes, an EEP; 1 - CHKVAR is to determine whether the variable exists. I assumed, at first, that they all always did but [F3] indicates differently. 2 - I thought not but I was trying to eliminate any possible oddities - a column called "1", for example - that might be stopping the var being processed.
The first three lines work if I split them out but none of the others do in groups of 3 or 4. Regards, Alastair. ----- Original Message ----- From: James Bentley To: RBASE-L Mailing List Sent: Wednesday, May 13, 2009 10:33 PM Subject: [RBASE-L] - Re: Set Var/ChkVar problem 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] ----------------------------- ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.325 / Virus Database: 270.12.27/2111 - Release Date: 05/12/09 18:03:00
