Search found 1700 matches

by EgonHugeist
05.04.2011, 15:07
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7.0 Interbase GetIndexInfo for all ind. in SQLMetadata
Replies: 7
Views: 754

Me again... I missunderstud your interpetation of my posted code. Its quiet simple. Look in the function header. There you'll find a "Table" string. This String is used as Filter/TablePattern in TSQLMetadata. So if it was empty no indix was resultet. I didnt select empty Tables! I select t...
by EgonHugeist
04.04.2011, 00:04
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7.0 Interbase GetIndexInfo for all ind. in SQLMetadata
Replies: 7
Views: 754

Dear Mark, you are rigtht, but i think there is an easy workaround for supporting all indices. I'have made a real fast admin tool to check my DB, alter tables and so an. the fastestway to check it was to compare all DB items by there groups i think. On this way my tool automatically see what to alte...
by EgonHugeist
03.04.2011, 03:09
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7.0 Interbase GetIndexInfo for all ind. in SQLMetadata
Replies: 7
Views: 754

Dear Mark, the differences are: You can show all indices which are embedded in the DB independend of TableName property. But it shows some indices more than once if more than one Field is included cause of joins and groupby statements. Its a an idea no patch. But i think it can be helpfull if you wa...
by EgonHugeist
01.04.2011, 23:27
Forum: ZeosLib 7.0 Beta Forum
Topic: I have started the implementation of Triggers
Replies: 2
Views: 443

I have started the implementation of Triggers

Hey...

If have a litte Patch for getting the triggers of Interbase direkly in ZSQLMetadata an ZConnection. It was not assisted or am i wrong??
by EgonHugeist
01.04.2011, 23:11
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7.0 Interbase GetIndexInfo for all ind. in SQLMetadata
Replies: 7
Views: 754

Zeos 7.0 Interbase GetIndexInfo for all ind. in SQLMetadata

function TZInterbase6DatabaseMetadata.UncachedGetIndexInfo(const Catalog: string; const Schema: string; const Table: string; Unique: Boolean; Approximate: Boolean): IZResultSet; var SQL : string; begin Result := ConstructVirtualResultSet(IndexInfoColumnsDynArray); SQL := ' SELECT I.RDB$RELATION_NAME...

Go to advanced search