Simplicty and flexibility!


Gettinng rid of temp form


Started by George Washington
Search
You will need to Sign In to be able to add or comment on the forum!

Gettinng rid of temp form

Hi there,

I recently noticed that dimension of my application grew a lot, I mean, almost doubled its size. I investigated and in Application -> Status -> Records I found a lot of temp form files. File types are .dbm, .i0x, .tdf and others. They are related to tables called "Temp form xxx" where xxx is a number. There is no trace of those tables in the catalog. From the dos filename I can tell they are in some way related to some really existing table, but I see from the date the file was last modified, that they are no used for months. My guess is that they are some left over of old reorganization / reconstruction of forms that had problems. How can I get rid of them?

Regards.


Written by George Washington 09/01/15 at 08:38:10

Re:Gettinng rid of temp form

When you change a table, the existing table is renamed Temp Form xxx (xxx is a number), and DataEase then create the new table with the correct name. When the table is crated, data is transferred from Temp Form xxx and then Temp Form xxx is deleted.

If the new table cannot be created because of illegal derivations etc, dataease will revert to the Temp Form xxx.

However if DataEase GPF when it try to change a table, the Temp Form xxx is retained with the original data (this is as intended to preserve data).

Temp Form xxx is a misleading name and stem from the time when forms and tables was the same (DFD 4.x and before). In reality it should be Temp Table XXX.

You will find the Temp Form XXX's in the table view of the catalog where you can simply delete them. You will get some error messages, but they should be deleted.


Written by DataEase 09/01/15 at 10:54:29

Re:Re:Gettinng rid of temp form

Yep it worked thanks.


Written by George Washington 09/01/15 at 12:10:38
DG3_ForumList