Where is Flow Field??

asieraies

Hi,

I 've got a table with an FlowField. If I see this table in SqlServer, this field doen't appear!! Where's it? I need to use it because i run some t-sql sentences against this table.

Any suggestions??

Thanks

Asier

kriki

It doesn't exist in SQL.
The field is calculated on the fly.
There are extra tables in SQL. They have the tableID in them and another number that is for the index. So you would have to do a slect on that table. But if it isn't too heavy a query, I would do it directly on the field in the original table. Because if you change something in Navision, it is possible that your TSQL-statement doesn't work anymore. And with 5.00SP1 those tables don't exist anymore but are replaced with indexed views.