Page 1 of 1

Why this code don´t execute ?

Posted: Thu 24 Apr 2008 02:15
by 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

Posted: Fri 25 Apr 2008 08:25
by 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.