Hi;

We have a VIEW with JOINS in many TABLES, amongst which, one that has
calculated fields as (COMPUTED BY ((select FIELD from TABLE.))...
(singleton of course)), and some other fields calculated as in the example:

CREATE TABLE (Table ...
FieldX...,
FieldY...,
STATUS COMPUTED BY ((select STATUS from sp_Manutencao_Status (...
parameters...)))
...)

Where:
- STATUS is the name of the field;
- sp_Manutencao_Status is a Stored-Procedure.

So, the "selects" (of any way) for the data, through this wiew, eventually
cause LOSS OF CONNECTION WITH THE DATA BASE!

We did an example in link:
http://raphael.nunes.vila.bol.com.br/exemplo.zip.

We would like to know if the problem is related with the threads of
firebird, or if another cause exists, and why the problem happens.

Since already we are grateful!

PS: We use:
- Server Firebird SS Version 1.0.3.972-0;
- Delphi7 with IBX version 7.03.

--
Raphael A. Nunes;
Sector of Development;
Oriontec Systems Inc.;

Edson T. Marques;
Sector of Development;
Oriontec Systems Inc.;