Problems using Time datatype and function

mgifford

I have what seems to be a simple statement that will not compile:

record.fieldname := TIME;

The datatype of the fieldname is Time and the error I am getting is Type conversion is not possible....Time:=Code

I am on the NAV 2009 SQL Server version (SQL 2008) - is it something with the SQL Server version vs the NAV DB and the way it uses datetimes?

klha

Maybe you defined "TIME" as a local variable...

TIME : Code[10];

Under these circumstances Navision will complain:

"Type conversion is not possible because 1 of the operators contains an invalid type. Time := Code"

If this is the problem then just delete the TIME variable.

mgifford

Doh...yes, I had left a field in the table called Time that I forgot about. Ouch.

Thanks for that moment of clarity!