Cannot search on form

Hi folks,

please help me. I have change a form ?!?! (or maybe i havn’t) and now i could not find any text data with %mysearchtext%.

In every other form concerning the same table all is working fine.

What could I have done wrong?

CU
ROLAND

PS: 2.2c1

How is the property onSearchCmd set on that form (if you are using 2.2.1)? If that is set to none, you can’t search by hitting enter…

I allready checked this option. Its is set to DEFAULT.

May I did not make it clear:

I CAN search
e.g. %mysearch% in field ABC

BUT:
I DO find every record, not the only the records with %mysearch%

THX for your contribution.

Roland

hmm. Never had that. Maybe you can figure out which SQL is sent to the database if you turn the stacktrace on (right click on servoy_developer.bat, follow instructions there and start Servoy using this bat file). With the stack trace you can see every SQL that is sent to the DB…

I have solved this problem. I have noticed that the search problem occurs only at some fields. So I have deleted and replaced them through new fields.

And now it is working!

Very strange…