Problems using Time datatype and function

mgifford
mgifford Member Posts: 44
edited 2009-05-22 in NAV/Navision Classic Client
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?

Comments

  • klha
    klha Member Posts: 5
    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
    mgifford Member Posts: 44
    Doh...yes, I had left a field in the table called Time that I forgot about. Ouch.

    Thanks for that moment of clarity!

Categories