Flowfields and SQL

Iwan_Jauch
Iwan_Jauch Member Posts: 35
edited 2006-04-28 in NAV/Navision Classic Client
Hi there

I am using an ODBC SQL driver to read data out from the navision sql database, but I can't find the flowfields of customer in the customer table.

Where are flowfields stored in the navision sql?

Thanks a lot for your help.

Best regards
Iwan

Comments

  • Mog
    Mog Member Posts: 34
    afaik nowhere, flowfields are calculated at runtime...
  • Iwan_Jauch
    Iwan_Jauch Member Posts: 35
    Hi Mog

    So I need to create the same "flowfield" in my application, excel as an example?

    When I try to read the Navision Field "Balance" than I need to rebuilt the CalcFormula ?

    Sum("Detailed Cust. Ledg. Entry".Amount WHERE (Customer No.=FIELD(No.),Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),Currency Code=FIELD(Currency Filter)))

    Thanks for your help

    Best regards
    Iwan
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Have a look at this thread: qty on hand using sift tables from sql

    Flowfields are stored in separate tables on a SQL database.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Iwan_Jauch
    Iwan_Jauch Member Posts: 35
    Hi Luc

    Thanks for your help.

    I am a little bit disappointed about possiblities to read out the values. So when want to reuse a excel application I can't use it anymore.

    So I need to built a SQL Query for every flowfield I want to read out correct?

    Thanks a lot for your help.

    Best regards
    Iwan
  • kine
    kine Member Posts: 12,562
    Yes, you can use nested selects for example for that...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories