Re: [Firebird-devel] FW On/OFF

[Ded <de...@hq...>]

Helen Borrie wrote:
> >ISC ERROR MESSAGE:
> >I/O error for file "C:\TEST.GDB"
> >Error while trying to access file
> >The process cannot access the file because
> >it is being used by another process.
> 
> Seems like a pretty good idea to me!  :)
> 
> You need exclusive access to set forced writes.

  Helen, I never used Win builds so I can to be only transmiiter for
this question, D.Kuzmenko meantime can't post here.
His example:

1. Connect ising IB_SQL.EXE, via tcp and left it as background.
2. Start one more IB_SQL set the same connect parameters,
   set FW checkbox to checked, connect.
3. Disconnect second IB_SQL.
4. Change FW checkbox to OFF, connect once more.
5. Disconnect.


Build 490 - OK

Build 682 - 
Error while trying to access file
The handle is invalid.

Build 728 used winnt.c 1.14
Error while trying to access file
The handle is invalid.

  Possibility to change FW on the fly is useful, for example, when we
periodically need do mass insert.
  Why not to make as it is done in Yaffil - using only one file handle?

Best regards, Alexander V.Nevsky.