|
Home > Archive > dBASE Questions and Answers > September 2005 > Search Window
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| John E Sherrer 2005-08-26, 1:24 pm |
| Hi Folks
I am a beginner.
I was looking at the SQL Designer trying to figure out how to build a
Customer search window.
I need to search the Customer database by Customer number & Customer name
with a list Box or grid.
If someone could give me the steps to so this, it would be a great help.
John
| |
| john marshall 2005-08-26, 8:24 pm |
| John:
Find a copy of Ted Blue's book Getting Started. I think it ships with v2.5, otherwise dbi may email you a copy. Check out Chapter 10, Figure 10-1 "Taskbrow form with Range controls". It sounds like that would be a good start and plenty of examples.
JM
John E Sherrer Wrote:
> Hi Folks
> I am a beginner.
> I was looking at the SQL Designer trying to figure out how to build a
> Customer search window.
> I need to search the Customer database by Customer number & Customer name
> with a list Box or grid.
> If someone could give me the steps to so this, it would be a great help.
> John
>
>
>
| |
| Eric Logan 2005-09-07, 1:24 pm |
| John;
Perhaps I can acquaint you with a useful concept. You know that in SQL you
can limit the rows returned via the 'where' clause. This can be your
'search' tool. How do you get the user's choice for displaying rows? You
provide for selection of attributes through user-interface objects such as
comboboxes, checkboxes, etc, on a form. The UI objects can be made to
display only values found in field values of the table being searched. Once
selections are made by the user, your program creates a SQL query. The
entire query is assembled as text with the UI selections incorporated into
the 'where' clause. Finally the query is activated in a query object. This
returns a rowset which can be viewed by the user or processed further by the
program. There are other methods that involve creating the rowset first,
then searching, setting filters, setting ranges, etc.
OK
Eric Logan
"John E Sherrer" wrote...
> I was looking at the SQL Designer trying to figure out how to build a
> Customer search window.
> I need to search the Customer database by Customer number & Customer name
> with a list Box or grid.
|
|
|
|
|