At 04/26/2002 07:06 AM, you 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?

It works for me, with IBO versions 3.6 and 4.2.


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