Hi All,
I found what I am for now calling a "Quirk" in the form object filed color equation expresion builder genie.
While trying to create an expression the genie seems to have a mind of its own. One situation I had was when I built the expresion the genie showed a logical result. I hit ok and then went back into the genie to find that the expresion was no longer valid.
The second thing I saw was the genine was relentless in placing the table name of the field in front of the field name in the expresion. Here are some examples:
date()>=lookup("custprice","pid_no='"+cusprice_Pid.value+"'.and.bid_no='"+Bid_No.value+"'","Exdate")
Changes to:
date()>=lookup("custprice","pid_no='"+cptbl->cusprice_Pid.value+"'.and.bid_no='"+"+cptbl->Bid_No.value+"'","Exdate")
The code below would evaluate fine when building but the the genie makes the .and. operator turn green like it was part of the function.
date()>=lookup("custprice","pid_no='"+cptbl->cusprice_Pid+"'.and.bid_no='"+cptbl->Bid_No+"'","Exdate").and.lookup("custprice","pid_no='"+cptbl->cusprice_Pid+"'.and.bid_no='"+cptbl->Bid_No+"'","Exdate")">{}
What I managed to do to get it to work was create my Case() statement in the code editor and paste it into the equation field in the form properties WITHOUT opening the genie by pressing the x-y button on the smart field.
The equation works as expected which is leading me to a problem with the genie itself.
Is it me? Or is it maybe a "B"??
Scott
I found what I am for now calling a "Quirk" in the form object filed color equation expresion builder genie.
While trying to create an expression the genie seems to have a mind of its own. One situation I had was when I built the expresion the genie showed a logical result. I hit ok and then went back into the genie to find that the expresion was no longer valid.
The second thing I saw was the genine was relentless in placing the table name of the field in front of the field name in the expresion. Here are some examples:
date()>=lookup("custprice","pid_no='"+cusprice_Pid.value+"'.and.bid_no='"+Bid_No.value+"'","Exdate")
Changes to:
date()>=lookup("custprice","pid_no='"+cptbl->cusprice_Pid.value+"'.and.bid_no='"+"+cptbl->Bid_No.value+"'","Exdate")
The code below would evaluate fine when building but the the genie makes the .and. operator turn green like it was part of the function.
date()>=lookup("custprice","pid_no='"+cptbl->cusprice_Pid+"'.and.bid_no='"+cptbl->Bid_No+"'","Exdate").and.lookup("custprice","pid_no='"+cptbl->cusprice_Pid+"'.and.bid_no='"+cptbl->Bid_No+"'","Exdate")">{}
What I managed to do to get it to work was create my Case() statement in the code editor and paste it into the equation field in the form properties WITHOUT opening the genie by pressing the x-y button on the smart field.
The equation works as expected which is leading me to a problem with the genie itself.
Is it me? Or is it maybe a "B"??
Scott
Comment