FiveTech Software tech support forums

... a year earlier) — iOS (Apple Inc.'s iPhone) — 26.0 million units, 16.9 percent share (18.8 percent a year earlier) — BlackBerry (Research in Motion Ltd.) — 7.4 million units, 4.8 percent share (11.5 percent a year earlier) — Symbian (mostly used by Nokia Corp.) — 6.8 million units, 4.4 percent ...

... a year earlier) — iOS (Apple Inc.'s iPhone) — 26.0 million units, 16.9 percent share (18.8 percent a year earlier) — BlackBerry (Research in Motion Ltd.) — 7.4 million units, 4.8 percent share (11.5 percent a year earlier) — Symbian (mostly used by Nokia Corp.) — 6.8 million units, 4.4 percent ...

Tambem tive este problema, resolvi mais não é o correto a fazer. Isto não acontece se usar sistema remoto do ads. Altere no Method SetRDD()       cAdsKeyNo    := "{| n, Self | iif( n == nil, " +;                    ...

Frank,

you are right, there is not other way because the logical operators are for the fields and not for the text search

regards

Marcelo

Marcelo, Rao, yes, if you have more then one search word, but what about a fieldlist and how are these fields combined per default, 'OR' or 'AND' and how to change? Remember, my logic is: 'contains( field1,   "'  + cPattern + '" ) OR ' + ;'contains( field2,   "' + cPattern + '" )...

Examples: Search conditions that use only search words combined with the logical operators AND and OR are fully optimized (assuming an FTS index exists on the field being searched). For example, the following query is fully optimized: SELECT * FROM apdd where contains( definition, ‘science and (hist...

Hi,

I think you can add logical condition inside query CONTAINS( <field>... ' text search [OR|AND|NEAR] textsearch [OR|AND|NEAR] .....' )

regards

and save paul

Rao, you wrote: Please study the syntax in detail. You do not have to 'OR' different 'CONTAINS'. One CONTAINS is enough for many AND and OR conditions. Syntax is similar on almost all RDMSs. Studying syntax from here http://devzone.advantagedatabase.com/dz/webhelp/Advantage10/index.html?master_conta...

it's fast or even faster than the WildMatch Please study the syntax in detail. You do not have to 'OR' different 'CONTAINS'. One CONTAINS is enough for many AND and OR conditions. Syntax is similar on almost all RDMSs. It is faster even on remote server (using client server ADS) because it is serve...

Rao, tested FTS in our customer address table:            ( cAlias )->( AdsCreateFTSIndex( , "name1", "name1" ) )            ( cAlias )->( AdsCreateFTSIndex( , "name2", "name2" ) )            ( cAlias &...

Rao,

thank you very much for clarification.

If we are using ADS, let us not think in terms of wildmatch. Let us approach from Fast Text Search feature. This feature on ADS is similar to Oracle, MSSql and other major RDMSs functionally. If we create appropriate FTS indexes, the results are spectacular even on tables with million rows. Filters ...

Hi, yes, xBrowse + ADS + tricks is fast :) But there is another annoying speed issue regarding ADS and the WildMatch function. Animated by this topic http://forums.fivetechsupport.com/viewtopic.php?f=3&t=15469 and specially Rao's statement: All my earlier programs contained similar code since cl...

Thanks u for sharing u tricks

Jaque