how is it possible to create a temporary virtual table (so that it is not included in the open database similar to thecommand )?Code:create temporary table
how is it possible to create a temporary virtual table (so that it is not included in the open database similar to thecommand )?Code:create temporary table
Try prefixing the name with an _ which should prevent it being added to the database.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
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).
Have you tried creating the VT in the console with no database open.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
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)
Push datasession
create …
pop datasession
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
this works (almost fine) .dbd file is created in the <database> directory, the .dbf file is created in the <%%home%%> directory
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
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
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
What is it you want to achieve? Once I can understand that I can better advise.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
Bookmarks