Hi Team,
During an App OnShow event I open a table, get a piece of data from it and close it.
Unfortunately, it seems the table isn't released.  It is still flagged as 'In Use' by a routine I use.
{code}
function IsFileInUse(const FileName: string): Boolean;
var
 hf: THandle;
begin
 hf := CreateFile(PChar(FileName), GENERIC_READ or GENERIC_WRITE, 0, nil, OPEN_EXISTING, FILE_ATTRIBUTE_NORMAL, 0);
 if hf <> INVALID_HANDLE_VALUE then
 begin
   CloseHandle(hf);
   Result := False;
 end
 else
 begin
   Result := (GetLastError() = ERROR_SHARING_VIOLATION);
 end;
end;
{code}

This might be normal.
If it is, is there a work around?

Regards & TIA,
Ian

Ian


Is KeepConnections set to True in the sessions component? If so that might be it. All I can think of.

Roy Lambert

Hi Roy,
Thanks for the suggestion.  Turns out you probably meant KeepTablesOpen, which was/is true.
Trouble is there is a possible performance issue if KeepTablesOpen is False.
I don't know what impact there may be in actuality.

Ian