table

subrata.bauri

what are the differences between the Virtual and temporary table in the C/SIDE?

kriki

A virtual table is a table you don't find in the Table-objects.
It contains "virtual" data, like integers, dates,session-information, field-information and so on. In general (but not always), they are read-only.
A temptable can be made on a real table, but also on a virtual table.
You can use it like a real table, but the data you write into it will NEVER be written to the DB. The data remains intact only during the lifetime the variable and it remains in the memory (or in the tempdirectory) of the client computer.
Writing into a temptable will NOT create a transaction.

kine

Virtual: Created by system, does not exist in the database (for example Date table, File table, Integer table etc...) but for Client behave as real table... (but can have some special behaviour - for example can show file names from some disk depending on used filter...)

Temporary: Table created in the client memory with same properties (definition) as some real table in the database. All INSERT,MODIFY and DELETE are done just in client memory and after releasing the record variable the table disappear...

Ufff. just one minute later... :-)

kriki

But you give some extra info.

Marije_Brummel

Yeah, got any spefic situation or do you just want a definiition?

fufikk

What happens if a table as temp variable has for example onInsert trigger which modifies other tables? The changes are also temp or real?

kine

They will be real, and it is why all operations over TMP is good to do without calling triggers... (MODIFY(False), use := and not VALIDATE() etc...)