Hi,
Any option available to force delete the table raw file? I am using below code to delete the XTable and associated raw file -
Problem occurs if any previous code has opened the same table and hasn't called table.Close(). So rawFile.References does not decrement and we get "File is opened." exception.XTable table = engine.Scheme.OpenXTable(new Locator(tableName)); //delete the XTable from the Scheme engine.Scheme.Delete(loc); //commit changes in the Scheme engine.Scheme.Commit(); table.Commit(); table.Close(); table.RawFile.Close(); //delete the RawFile holding the XTable engine.FileSystem.DeleteFile(table.RawFile.Handle);
I understand this is more of coding issue but there could be situation where we need to forcefully remove the table and underlying raw file. Any option available for this situation?