Problems with the "time"

deleyte

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

sendoh

pls. give us a bit you're code and we'll try out to figure out your problem..

deleyte

TRANSFER HEADER

OnInsert
.............
IF ("Hora registro" = 0T) THEN
"Hora registro" := TIME;
.............

kriki

Are you sure the trigger is fired?
Maybe you use INSERT(FALSE); or INSERT; and not INSERT(TRUE);?

deleyte

Not, I'm sure this code is executed, but the record is inserted by NAS.

kriki

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.

deleyte

How do I show that message? If I show a "MESSAGE", the NAS will stop.

kriki

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.