Subject | Re: [IBO] IBOStatisticalService: How to get all the detailed Index information? |
---|---|
Author | Raymond Kennington |
Post date | 2004-11-22T13:23:02Z |
Helen Borrie wrote:
statements. These do not appear. Is this a bug or as designed?
Raymond.
> This will get the header stats and then iterate through the indexes,There are many UNIQUE indexes, i.e. not input as INDEXes but as UNIQUE
> delivering the stats into a TMemo:
>
> procedure YourForm.btnStatsClick(Sender:TObject);
> begin
> with IBOStatisticalService1 do
> begin
> ServerName :='YourServer';
> DatabaseName :='YourDBAlias'; // assuming Firebird 1.5
> Protocol := TCP_IP;
> LoginPrompt :=False;
> Params.Add('user_name=sysdba');
> Params.Add('password=masterkey');
> Active :=True;
> ServiceStart;
> try
> Options :=[HeaderPages,IndexPages,DBLog ];
> YourLogMemo.Lines.Clear;
> While not Eof do
> YourLogMemo.Lines.Add(GetNextLine);
> finally
> Active :=False;
> end;
> end;
>
> Helen
statements. These do not appear. Is this a bug or as designed?
Raymond.