Subject External Files Query

I am using trying to import data into firebird tables using external
files. For this I have created a table linked to an external file. This
file is populated by my .net application. After the file gets populated
with data, I fire a procedure which does an "insert into select from
external table to my main table". In the next step I am trying to
overwrite the file with new set of data, but I get an error stating file
is used by another process. On investigating further I figured out that
once I read from the external table the file is locked by firebird and
is not released unless I restart the database server. This is checked by
firing a select statement on the external table and then trying to
modify the file externally. It doesn't allow. Please let me know if
there is any solution to this problem. I am looking for any firebird
statements that can used to release the file from linking with table
after a select is done.


Mahendra Nepali

Desk: +91-22-5642-7140

Mobile: +919820191887

Email: mahendra.nepali@...

This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

[Non-text portions of this message have been removed]