🚀 go-pugleaf

>Anybody know how to do a query on memo fields and circumvent the
>problem of case of the string being searched?
>
>With DML, you could filter on upper(<memo>). What do we do with OODML?

You might use a canGetRow event handler, e.g.:

q = new query()
q.sql = "select * from A_TABLE"
q.SearchValue = "WHATEVER"
q.rowset.canGetRow = ;
   {|| this.parent.cSearchValue $ upper(this.fields["MEMOFIELD"].value) }
q.active = true
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://www.lonestar.texas.net/~moursund
Try these help resources:
http://forumsearch.borland.com:88
http://www.dejanews.com/home_ps.shtml