Problem with Ctrl+F

drecksgekritzel
drecksgekritzel Member Posts: 37
edited 2008-02-25 in Navision Attain
Hello,
we have a problem with the search window (CTRL+F).
if we open the window and search with the option "from the beginning of the field" or "only the complete field" the search works fine and we get a lot of results.
But if we search with the option "part of the field" or with placeholders like *med* we don't get any results.

we think it has to be a configuration problem in the sql server because we did a backup of the sql database from our customer and installed it on our sql server. Now it works...
So can you please give me instructions what we have to change at the sql server from our customer that it works there, too?

P.s. the version number is 3.60 and a SQL database.

Thanks

Kind Regards

Alex

Comments

  • kine
    kine Member Posts: 12,562
    1) If you are searching for part of the field, you are not using * as placeholder, else it will search for * as a character. Placeholders are used in filtering, not searching.

    2) There can be difference in the MS SQL Database collation between your and customer server.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • drecksgekritzel
    drecksgekritzel Member Posts: 37
    thanks for your fast reply.
    ok. i tried the search for part of the field with placeholders *. for sure it works but your in right because it makes no sense :wink:
    and it although didn't work...
    can you maybe describe more exactly where can be the difference in the sql server?
  • kine
    kine Member Posts: 12,562
    If you transfered the DB by making NAV backup, you needed to create your own new SQL database before restoring the backup. And when creating the database, you are choosing which Collation (Sorting order and codepage) you want to use for the database. And there can be the difference between your DB and customer's DB. Check, if you are using same collation.

    Another possiblitity is to start SQL Profiler and catch the SQL commands which are sent to SQL when you are searching. Than you can compare the output for you DB and customer DB.

    Another difference can be in the "Search as you type" option, which can be disabled in one case and enabled in another one.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • drecksgekritzel
    drecksgekritzel Member Posts: 37
    Unfortunately i can not test this until the 25th February, because i am not in firm for the next two weeks.
    but when i got any results i will post them!
  • drecksgekritzel
    drecksgekritzel Member Posts: 37
    hello, now I am back in office and I have tested it via vpn in the other firm. it works!
    It seemed to be a local configuration problem...

    Thanks for your help anyhow!

Categories