Virtual table 2000000022 - File - Which keys?

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

vijay_g

use function currentkey and also you can use virtual table(key);

andy76

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

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

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

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

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

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 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.