Inventory field

toscaleton
toscaleton Member Posts: 14
edited 2010-11-17 in SQL General
In SQL BD where´s the inventory field of the item table, in other table¿?, and how to use it. This type of fields i watch that the use is diferent at the nav in bd propietary.

Comments

  • DenSter
    DenSter Member Posts: 8,307
    The Inventory field is a flowfield, it's a calculated value. On SQL Server, the actual field is not created because its value is calculated at run time. If you need to have an inventory value inside SQL Server, you'll need to figure out the CalcFormula of the flowfield, so that you can retrieve that value from the same tables.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories