Soundex Method for Delphi 1 and 3 + SQL Tstring property in TQuery Object

Soundex Method for Delphi 1 and 3 + SQL Tstring property in TQuery Object

Post by Brad Teng » Sun, 31 Dec 1899 09:00:00



Could somebody direct me to a way to implement
phonetic pattern matching (or "nearly correct" pattern matching for
misspelled words and word fragments.

Somebody suggested using the Soundex method for phonetic
spelling, but upon plugging in suggested code in the SQL editor/Tstrings
property
 for the TQuery Object, and running, a runtime 'capability not implemented'
error
was given.

I am searching several fields against an input variable that holds a string
value like %wordfragment% and then currently uses the LIKE operator in the
SQL editor of TString property of Tquery, which works fine for finding
correctly
spelled word fragments and pulling out those records where the word
fragment
is found.  But I would also like to find words based on phonetic matching,
catching variants of the words, and also match on spelling 2/3rd of target
word
correctly in correct character order.

I have available both the professional (not client server) Delphi 3 and
Delphi 1 packages
(and one target user needs a Delphi 1 version).


 
 
 

1. pgsql/contrib/soundex (soundex.c soundex.sql.in)


Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/contrib/soundex
     from hub.org:/home/projects/pgsql/tmp/cvs-serv51753/contrib/soundex

Modified Files:
        soundex.c soundex.sql.in

-----------------------------  Log Message  -----------------------------

Revise handling of oldstyle/newstyle functions per recent discussions
in pghackers list.  Support for oldstyle internal functions is gone
(no longer needed, since conversion is complete) and pg_language entry
'internal' now implies newstyle call convention.  pg_language entry
'newC' is gone; both old and newstyle dynamically loaded C functions
are now called language 'C'.  A newstyle function must be identified
by an associated info routine.  See src/backend/utils/fmgr/README.

2. Log File - Not wanted

3. Delphi tQuery Object and PDOXUSRS.LCK

4. Visual Basic.net with SQL 2000

5. - changing form object properties with refresh method - beginner's question

6. US-TX-Dallas Sybase DBA Job opening

7. Object doesn't support this property or method

8. SERIAL from Informix ODBC??

9. Object doesn't support this property or method:

10. DB2 v5.2 - Error 438 object doesn't support this property or method

11. Object doesn't support this property or method

12. Error: : Object doesn't support this property or method