I'm trying to make my first database with Brilliant Database and I have no problems for now with creating a forms, print reports etc. But, here is something I need to do but really don't know how.
It's about the searching the records according to several criteria. All criteria are related to several columns in my table which are numeric fields. Roughly simplified this task can be described for two columns only:
- user needs to select a fixed value for searching a col1 and
- some kind of range for searching a col2, ie. fixed value and +/- tolerance.
For example. User need to find and display all the records where is:
- col1 =8 and
- col2= 125 with tolerance +/- 7 % ( that means between the 116,25 and 133,75)
Note that particular criteria should be skipped if user choose nothing.
I really hope , someone more familiar with BD will show me how this code looks like and where to put it.
I will add a "search" button to toolstrip for peforming this action.
Sorry because of my bad English and thanks in advance.
Thanks for your reply.
I tried to run first or second query and I got a message: "No records were found." I saw your code in Database Scripts but I don't know how it is related to queries.
Seems to me, I'm missing someting.
Recently I was creating a similar database with data-searching, but in another language ( VB. net). See the screenshot. I'm wondering is it possible to create something similar in BDB, ie. a new form for entering a search parameters?
If yes, how to do it?