Search from db problemyp [message #589136] |
Tue, 02 July 2013 10:22 |
|
reallyoldturtle
Messages: 15 Registered: June 2013
|
Junior Member |
|
|
Hi.
There is a table called cd_details. It has fields like id, name, language, type etc.
I need a form where the user can search the database on basis of language and name and then display the other details. I used a data block wizard and given a push_button with (execute_query). But it's very clumsy. For eg, if the user presses next the next button then all the records are being displayed. Is there any way to do this thing in a better way?
Thanks in advance.
|
|
|
Re: Search from db problemyp [message #589137 is a reply to message #589136] |
Tue, 02 July 2013 10:32 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Why have you got a push button? - default toolbar should have execute query.
I don't understand what you mean by this:
Quote:
if the user presses next the next button then all the records are being displayed
[EDITED by LF: fixed [quote] tags]
[Updated on: Tue, 02 July 2013 15:44] by Moderator Report message to a moderator
|
|
|
|
|
|
|
Re: Search from db problemyp [message #589142 is a reply to message #589141] |
Tue, 02 July 2013 10:53 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Go into enter-query mode. Enter the values you want to restrict the query by in the appropriate items. Execute query.
That's it. Forms does all the hard work for you. You don't normally need to write any code for querying.
|
|
|
|
|
Re: Search from db problemyp [message #589150 is a reply to message #589144] |
Tue, 02 July 2013 15:55 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Yes, it does (FRM-40301 - query caused no records to be retrieved. Please re-query) (or something like that; I don't have access to English version at the moment).
As of other issues mentioned in this discussion: by default, I believe Forms is case-insensitive. That's why "english" and "ENgliSH" return the same record set).
<Next> that returns other records: when you execute query for "english", Forms returned all records from that table that satisfy condition you entered. If your form's layout is "form", you see only one record at a time, but <Next> (or <Prev>) enables you to scroll through other records returned by a query. If form layout was "tabular" and you set it to display, say, 10 records, you'd see (up to) 10 records retrieved. You'd still be able to scroll through them (using <Next> / <Prev> or by creating a vertical scrollbar).
|
|
|
|
|
|
|