> I use Delphi 6 Professional, Interbase 6.0 and dbExpress components.
> I have a database with a table and the following statement:

>  with SQLQuery1 do
>        try
>          Active := False;
>          SQL.Clear;
>          SQL.Add('SELECT * FROM TerminalLayout1');
>          SQL.Add('WHERE term = :term');
>          Params.ParamByName('term').Value := 'eg';
>          Active := True;
>          if RecordCount <> 0 then <-----------ERROR
>            ShowMessage(IntToStr(RecordCount));
>        finally
>          Active := False;
>        end;

> In the marked line I get the following error.

> ---------------------------
> Project1
> ---------------------------
> DBX Error: Operation Not Supported.
> ---------------------------
> OK
> ---------------------------

> Does anyone know why I cannot use the RecordCount property?
> TIA
> Mario

> An option would be to perform another query and use COUNT(*) instead
> of * to get the number of records.

> --

> Robert Love - (rlove at slcdug.org)
> Salt Lake City Delphi Users Group - http://www.slcdug.org
> Delphi JEDI - http://www.delphi-jedi.org
> Turbopower TPX Member - http://www.turbopower.com