Graham
Wed Apr 09 12:43:11 CDT 2008
Here is a sample of the filter swdev2
To use the below example of some guy named jeff singing something with
eyes in it on a disc numbered 8001, the filter would be as follows
"
Set Filter to "JEFF" $ NAMEPATH AND "EYES" $ NAMEPATH AND "8001" $
NAMEPATH
"
I don't know how I can make an optimized index file on the above
without including each word as a seperate index expression which could
conceivably give me an index expression containing 300,000 or more
pointers.
Stefan do you have any suggestions on a backend that supports the
"fulltext" indexing. I went looking for the phdbase and it appears to
no longer be available.
Also I am not sure on the parameterized views. Guess I have to do
some reading on these.
Anders, I think I am a little confused about using a cursor as I think
the nature of the beast would be to download the whole cursor the
first time that they entered the search string. What I am trying to
accomplish is to populate the grid with the most minimum info to try
to help the user narrow their search. I'm also a little rusty on
using cursors.
Thank you everyone.
On Apr 8, 7:04=A0pm, "Anders Altberg" <anders.altberg> wrote:
> CREATE CURSOR Words (searchfor Char(20)
> FOR i =3D 1 TO GetWordCount(M.loopvar,' ,')
> =A0INSERT INTO Words VALUES (GETWORDNUM(M.loopvar, i))
> NEXT
> SELECT Karaoke.* FROM Karaoke JOIN Words ;
> ON Karaoke.namepath LIKE '%'+TRIM(Words.searchfor)+'%';
> INTO CURSOR xx
>
> Your are of course running the risk that they download 65000 rows. You can=
> guard against that.
> One way would be using a pre-count
> SELECT COUNT(*) FROM =A0Karaoke JOIN Words ;
> ON Karaoke.namepath LIKE '%'+TRIM(Words.searchfor)+'%';
> INTO ARRAY xx.
> If there are more than 250 rows, tell the user to please be more specific.=
>
> -Anders
>
> "Graham" <grahamskara...@gmail.com> wrote in message
>
> news:12579e7c-18ed-4105-801a-6dd516f1db83@k37g2000hsf.googlegroups.com...
>
>
>
> >I have a large local database (about 65,000 records) and need to be
> > able to populate a grid with continually updated information. =A0The
> > search is performed so that partial names, and other info can be
> > entered in any order. =A0As soon as the record appears enter will end
> > the interactivesearch. =A0So in the interactivechange event of a text
> > field on the form I have placed the following code. =A0In the setup form=
> > I give the the user the option of turning off the incremental search
> > (interactivechange event).
>
> > "
> > IF butintch=3D.t.
> > loopvar=3Dgetwordcount(this.value)
> > filtervalue=3D''
> > FOR counter =3D 1 TO loopvar
> > filtervalue=3Dfiltervalue+'"'+ GETWORDNUM(this.Value,counter)+ '"'+" $
> > namepath and "
> > ENDFOR
> > filtervalue=3DUPPER(LEFT(filtervalue,LEN(ALLTRIM(filtervalue))-4))
> > SELECT karaoke
> > SET FILTER TO &filtervalue
> > GO top
> > thisform.grid1.refresh
> > endif
>
> > "
>
> > On a small database this works great but when used with a 65,000
> > record table the filter slows the program considerably. =A0Is there any
> > way to perform a search such as this without using a filter to narrow
> > the results down. =A0I realize that the continual calling of the set
> > filter to is causing the bottleneck but cannot see anyother way to
> > perform this kind of search. =A0The field it is searching on is 150
> > characters. and includes the filename and path.
>
> > It is for a karaoke song look up. =A0The file structure is such that
> > directories could appear as below.
> > c:\karaoke\full discs\ah8001
> > and an example filename would be
> > ah8001-01 - Healey, Jeff - Angel Eyes.zip
>
> > The use might only remember that some guy named Jeff sung a song about
> > eyes and the disc number was 8001
>
> > So with the above search box I could type in
> > "
> > jef eye 8001
> > "
> > and the program would narrow it down to this file.
>
> > Any help would be appreciated. =A0Thank you in advance.- Hide quoted tex=
t -
>
> - Show quoted text -