Flowfield not calculating correctly

ricky76
ricky76 Member Posts: 204
edited 2007-08-09 in NAV/Navision Classic Client
I have a flowfield that was not correctly calculating. I have got it to work by turning off the maintain SQL index option on the key and switching it back on. I was wondering what the SQL script was to rebuild the SIFT indexes to save having to do this if this happened again?

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Exactly what you did. Save the table in its current state (export to fob), turn off all SIFT, and import the table back in. This first destroys all SIFT tables, and then recreates them.

    There is no script that you can run (at least not officially, and certainly not supported) to recreate SIFT. This is all done internally by the NAV executable.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pdj
    pdj Member Posts: 643
    Maybe you should take a look at this thread:
    http://www.mibuso.com/forum/viewtopic.php?t=19387
    Regards
    Peter

Categories