Session table and white space prefix

fabio78
fabio78 Member Posts: 37
edited 2010-09-08 in NAV/Navision Classic Client
Hi.

I have a problem with the Session table of Microsoft Dynamic NAV 2009 SP1 (6.00.29626) in classic mode.

The problem is that there is a white space in the prefix of "User ID" column.

I think that this is a :bug: and i ask to you if there is a rapid solution/patch for resolve the problem.


Thanks.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,135
    [Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

    But why is this a problem?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • BlackNAV
    BlackNAV Member Posts: 4
    I have the same problem.

    Any suggestion or fix ? :cry:

    Thanks.
    Salvo Rapisarda
  • kine
    kine Member Posts: 12,562
    Have you looked into SQL view Sessions if the char is there too? If yes, you can try to modify the view to not include the text...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • eclipses
    eclipses Member Posts: 8
    edited 2010-06-14
    Hi kine,

    I think it's a bug because in the same version on SQL there isn't this problem.
  • BlackNAV
    BlackNAV Member Posts: 4
    up
    Salvo Rapisarda
  • RChurchill
    RChurchill Member Posts: 55
    Hi Guys,

    This too has caused us a problem but if trying to access the Session table using code them simply do the following:-

    Session.SETFILTER("User ID",'%1','?' + USERID);

    Regards

    RPC

Categories