FiveTech Software tech support forums

Dear James, this is my code for full text search. Speed is very good. At the moment I only search the dbf-file. Now I thought if I could search fpt-file the same way too and could find out the record number the memoblock belongs would be great. But it seems not possible. Maybe I can store a unique i...

Dear James,
the WildMatch Frank descripts would match my necessity if I can include memofields.
I will do some tests with the code Frank posted.
Best regards,
Otto

Everyone, While all these samples are interesting and very useful, I am not sure we are addressing Otto's problem. Otto, we still need a description of what kind of search you need to do. Do you need to search for a single word in all memo fields, or maybe more than one word (AND, OR). Is there only...

Have you looked at FTS indexes in ADS? The free local ADS version works perfectly with dbf/cdx file pairs. These indexes can be used on AOF's() and are very very fast.


Reinaldo.

Gale, specially have the following scenario in mind: address table: Company, First, Last, Street, Zip, City, Telefon Index 1, ..., n: Company, First + Last, Last, Street, Zip, City, Telefon You need more than one HiPer-SEEK index, if you want to search separately in different fields, perhaps: HS-Ind...

But when you need to search memo fields or all of the fields then it is nice to use Hyper-Seek indexing. Otto, To use Hyper-Seek you can either pass the string you want to add to the index using hs_add(), or you can index the whole file using 1 or more field names using hs_index(). This is from the ...

Otto, take a look at this HiPer-SEEK example: // The example creates a new, populated HiPER-SEEK index for// a customer database.   PROCEDURE Main      LOCAL cIndex, nHandle      CLS      USE Customer ALIAS Cust      cIndex := 'Trim(Cust->LastName) +'      cIndex +=  '" "'      cIndex +...

Hello James,
>Does this include memo fields?
Did you find out if memo fields are included?
Best regards,
Otto

Thanks to all for the help!

James and all other, here ist the syntax of: HS_Index( <cFileName>   , ;           <cExpression> , ;          [<nKeySize>]   , ;          [<nOpenMode>]  , ;          [<nBufferSize>], ;          [<lCaseInsens>], ;          [<nFilterSet>]   ) --> nErrorCode...

Stefan,

In your example what is the var HS, an object, an order number?

Can these indexes be part of a single index file and be kept up automatically just like any other CDX index.

Regards,
James

Hello
with xHarbour you have to use HSX.LIB

Maurizio
www.nipeservice.com

Stefan, HiPer-SEEK is available in free xharbour too. You can search a string over several fields. Does this include memo fields? Even so, I would think an index that indexes each word in a memo field would be much more efficient. This would be like a many-to-many relationship. Each word could be li...

I believe it is only in the commercial version.

I am getting HS_KEY, HS_FILTER as unresolved externals. What is/are the libaray(ies) I need to link to include these functions?

RMDBFCDX is only available in commercial xharbour, but you don´t need it to run the sample. Only if it is linked in, it´s used. You can also comment out these lines:

if ascan( rddList(1), "RMDBFCDX" ) != 0
rddSetDefault( "RMDBFCDX" )
endif