Re: Substring searching using Base Table methods

Chan Wai Yuen (wychan_at_vol.net) wrote:

: Hello all,
 

: Is it possible to perform substring searching in a text item
: using base table methods? I've tried to concat the '%' to the text
: item. It's work. However, if records not found, the '%' added to it
: will appear in the next ENTER-QUERY mode. I also try to use the 'where'
: property of the base table block:
: FIELD_NAME LIKE :BLOCK_NAME.ITEM_NAME || '%'
: Records should be found but nothing found.

Move the concatenation to a pre-query trigger:

:BLOCK_NAME.ITEM_NAME := :BLOCK_NAME.ITEM_NAME || '%';
 
: Thanks for any advice.
: Regards,
: Chan Wai Yuen

--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+   Christian Mondrup                                                      +
+   Scandiatransplant, Skejby Hospital, University Hospital of Aarhus      +
+   Brendstrupgaardsvej                                                    +
+   DK 8200 Aarhus N                                                       +
+   Denmark                                                                +
+                                                                          +
+   Phone:   +49 89 49 53 01                                               +
+   Telefax: +45 89 49 60 07                                               +
+   E-Mail:  scancm_at_biobase.dk                                             +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++