Recent content by Helmut B

  1. H

    ORA-00907 missing right parenthesis

    The error does not show up when there is no data aware component (DBGrid, RxDBGrid) being linked to the query (TOracleDataset)! Also, the error only occurs with "CountAllRecords" being set to True and with DOA 3.4.3. The DOA 3.4.6 does not show this error!
  2. H

    ORA-00907 missing right parenthesis

    Using a substitution variable in TOracleDataset SQL with a value of ' ORDER BY 1 ASC' does result in "ORA-00907 missing right parenthesis ." when opening the DataSet. Setting the variable to a single blank this message does not show up. The variable name used was :SORT, but error happens also...
Back
Top