antoni aloy wrote

> I'm trying to get the table names of my database using
>
> select RDB$relation_name as tablas from rdb$relations
> where rdb$system_flag=0
>
> This works perfectly using Interbase Workbench for exemple, but I have no
> result from TIB_Cusor or TIB_Query.
>
> Anybody know what I'm doing wrong?

What version of ibo?
I tried your query
select RDB$relation_name as tablas from rdb$relations
where rdb$system_flag=0
with IBO 4.2.Ha and it works perfectly with both IB_cursor and ib_query.

--
Best regards,
Application Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@...