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]
