Hi all,
Let' s start the discussion about extending the search fields!
I have made the following extensions:
1. SQL like is not allowed for others than char fields. So i disable
SEARCH_ALGO_WEAK for other fields.
2. Extend the searching in not char fields with:
!= 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!
Any suggestions?
Should i submit this changes to the CVS?
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
