I am having problems with multiple ORs and ANDs.

This is the code from Q&A:

#11: IF #77="P" THEN STOP;                                                   

IF #10="UN" THEN {#11=#2+18; STOP};                                    
IF #77="AD" THEN {#11=#78+30; STOP};                                 
IF #73="N" AND #10<>"UN" AND #77<>"AD"THEN {#11=#78+120};               
IF #73="Y" AND #65<>"KEEP" AND #10<>"UN" AND #77<>"AD" THEN {#11=#78+120};   
                                                                             
IF #73="Y" AND #10<>"UN" OR "MI" AND #77<>"AD" AND #5>#78+730 THEN      
#11=#78+365;                                                            
                                                                       
IF #73="Y" AND #5 >#78+180 AND #10="MI" AND #77<>"AD" AND #5>#78+730 THEN #11=#78+182;                                                                  
                                                                                                                                               IF #73="Y" AND #5 >#78+180 AND #10<>"UN" AND #77<>"AD" AND #5<#78+730 THEN #11=#78+182;

IF #73="Y" AND #5<#78+180 AND #10<>"UN" THEN #11=" "; 

This is the code from Sesame:

IF CUS="UN" THEN {REVIEW=BKD+18; STOP};
IF SEG="AD" THEN {REVIEW=CLASS+30; STOP};

IF SENT?="N" AND CUS<>"UN" AND SEG<>"AD" THEN {REVIEW=CLASS+120};

IF SENT?="Y" AND HRS<>"KEEP" AND CUS<>"UN" AND SEG<>"AD"
THEN {REVIEW=CLASS+120};

IF SENT?="Y" AND CUS<>"UN" OR "MI" AND SEG<>"AD" AND EOS>(CLASS+730)

THEN {REVIEW=CLASS+365};

IF SENT?="Y" AND EOS>CLASS+180 AND CUS="MI" AND SEG<>"AD" AND

EOS>CLASS+730 THEN {REVIEW=CLASS+182};

IF SENT?="Y" AND EOS >CLASS+180 AND EOS<CLASS+730 THEN

{REVIEW=CLASS+182};

IF SENT?="Y" AND EOS <CLASS+180 THEN REVIEW=" ";


My problem is that multiple ORs and ANDs do not seem to work in Sesame.  I get an error string for the AND between "AD" AND "EOS" in this line:

IF SENT?="Y" AND CUS<>"UN" OR "MI" AND SEG<>"AD" AND EOS>(CLASS+730) THEN {REVIEW=CLASS+365};

Does Sesame not allow this and if not how can I get around it with different code that does the same thing?  The same question would apply to OR which I am having the same problem with.

The STOP command and the GOTO command may cause errors when used in the GLOBAL CODE section. In ordinary code, STOP should be okay. Check with the "workarounds" page - its the last item on it:

http://www.lantica.com/Support/sesame_workarounds.html

Though I would like to point out that code that uses STOP or GOTO is typically harder to maintain (fix) than code that uses loops or conditionals to achieve the same result.

Status "pending" means that we intend to fix it, but it has not yet been fixed in the upcoming release.

Quote:


The same kind of error in syntax again. It is just not the bracket but also syntax:

Please note:

You have   
If DV = "Yes" or "Y"

It should be
If DV = "Yes" or DV = "Y"

So the final code should be:

IF VIC="" then VIC ="UNK"; 
IF (DV="YES" OR  DV = "Y") AND VIC <> "UNK" AND VIC 
<> "DONE" AND VIC <> "NO" THEN VIC="NEED"


Please let us know if it works.

Quote:


I am not quite sure if I understood what exactly you are doing.  But it seems like you have a few elements in the Form in which you have put restriction that they cannot be blank.  You must have placed "!"  in the restriction.  If that is the case, just remove that symbol from restriction.

It could be that you have placed restriction in an element that its entry can be just Father, Mother, Brother and Sister only and nothing else.   This you do it by placing  

Father; Mother; Brother; Sister;

in the restriction. If you also want it to accept blank entry just enter " =  ". The new restriction entry will look like this:

Father; Mother; Brother; Sister; =  ;

Sesame offers choice of Mandatory Restriction and Optional Restriction. With Optional Restriction one can override and still save the record.

On the top of all these, Sesame also gives you choice of NotifyForm ( ) command in the programming for the purpose of not saving the record without proper entry.  

Please clarify if that is what you are looking for or something else.

I'm having a small problem with programming in subforms.
On the main form the @FormResultSetTotal progamming in the "SubTotal" element works fine but a simple mathematical operator of Amount = Price * Qty0 in "on element exit" of "Price" in the SubForm has given mixed results.
Never seems to work in the first line item and appears to be spasmodic of when it  works at all in the other line items.
Any suggestions of what I'm missing  ???

Thanks Bob, you made me feel a whole lot better 
I was almost too embarrassed to even post that one, have been tearing the form apart and and rebuilding to get this one working to no avail.
Lets face it, this is 1.01 isn't it