SQL Sift Tables

jordi

Hi all,

I am from a NSC in Malaysia. As you have known, Navision is quite new here. So our exposure to SQL here is quite limitted. We need all the help we can. <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />

I understand that SQL does not handle SIFT tables very well. Below are the drawbacks I have received regarding Navision on a SQL Server.

1. SIFT tables are only updated via the restore operation in the Navision program. How does this affect development in Navision in areas using flowfields and areas not using flowfields?

2. If it is true that SIFT are only updated via the restore operation in Navision program, are there any other ways to update the SIFT table, eg. a general stored procedure?

3. It is STRONGLY not recommended for a Navision SQL Server to have more than 1 company in its database. How true is this?

A million thankx.

Jordi
Technical Specialist

John_Tegelaar

Jordi,

I'm afraid I don't understand your questions in full.

The SIFT (Sum Index Flow Technology) tables are separated from the main tables under SQL, but still an integrated part of the database. Updating the values in these tables is done automagically in the background, yet the results are immediately available for display by any flowfield, just like running native Navision.

When you define a flowfield, Navision will create the SIFT table(s) as required. Importing a FOB (compiled (Navision) Financials OBjects) is sufficient to get everything in place, no need for a full restore of the database.

Having more than one company is no problem at all under SQL. We have customers running over ten companies, with a complicated mix of shared and not-shared tables.

John