Expression used in a table

[Guest]

I have expressions in a field named LoanCriteria. Within that field I have
expressions such as..([LOANPROGRAM] <> 'CONSTRUCTION') AND ([PROPTYPE] NOT IN
(2010, 2020, 2030, 2040, 2050)).

The field is in a table with the following fields: GroupName, ConditionCode
and CheckList Descriptions and LoanCriteria (see code).

I want to make sure the expression is correct which will say if Construction
is selected then dont show any of the Proptypes. I just added the code to
show what I was doing. Its pretty basic but I took this over from another
developer.




rstLoanChecklist.Open "pplCheckListLoanItems", cn, adOpenDynamic,
adLockOptimistic
'Add Main CheckList Items
strSQL_Checklist = "Select * from pplCheckListItems where
((CheckListActive=True) and (ParentCheckListID Is Null) and
(LoanCriteria<>Null))"
rstChecklist.Open strSQL_Checklist, cn, adOpenDynamic,
adLockOptimistic

 

[Joseph Meehan]

OK I have never tried it, but I don't think you can put an expression in
the table. Tables only store data. They don't do calculations.

Queries do calculations and there you can use expressions.

 

[Guest]

I know sounds strange but as you can see it is in the code and they put the
expression in the table. It has worked like this for over 2 years. I just
wantto make sure my expression are correct?

OK I have never tried it, but I don't think you can put an expression in
the table. Tables only store data. They don't do calculations.

Queries do calculations and there you can use expressions.

--
Joseph Meehan

Dia 's Muire duit

I have expressions in a field named LoanCriteria. Within that field I have
expressions such as..([LOANPROGRAM] <> 'CONSTRUCTION') AND ([PROPTYPE] NOT
IN
(2010, 2020, 2030, 2040, 2050)).

The field is in a table with the following fields: GroupName,
ConditionCode
and CheckList Descriptions and LoanCriteria (see code).

I want to make sure the expression is correct which will say if
Construction
is selected then dont show any of the Proptypes. I just added the code to
show what I was doing. Its pretty basic but I took this over from another
developer.




rstLoanChecklist.Open "pplCheckListLoanItems", cn, adOpenDynamic,
adLockOptimistic
'Add Main CheckList Items
strSQL_Checklist = "Select * from pplCheckListItems where
((CheckListActive=True) and (ParentCheckListID Is Null) and
(LoanCriteria<>Null))"
rstChecklist.Open strSQL_Checklist, cn, adOpenDynamic,
adLockOptimistic