Flowfield not calculating correctly

ricky76

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?

DenSter

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.

pdj

Maybe you should take a look at this thread:
http://www.mibuso.com/forum/viewtopic.php?t=19387