bb.donnay-software.com

Greetings, I hope you are all well as well as your families

Please if you can I need some idea, example or help with the following case

I have a query from a database
Of customers

and I want to search for any field in question

that is to say when writing a word or a number, that it looks for, by the code field, name field, telephone field, etc.

I currently do it by creating an index, but at the moment it gets slow, slow, slow and gives the following error that I am going to attach

I found the LIKE statement

but I don't know why it always returns .f. or NIL
and I can't perform the operation

Any suggestions, what am I doing wrong?

I also attach the screen of the query, and at the end of the screenshot, which returns LIKE

Thanks in advance

I'm still in text mode, which was Clipper, but I compile with xbase