Delete dictionary Table without Data a table (OpenInsight 32-bit)
At 25 AUG 2012 10:07:46PM Chris Meyer wrote:
How do I delete a dictionary table that has no data table.
Cannot see table in Database Manager but can see dict.table in listvolume.
TIA
Chris
At 27 AUG 2012 02:41AM Stefano Cavaglieri wrote:
Chris,
if this is really what you want to do you, you may use the Delete_Table subroutine. Below please find en extract from the OI online help:
Syntax:
Delete_Table(tablename, lockflag, status)
Where:
"tablename" - The table to delete at the specified location. If a tablename is specified it will delete both the table and its dictionary. To delete just a dictionary portion, preface the table name with "DICT. ".
"lockflag" - Set to true, in order to lock the table prior to deletion.
"status" - If true (1) on return, then the table was deleted successfully. Note that while this does indicate success or failure, the Get_Status() is the preferred method for obtaining status information.
Hope it helps,
Stefano