deleted form but table still there
deleted form but table still there
Hi again
I have had some trouble with forms, so I deleted them but the table did not delete. Can I delete the table?
Thanks
Re:deleted form but table still there
If you have a tricky table like this you need to do the following:
1. Create a new form on top of the table.
2. Go to Document Properties and check "Defines Table".
3. Save the Form.
4. Delete the form and answer yes when it ask if you also want to delete the table.
Re:Re:deleted form but table still there
Thanks for the tip but no luck here.
when I select the table to create new form I get error message "table file VARTAAB.DBA not found -1"
and another table with no form error message " Error 712 Adding Form. Table not found."
any further suggestions
Re:Re:Re:deleted form but table still there
Works in dataease 7.2 so try this:
Create a new DQL:
delete table "Temp form 56". --replace with name of your table
Run this and job done.
Re:deleted form but table still there
Thank You worked a treat.
Re:Re:Re:Re:deleted form but table still there
It is always nice when the community step up where we fail to help.
It is always nice to be reminded that things are not always as they seem in DataEase.
Why would delete table work in DQL when it doesn't work in the Catalog?
We just investigated it and it turns out that the problem in the catalog is that it try to find the corresponding form and when that is missing it just kick off an error message and leave it at that.
The nice thing with DQL is that it is kind of Pre-DFW-Historic so it doesn't really care for documents, only tables and data so it is more than happy to kill a table without kicking up a fuss.
We are re-working the catalog etc towards the end of the DataEase 8 Development (PREI) when we are going to do big changes to the GUI but that is for another day.
Short term solution is to delete one stubborn table like Simon said or simply make a DQL to clear away all of the Temp Forms.
db status records .<br>for $DeStat_RecInfo$ with FileDescription ="data file" and TableName ="Temp Form*" ;<br>delete table TableName .