[firebird-support] Recursive query

Hi, I have a table with the following DDL: CREATE TABLE LOCALITY ( ID INTEGER NOT NULL, PARENT_IDINTEGER, CT_NODETYPES_ID INTEGER, DESCRIPTION VARCHAR(30), ); The foreign key: CT_NODETYPES_ID refers to a table CT_NODETYPES with the

[firebird-support] Re: Firebird export/import tool

Hi, If you accidently use Delphi and ReportBuilder (also Delphi IntraWeb), then have a look at: ReportBuilder Export Devices PRO - Overview http://www.rarefind.com/rbpro/ ReportBuilder Export Devices PRO - Overview http://www.rarefind.com/rbpro/ Export your ReportBuilder reports to

[firebird-support] Get check constraints info

Hi, I need to get a check constraints info, listing column names. I do: SELECT *   FROM rdb$triggers trg     JOIN rdb$check_constraints chk_k ON trg.rdb$trigger_name = chk_k.rdb$trigger_name      WHERE   trg.rdb$relation_name = 'SCHEMA_AUTHOR'     AND   trg.rdb$trigger_type = 1

Re: [firebird-support] Get check constraints info

Hello Maxi, Check constraints are table based, not column based. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From:

Re: [firebird-support] Recursive query

Hi, I have a table with the following DDL: CREATE TABLE LOCALITY ( ID INTEGER NOT NULL, PARENT_IDINTEGER, CT_NODETYPES_ID INTEGER, DESCRIPTION VARCHAR(30),); The foreign key: CT_NODETYPES_ID refers to a table CT_NODETYPES with the following