Why this code don´t execute ?

[JoaoShi]

This code return error SqlDataSet1 : Field RDB$RELATION_NAME not found.

Code: Select all

procedure TForm2.Button1Click(Sender: TObject);
begin
  ClientDataSet1.Close;
  sqlDataSet1.CommandText :=
       'SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS' +
       '  WHERE (RDB$FIELD_NAME = ''FILIALBASE'') AND (RDB$RELATION_NAME = ''CPLOTE'') ';
  ClientDataSet1.Open;
end;

I´m use RAD2007 and DbExpress

Thank´s

[Plash]

We could not reproduce the problem. Please send to dbxida*crlab*com a complete small sample that demonstrates the problem, including the script for creating database objects.