I think best would be:
- searchalgo = sharp results in where fieldname = value, this
is like the
old
behaviour.
- searchalgo = sharpLT results in where fieldname < inputfield
- searchalgo = sharpLE results in where fieldname <= inputfield
- searchalgo = sharpGT results in where fieldname > inputfield
- searchalgo = sharpGE results in where fieldname >= inputfield
- searchalgo = sharpNE results in where fieldname <> inputfield
- searchalgo = sharpLI results in where fieldname like
inputfield
- searchalgo = extended will parse in inputfield for special
characters. If found
!= value results in where
fieldname <> value
<> value results in where
fieldname <> value
< value results in where
fieldname < value
<= value results in where
fieldname <= value
> value results in where
fieldname > value
>= value results in where
fieldname >= value
value1-value2 results in where
(fieldname >= value1)
and
(fieldname <= value2
value1- results in where
(fieldname >= value1)
-value2 results in where
(fieldname <= value2)
This works for numeric, date, timestamp
fields!
- searchalgo = sharpLTorExtended will use extended if found
special characters, otherwise LT
- searchalgo = sharpLEorExtended will use extended if found
special characters, otherwise LE
- searchalgo = sharpGTorExtended will use extended if found
special characters, otherwise GT
- searchalgo = sharpGEorExtended will use extended if found
special characters, otherwise GE
- searchalgo = sharpNIorExtended will use extended if found
special characters, otherwise NI
- searchalgo = sharpLIorExtended will use extended if found
special characters, otherwise LI
- searchalgo = weak results in where fieldname like
inputfield
- searchalgo = weakStart results in where fieldname like
%inputfield
- searchalgo = weakEnd results in where fieldname like
inputfield%
- searchalgo = weakStartEnd results in where fieldname like
%inputfield%
- support for more than one searchfield would be add in the next
release, if anybody needs it :-).
Got it all? Every suggestions? Must we start an inquiry?
Regards,
Henner Kollmann
-------------------------------------------------------
This sf.net email is sponsored by: viaVerio will pay you up to
$1,000 for every account that you consolidate with us.
http://ad.doubleclick.net/clk;4749864;7604308;v?
http://www.viaverio.com/consolidator/osdn.cfm
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
