Virtual table 2000000022 - File - Which keys?

andy76
andy76 Member Posts: 616
edited 2009-12-11 in Navision Attain
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

Comments

  • vijay_g
    vijay_g Member Posts: 884
    use function currentkey and also you can use virtual table(key);
  • andy76
    andy76 Member Posts: 616
    If I write this code:

    gRecFile.SETCURRENTKEY(Date);

    I have this error message:

    The file table does not have an active key that start with the following field(s): Date
  • kapamarou
    kapamarou Member Posts: 1,152
    If I create a new form on this table and run it, then by changing the sorting I only see the primary key.

    I suppose there is no other key...
  • andy76
    andy76 Member Posts: 616
    I made same thing and only see this primary Path,Is a file,Name

    Isn't there a method for which I could order the file by Date?

    Thank you
  • kapamarou
    kapamarou Member Posts: 1,152
    You can create a similar table with any key you like, move that data in that table and sort it there.

    This could also be a temporary table.
  • vijay_g
    vijay_g Member Posts: 884
    kapamarou wrote:
    If I create a new form on this table and run it, then by changing the sorting I only see the primary key.

    I suppose there is no other key...

    hi,

    As far as my knowledge virtual table is use only for exicute we can not change (insert,delete,modify,rename..etc).
    so if we use SETCURRENTKEY, will not work b'coz that key must be placed on this table.
  • kapamarou
    kapamarou Member Posts: 1,152
    vijay_g wrote:
    hi,

    As far as my knowledge virtual table is use only for exicute we can not change (insert,delete,modify,rename..etc).
    so if we use SETCURRENTKEY, will not work b'coz that key must be placed on this table.

    I don't understand what exactly you mean.
    Yes, virtual tables are not editable.

    But you can transfer the data to a "real" table declared as temporary that has a usable key.
  • vijay_g
    vijay_g Member Posts: 884
    edited 2016-08-11
    vijay_g wrote:
    [\quote]
    But you can transfer the data to a "real" table declared as temporary that has a usable key.


    yes right... i think same.

Categories