What I have is a single table (flat file) that contains client data
about cases that have to have fields updated as progress is made on said
case. There is approximately 12k records, so when searching for a record
to append to or to check the status of, it takes to long to go through
the records using the 'Find Record' function of Base. So what I need is
a way to search the database for individual records and have the records
displayed in my form on a per record search with more speed than 'Find
Record' provides when searching for a single record.
I know what your talking about with the select statement. I can also use
a simple query, SELECT * FROM `ABC` WHERE ( ( `DocNo:` = '000-111' ) ),
that does exactly what I need it to do. I just need to figure out how to
dynamically change the query (or filter) criteria, DocNo, using a text
box and button setup that can be added to my form.
I'm trying to move from Access to OOBase and I need to be able to have
search performance close to that of Access. Right now I'm linked to the
existing Access database (which may be slowing me down) and trying to
come up with a way to move away from a proprietary database. I'm going
to be using Base as the front-end and switching the back-end from
Access to MYSQL once I get the form performing correctly.
Thanks Andrew
Andrew Jensen wrote:
OK, yes I think I can find the URLs, as most are sitting on my ftp
server...I'll put a few here - later this evening.
However, given your last message. You realize that when you set a filter on
a result set you are actually adding a where clause to the select
statement.
After the filter is set and activated then you need to reload the result
set, which simply re-issues the SQL statement.
The reason I bring this up is that if your problem is performance on
searches then your problems may be more with:
A ) The schema ( indexes primarily )
B) The joins used in the query
In either of these cases using a filter, IMO, will not offer you much help.
Then again I could be wrong and often am.
Anyway, with that in mind - I would make this suggestion. If you could
offer
some details on your database structure and perhaps an example query
that is
performing poorly, I might be able to offer some help in a more general
way.
Mean time, when I get some time later today to do so, I'll clean up the one
example I have in mind and put the link to it here.
Till then
Drew
On 6/21/07, Chris Moore <[EMAIL PROTECTED]> wrote:
Andrew,
First of all thank you for your response.
I did search around the forums and only found stuff about what I'm
having problems with, long search times. I'll do some more searching.
Do you have the URL's to the examples from the forum? If you don't have
them handy don't spend any time on it.
I do most of my scripting using Perl. I do very little command line
scripting but with some examples I should be able to figure out how to
adjust the scripts for myself.
Thanks again,
Andrew Jensen wrote:
> Hi Chris,
>
> Well, I can tell you that at the OOoForum.org site there are numerous
> examples of ways to set filters on forms . Using a text box for entry
and a
> button to apply the filter is covered specifically, as is the use of
combo
> and list boxes. A number of these threads include example database and
> script files that you can download and checkout on your machine.
>
> Unfortunately there are some difficulties with the site that might make
> your
> finding these entries rather difficult, but these are being addressed.
>
> In the mean time, there are a number of example files that I can make
> available for you to download. These range from very simple filtering
> techniques to one that is rather advanced.
>
> My question would be which is most appropriate for you - all use
StarBasic
> scripts called from user triggered events on the form.
>
> If you could give me an idea of your comfort level with scripting
already I
> would be able to suggest which of the examples might be most
appropriate.
> Let me know here and I will follow up with the links to the example
files.
>
> Drew
>
> On 6/21/07, Chris Moore <[EMAIL PROTECTED]> wrote:
>>
>> Is there a way to set up a filter that can work with a text box and
>> button? I'm trying to avoid the find record button and want to be able
>> to have a text entry box on a form that will filter the data for the
>> record entered into the text box when the button is pushed. Is this
the
>> right way to go about this or should I be trying to use a query with
the
>> text box and button setup?
>>
>> --
>> Chris Moore
>> [EMAIL PROTECTED]
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
--
Chris Moore
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Chris Moore
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
