FINDSET in Version 3.60

roshini
roshini Member Posts: 122
edited 2008-12-09 in Navision Attain
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

Comments

  • garak
    garak Member Posts: 3,263
    findset is not available in 3.60.
    U must use find('-') (include with locktable if you make datamanupulations) instead of findset.
    Do you make it right, it works too!
  • kriki
    kriki Member, Moderator Posts: 9,121
    Or even better : upgrade to a hotfixed 4.00SP3!
    There are a lot of advantages for SQL (and also some for native).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • garak
    garak Member Posts: 3,263
    or upgrade to a hotfixed 4.00SP3 if possible
    Do you make it right, it works too!
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    Why not upgrade to hotfixed 5.0SP1? :-k
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • garak
    garak Member Posts: 3,263
    or the 5.x
    The question here is: can he upgrade (Upgrade contract / costs) or can he not ....
    Do you make it right, it works too!
  • kriki
    kriki Member, Moderator Posts: 9,121
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories