Recent content by janv1

I worked around it by using a separate dataset for the fields that would not refresh between Editing and QBE mode.

Nope, it's all missing except the where D.RowID... there.

With roAllFields=True and Debug on, this SQL occurs: "where D.RowID=doa__rowid :DOA__ROWID=AABQ9dAAEAAAXF2AAI" Then the Invalid SQL error is shown.

Howdy, we are using Delphi 5 with Direct Oracle Access 4.0.6. The dataset in question has all the refresh options except roAllFields. When I turn on roAllFields, the query to refresh is malformed- with debug on, it shows "where D.RowID=doa__rowid :DOA__ROWID=AABQ9dAAEAAAXF2AAI" when roAllFields...