Re: Evaluate complex conditions

[booth@xxxxxxxxxxxx]

I have 4 problems with an SQL solution. 

1-I don't know SQL well enough to  write the strings on the fly. 
2-Users I know can't fill in a command line string suitably for an SQL 
solution, 
3-the few instances of SQL selections I've seen have performance pigs in 
that SQL would suck in the sides of the machine in an interactive job, and 
even with that still respond slowly.
4-giving users full flexibility with and/or selections just doesn't work 
well.  Their intentions are good but the example given yesterday is a 
wonderful example of the problem.  ( "give me all registered voters in New 
Hampshire and Vermont" will list just a few energized citizens that like 
to vote early and vote often.)

imho
_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




Marco Facchinetti <facchinetti@yahoo.com>
Sent by: owner-midrange-l@midrange.com
10/24/2000 03:34 AM
Please respond to MIDRANGE-L

 
        To:     MIDRANGE-L@midrange.com
        cc: 
        Subject:        Re: Evaluate complex conditions

SQL?
--- booth@martinvt.com wrote:
> Terry, the only method I've been able to create and then
> understand again 
> a week later, is to make a series of subroutines.  Each
> subroutine will 
> have a test for a condition and will flip a flag if the
> condition is not 
> met.  Something like this:
> 
>  C    Eval      DoItFlag = 'Yes'
>  C    Exsr    Test1
>  C    If         DoItFlag = 'Yes' And Test1Flag = 'Yes'
>  C    EXSR   Test1SR
>  C    End
>  C    If         DoItFlag = 'Yes' And Test2Flag ='Yes'
>  C    EXSR   Test2SR
>  C    End
>  C    If         DoItFlag = 'Yes' And Test3Flag = 'Yes'
>  C    EXSR   Test3SR
>  C    End
>   C    If         DoItFlag = 'Yes'
>  C    EXSR   OKToDoSR
>  C    End 
> 
> 
> _______________________
> Booth Martin
> Booth@MartinVT.com
> http://www.MartinVT.com
> _______________________
> 
> 
> 
> 
> Terry Grider <tgrider@arkansas.net>
> Sent by: owner-midrange-l@midrange.com
> 10/23/2000 12:43 PM
> Please respond to MIDRANGE-L
> 
> 
>         To:     MIDRANGE-L@midrange.com
>         cc: 
>         Subject:        Re: Evaluate complex conditions
> 
> Sorry guys,  I didn't do a very good job of explaining
> what I was looking 
> for.
> I don't mean I want code that is an example of testing
> for complex 
> conditions, I
> mean I'm looking for code that will evaluate statements
> like the one in my
> original example and determine the truth of the
> statement.  You see, I'm 
> writing
> a query tool and I want the user to be able to provide
> selection criteria 
> in an
> english style IF format similar to cobol or other query
> tools I've seen. I 
> can
> currently handle simple criteria with "and/or"
> connectors, but I can't 
> seem to
> come up with a good method for handling multiple levels
> of parenthesis.
> 
> Terry Grider wrote:
> 
> > Has anyone ever written or seen an example of program
> code designed to
> > evaluate complex conditions?  For example, if you
> wanted to evaluate a =
> > b and (c = d or c = e or c = f).  I'm looking for
> something that can do
> > multiple levels of parenthesis and all "and/or"
> combinations.
> >
> > --
> > Terry Grider
> > tgrider@arkansas.net
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list
> owner/operator: 
> david@midrange.com
> > +---
> 
> --
> Terry Grider
> tgrider@arkansas.net
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator: 
> david@midrange.com
> +---

> 
> 
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator: david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---