Problems with the "time"

deleyte
deleyte Member Posts: 5
edited 2007-11-23 in NAV/Navision Classic Client
With the NAS (Navision Application Server), I run a report that inserted TIME in a field, but always NULL inserted in the field. Why? How to fix it?

Thanks

Comments

  • sendoh
    sendoh Member Posts: 207
    pls. give us a bit you're code and we'll try out to figure out your problem..
    Sendoh
    be smart before being a clever.
  • deleyte
    deleyte Member Posts: 5
    TRANSFER HEADER

    OnInsert
    .............
    IF ("Hora registro" = 0T) THEN
    "Hora registro" := TIME;
    .............
  • kriki
    kriki Member, Moderator Posts: 9,132
    Are you sure the trigger is fired?
    Maybe you use INSERT(FALSE); or INSERT; and not INSERT(TRUE);?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • deleyte
    deleyte Member Posts: 5
    Not, I'm sure this code is executed, but the record is inserted by NAS.
  • kriki
    kriki Member, Moderator Posts: 9,132
    deleyte wrote:
    Not, I'm sure this code is executed, but the record is inserted by NAS.
    Put a message in the trigger. This will end up in the Windows Eventlog. If you see it, you know it is fired otherwise it is not.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • deleyte
    deleyte Member Posts: 5
    How do I show that message? If I show a "MESSAGE", the NAS will stop.
  • kriki
    kriki Member, Moderator Posts: 9,132
    deleyte wrote:
    How do I show that message? If I show a "MESSAGE", the NAS will stop.
    The NAS does not stop. It just sends the message-text in the Windows eventlog and continues.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories