FINDSET in Version 3.60

roshini

Hi Nav Experts!

I want to use FINDSET in Navision version 3.60,

can one help me, how to get the equalent command or command to satisfy the FINDSET command.

Thanking you

garak

findset is not available in 3.60.
U must use find('-') (include with locktable if you make datamanupulations) instead of findset.

kriki

Or even better : upgrade to a hotfixed 4.00SP3!
There are a lot of advantages for SQL (and also some for native).

garak

or upgrade to a hotfixed 4.00SP3 if possible

Alex_Chow

Why not upgrade to hotfixed 5.0SP1? :-k

garak

or the 5.x
The question here is: can he upgrade (Upgrade contract / costs) or can he not ....

kriki

Alex Chow wrote:

Why not upgrade to hotfixed 5.0SP1? :-k

For technical upgrades from <4.0SP3 versions to later, I prefer 4.0SP3 hotfixed. Especially if you need some SQL-tuning. 4.0SP3 is easier to tune because it uses extra tables for the SIFT.
And if you are on SQL2000, you best don't use NAV 5.0SP1 that uses indexed views for the SIFTS : SQL2000 has some problems using indexed views: sometimes SQL2000 decides to recalculate the complete table instead of only what is needed. SQL2005 doesn't have that problem.