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

[strato]

this works (almost fine) .dbd file is created in the <database> directory, the .dbf file is created in the <%%home%%> directory

[barrymavin]

Look at this doc.
https://www.lianja.com/doc/index.php/DATADIR()

Lianja apps have a datadir where the databases reside.

Save jt
change it
do what you want to do
restore it

[strato]

it is not a winning solution either, it causes a lot of confusion. If I change the original datadir (to <new_path>, the _VT.dbf table will be created in still the original datadir (C:\lianja\data), but there is no _vt.dbd table anywhere
after creating the (temporary) _VT, and restoring the original datadir, (c:\lianja\data \ the VT cannot be opened
for use (<new_path>\_VT): File '_vt.dbf' does not exist
for use (_VT): [MySQL] [ODBC 8.0 (w) Driver] [mysqld-5.5.5-10.3.31-MariaDB-0 + deb10u1] Table '<remote table>' doesn't exist

[barrymavin]

What is it you want to achieve? Once I can understand that I can better advise.