Hello,
Is there a possibility of doing a "Google Search" type text search when reading? So who looks for all the words written in the filter and not just a simple "like" with the complet string.
Thank you,
Sam
Google Search Type
Hello,
Is there a possibility of doing a "Google Search" type text search when reading? So who looks for all the words written in the filter and not just a simple "like" with the complet string.
Thank you,
Sam
Hi Sam,
As in - "I have a field with text in it, and I'd like to search for match(es) in the db?"
Is this a CLOB - or a VC200 (or similar)?
Is there any upper/lower/mixed case requirements?
Regards,
Knut
+3Hello,
Is there a possibility of doing a "Google Search" type text search when reading? So who looks for all the words written in the filter and not just a simple "like" with the complet string.
Thank you,
Sam
Hi Sam
Should this search happen interactive?
I.e. the user inputs a text-line with the words to search for and then press a button "search" (or on leave field&Co)
In this case, it is possible to create a u_condition with the wanted words
;°* is GOLD-*
v_COND = ""
v_COND =$concat(v_COND," | TXT_FLD=%%"°*",v_WORD1,"°*%%"")
v_COND =$concat(v_COND," | TXT_FLD=%%"°*",v_WORD2,"°*%%"")
....
v_COND = v_COND[3]
read u_condition(v_COND)
Or you can create a SQL-statement with this information
v_SQL = ""
v_SQL =$concat(v_SQL," OR TXT_FLD LIKE '%",v_WORD1,"%'")
v_SQL =$concat(v_SQL," OR TXT_FLD LIKE '%",v_WORD2,"%'")
v_SQL = v_SQL[5]
sql\\data v_SQL,v_DATA
Ingo
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
