> 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.
>

1) .Net creates physical file in format FB likes
2) declare external table in FB
3) commit
4) run insert into select from query
5) commit
6) drop external table
7) commit

Repeat

Adam