I have had a clarion 10 project converted from TPS to sql. Really to see the advantages of sql and how things work. All good so far.
I am looking at ways of extending the functionality of the program. Currently I have a browse window, there are a few filter fields.
If status 《》 All
Brw1.setfilter = (‘fil:status = status’, 20)
If status2 《》 All
Brw1.setfilter = (‘fil:status2 = status2’, 20)
If status3 《》 All
Brw1.setfilter = (‘fil:status3 = status3’, 20)
The above is summarised as I am typing on my mobile.
The question is: I have two fields in the table with long pieces of text in. Let’s call them text 1 and text 2
I would also like to filter records that match a 4th filter, for example filter 4. Filter 4 would be a text entry box,
So If for example I had a record with The cat sat on the mat in text1 and “the dog sat on the mat” in text2
If I entered ‘cat’ into the search field
Text1 true , text2 false, so show record
If I entered ‘the’
Both records would be true so show record
If I entered ‘dog’ text 2 would be true so show record
If I entered ‘horse’ nothing would show
So how should I code this please
A. What would the best syntax be for returning positive filters on partial matches
B. What would the syntax be to search two fields and returning positive filters if either of them are positive.
C. Is it possible to ignore case on searches ?