Subject | RE: [IBO] Searching with ib_searchpanel |
---|---|
Author | Kaputnik |
Post date | 2002-02-25T22:14:40Z |
The IBO-Search-Mode does ADD to, not replace the where-clause of the query.
If you have a parameter, it stays in place.
In one of my applications, where I was in need to isolate one record via a
hyperlink-jump, I did not use a parameter, but manually assigned
search-criteria to the query.
This is not too hard, and you can search this list's archive under
http://groups.yahoo.com for the keywords "Search Kaputnik" on the second
page you'll find a nice thread which explains, how to use the direct
search-criteria.
CU,
Nick Josipovic
BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618
nick.josipovic@...
If you have a parameter, it stays in place.
In one of my applications, where I was in need to isolate one record via a
hyperlink-jump, I did not use a parameter, but manually assigned
search-criteria to the query.
This is not too hard, and you can search this list's archive under
http://groups.yahoo.com for the keywords "Search Kaputnik" on the second
page you'll find a nice thread which explains, how to use the direct
search-criteria.
CU,
Nick Josipovic
BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618
nick.josipovic@...
> -----Original Message-----
> From: stanw1950 [mailto:stanw@...]
> Sent: Monday, February 25, 2002 10:48 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Searching with ib_searchpanel
>
>
> I'm using an ib_searchpanel and an ib_searchbar, along with edit
> components and a grid. They are linked to an ib_query. When the user
> enters the screen from another screen, I want the current record that
> they just came from (for example a part number) to be the current
> record. Thus the screen would just show the data for the current part
> number. I also need the user to be able to enter search criteria in
> the ib_searchpanel to show more parts that, for example, start
> with 'bac'. If I construct the query in the ib_query component to
> have a parameter, that parameter always seems to be in control - I
> can't get the ib_searchpanel's search criteria to work for parts not
> meeting the parameter. The query (without the parameter) is 'select *
> from parttable', but I want to restrict that, still allowing the
> searching to override the restriction. How can I do it? Thanks in
> advance. (Delphi 6, ibo 4.2.fr)
>
> Stan Walker
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>