At 04/29/2002 05:56 AM, you wrote:

>I'm using 4.2Ha. I have wrote the sql "select RDB$relation_name as tablas
>from rdb$relations where rdb$system_flag=0" and make a prepare. The plan
>looks good, but when I go to the data tab there is nothing in it. I have the
>same when I run the application.

Try this:

select RDB$relation_name as tablas
from rdb$relations
where (rdb$system_flag=0) or (rdb$system_flag is null)

I know that at one point the rdb$system_flag wasn't assigned a value for a
user-defined database object in certain circumstances.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)