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
Any idea, example or help please - Alguna Idea, Ejemplo o Ayuda Por Favor
- Jose Marte2
- Posts: 46
- Joined: Thu Nov 16, 2017 2:19 pm
- Location: República Dominicana
Any idea, example or help please - Alguna Idea, Ejemplo o Ayuda Por Favor
- Attachments
-
- Error, sometimes not always, using index
- IMG_20210409_160223.jpg (2.7 MiB) Viewed 11681 times
-
- Error, sometimes not always, using index
- Untitled.jpg (479.19 KiB) Viewed 11681 times
José Marte
Software & Servicios
Software & Servicios