windows search selecting SYSTEMINDEX in vb.net

Marco Dell'Oca 201 Reputation points
2023-02-19T16:46:33.1766667+00:00
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,
Community Center Not monitored
{count} votes

1 answer

Sort by: Most helpful
  1. Marco Dell'Oca 201 Reputation points
    2023-03-17T15:45:50.9833333+00:00

    Tanks Viorel

    Marco Dell'Oca

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.