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.
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Search problem SOLVED!
-
- Posts: 12
- Joined: Wed Apr 13, 2016 2:28 pm
-
- Site Admin
- Posts: 2781
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 1 time
Re: Search problem SOLVED!
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
If your Form's SQL has a WHERE statement, put brackets around it..
eg..
SELECT * FROM customer WHERE (name = 'Bob' OR name = 'Jim')
Steven
-
- Posts: 12
- Joined: Wed Apr 13, 2016 2:28 pm
Re: Search problem SOLVED!
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
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
-
- Posts: 8
- Joined: Tue Jun 28, 2016 12:09 pm
- Location: Rotterdam, The Netherlands
Re: Search problem SOLVED!
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.