Substring searching using Base Table methods
From: Chan Wai Yuen <wychan_at_vol.net>
Date: 1996/11/20
Message-ID: <56uukh$g2o_at_manta.vol.net>#1/1
Date: 1996/11/20
Message-ID: <56uukh$g2o_at_manta.vol.net>#1/1
Hello all,
[Quoted] 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.
Thanks for any advice.
Regards,
Chan Wai Yuen
Received on Wed Nov 20 1996 - 00:00:00 CET