Virtual tables

Magno

Hi, does anyone know all virtual tables in Navision?
i know of:

- Date - File - Integer - Object

Are there any others?

Arhontis

- Drive - Field - Server - Session - Table Information - Code Coverage - :-k

toenne

Hi there, the complete list:

2000000001 Object
2000000002 User
2000000003 Member OF
2000000004 User Role
2000000005 Permission
2000000006 Company
2000000007 Date
2000000009 Session
2000000010 Database File
2000000020 Drive
2000000022 File
2000000024 Monitor
2000000026 Integer
2000000028 Table Information
2000000029 System Object
2000000037 Performance
2000000038 AIIObj
2000000039 Printer
2000000040 License Information
2000000041 Field
2000000042 OLE Control
2000000043 License Permission
2000000044 Permission Range
2000000045 Windows Language
2000000046 Automation Servers
2000000049 Code Coverage
2000000050 Windows Object
2000000051 Navision Attain DB Srv.
2000000052 Windows Group Member
2000000053 Windows Access Control
2000000054 Windows Login
2000000055 SID - Account ID
2000000056 User SID
2000000058 AllObjWithCaption
2000000059 Breakpoints
2000000061 User Menu Level
2000000203 Database Key Groups

try out the contents by designing a form to the tables temporarly by
- open Object Designer
- create new form
- select table from list
- create tabular type form using the wizard
- add all fields
- preview

and you might the answer on your question?!

regards
tönne

Magno

wow,
thanx
i didn't realise it was such a long list.

Tirta

Hi tönne,
did you type/ copy that all individually and manually??? If yes, you are really a kind man

Timo_Lässer

toenne wrote:

[...]
2000000002 User
2000000003 Member OF
2000000004 User Role
2000000005 Permission
2000000006 Company
[...]
2000000053 Windows Access Control
2000000054 Windows Login
[...]
2000000203 Database Key Groups
[...]

These tables are not virtual. They exists really.
You can see them in the object designer an you can analyse them via "File->Database->Information->[Tables]"

RobertMo

To make the list more complete :idea:
Some of this virtual tables depend on release version and DB type (native/SQL). So...

Folowing tables are missing on the previous list, because they are available only when DB is on SQL:

2000000047 Server
2000000048 Database

And vice versa. Following table is only available for native DB (and has been listed):

2000000051 Navision Attain DB Srv.

(beside that in 3.70 the name was "Navision Database Server", in 3.60 and 4.00 is like specified)


Folowing virtual tables are available in specific verisons:

2000000058 AllObjWithCaption (in 3.10+)
2000000059 Breakpoints	(in 3.70+)
2000000061 User Menu Level (in 4.00+)

:-({|=

Asallai

Hi All,

Can I call the name of the server within a function?
I used the "Navision Server" system table, but that doesn't work. :-k
Thank you!

Andras

RobertMo

Asallai wrote:

Can I call the name of the server...

What do you mean?
What do you want to do and how ?

Asallai

RobertMo wrote:

Asallai wrote:

Can I call the name of the server...

What do you mean?
What do you want to do and how ?

For example I'd like to show up into a message tha name of the server.
Every server has a name, and that is what I like to get.

RobertMo

The fastes way would be not to read the tables, but extract it from CONTEXTURL.

afarr

Thanks for this information.

I found Table 2000000061 in a particular Navision 3.70 database, but I couldn't see it in other 3.70 databases (even from the same client). It's good to know that that table only appeared in Nav 4 !

Alastair

David_Singleton

I think that this list:

Virtual table - Dynamics

is fairly complete, but the article does need a clean up.

andy76

Hello,

how do I know the keys of virtual table 2000000022 - File.
Is that possibile order the file by date?
Is it possible to see the structure/design of virtual tables?

Thank you

Magno

i don't think there are other keys. but you can always use trial and error to find out.

use a setcurrentkey, if you get an error, it doesn't work

RobertMo

You can do it faster then writing a code with SETCURRENTKEY.

In Object Designer, Form View:
- start New From
- select your table (or faster - type in "File"). Select tabular. Next
- select all fields, then click Preview
- Try to change Sorting - and you get all available keys.
For File that is "Path,Is a file,Name"