Field Class "FlowField"

sindrem
sindrem Member Posts: 10
edited 2004-04-21 in Navision Attain
Hey people!
I have moved Navision Attain from Navision database to SQL-Server. Some of mye stored procedures uses fields that have field class "FlowField".

These fields does not appear on SQL-Server.

The table name is "Purchase Header", column "Completely Recieved". Table 38.

Is there any way to get this field? I need to know when the order is completely recieved...

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Flowfields in SQL are stored in separate tables (each flowfield has its own table). You have to look for tables with the name COMPANYNAME$TableNo$FieldNo.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • sindrem
    sindrem Member Posts: 10
    I can only find table 37 and table 39... But I hope 38 is in there some place. I'll take a closer look at it after lunch.

    Thanks for the answer
  • kine
    kine Member Posts: 12,562
    If you don't know hoe to use SIFT, use select statement based on FlowField definition. Look into definition of the FlowField and create own select based on this definition. 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • sindrem
    sindrem Member Posts: 10
    Uhm.. Yeah that is also a solution.. Sounds like a lot of work though.

Categories