46,185 questions
Tanks Viorel
Marco Dell'Oca
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have this problem with a select in SYSTEMINDEX.
if in the text to be selected for example is "t.s.c." I'll getting a number of records, if instead I perform a text search in the files contained in the same directory I get a different result.
Practically:
the select :
"SELECT system.itemPathdisplay, System.filename, system.datecreated, System.size FROM SYSTEMINDEX where scope = 'file:D:\XX XXXXXX 2000\FattPA' and contains ('"T.S.C. XXX XXX XXXXXXXX COMPANY"') order by system .datecreated desc "
it returns me 3 records
while the search with InStr, search text "T.S.C. XXX XXX XXXXXXXX COMPANY", in the same directory returns 13 records.
where am i wrong,
Tanks Viorel
Marco Dell'Oca