Search problem SOLVED!

[kokarman]

Quite so!L ike in many other occasions formulating the problem is the solution.

Hi,

When I search for specific content in records of a browse form the search string is coloured red in all records with that string but the records are not filtered.
It seems to me that that the search command normally in the background adds a 'where' clause to the form query but that in this case the query is corrupted.
It is just in one form, all other forms are searchable as expected.
Has someone experienced the same?
Thanks for any hint.

[admin]

kokarman,

If your Form's SQL has a WHERE statement, put brackets around it..

eg..

SELECT * FROM customer WHERE (name = 'Bob' OR name = 'Jim')

Steven

[kokarman]

Hi Steven,

By cutting the WHERE clause everything was fine again.
So I was experimenting with the code and I was very close...
This saves me time.
Thanks a lot!

Ko

[admin]

.

[SteveHolland]

Good work and program looks promising. What stage are you in now? Today I run a working demo of NuBuilder, adapted for a car-fleet company in Rotterdam. It might be interesting to exchange cards with you... Kind regards, Steven Hoogslag.

[admin]

.