temporary VT?

[strato]

how is it possible to create a temporary virtual table (so that it is not included in the open database similar to the

create temporary table

command )?

[barrymavin]

Try prefixing the name with an _ which should prevent it being added to the database.

[strato]

the VT definition tables: _ <vt_name> .dbf and _ <vt_name> .dbd (unfortunately) are placed in the /data:/<database>/ folder.
It is true that the Data workspace does not show this VT. This table does not appear in the Data workspace after Database -> Rebuild, but is opened by the use _<vtname> command (not per user).

[barrymavin]

Have you tried creating the VT in the console with no database open.

[strato]

from consol, but with an open database (of course).
I can't find a command like the one in VFP: Set database to.
In addition, only one database can be open at a time, but closing it will also close the tables.
(Create table FREE still exists in VFP, I can't find one either)

[barrymavin]

Push datasession
create …
pop datasession