New Subscriber

[Art Peters]

Thanks Robert

My actual needs are more like:

... WHERE ( ( flda > x1 or flda < x2 ) and ( fldb = y1 or fldb = y2 ) and...  )

All of the fields will be in the same table. The x,y variables are selection
limiters (input into datafields by the user) that are read at run time and
used to create the where statement. 

Since I just bought Valentina, I am really unfamiliar with all of its
aspects. However, scanning the SQL commands I noticed the bound versions of
INSERT INTO and UPDATE that seem promising to cut down the code size.


On Saturday, February 15, 2003 1:48 PM, Robert Brenstein <rjb at rz.uni-potsdam.de> wrote:
>>on 2/14/03 8:09 PM, Art Peters at akpce at atlantic.net wrote:
>>
>>Hi Art,
>>
>>>  REAL Software suggested the Valentina DB because
>>>  theirs will not do what I need.
>>>
>>>  In an SQLSelect command, I need to have
>>>  a series of WHERE search conditions. For example,
>>>
>>>  ... WHERE ( (a OR b) AND (c OR d OR e OR f) AND ... )
>>
>>>  Can this be done? If so, is there a limit?
>>
>>Yes,
>>
>>No special limit
>>
>
>Well, I would qualify that. In principle and general yes, but it will 
>not work under all conditions (for example, or's between fields in 2 
>different tables).
>
>Robert
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>