Recent content by icegood

  1. I

    RCorrectly refresh record after insert/update

    Seems, i understand how to workaround such a behavior. It is crucial to update fields via NewValue property there.
  2. I

    RCorrectly refresh record after insert/update

    Hi, Marco! I want to share my experience of usage of TOracleDataSet. In documentation we can find smth. like : but in practice it is not true. The problem is when i simply update records in OnApplyRecord during I/U actions it writes values to different buffer because TOracleDataSet.Applying =...
  3. I

    A couple of bugs

    Hi, Marko. Have another set of wrong behaviour of TOracleDataSets: 1) Delphi documentation states that (ms-help://embarcadero.rs_xe3/libraries/Data.DB.TDataSet.Eof.html) But in case when oracle dataset has one inserted and not posted record then both of EOF and BOF remains true. Addition check...
  4. I

    change fields in OnApplyUpdates => 'Record has been changed'

    Please, consider attach to see what i mean. 1) Install your own session 2) compile and run under XE3 3) insert record. 4) apply updates. Note, that 'id' field on screen is not changed. 5) try to edit that new record => 'Record has been changed' error occurs...
  5. I

    change fields in OnApplyUpdates => 'Record has been changed'

    I obtained inconsistency on 'MY_ID' field and it's not changed on triggers
  6. I

    Commit changes via session

    I have next implementation of CommitUpdates: procedure TOracleSession.CommitUpdates(const DataSets: array of TDataSet); var i: Integer; DataSetList: TList; begin DataSetList := OrderedDataSetList(DataSets); try // Commit the updates in each dataset (Detail -> Master) for i :=...
  7. I

    change fields in OnApplyUpdates => 'Record has been changed'

    I must also say, that fields are created not only from SQL There is also one more calculated field added...
  8. I

    change fields in OnApplyUpdates => 'Record has been changed'

    And yes, lock model = lmLockImmediate
  9. I

    change fields in OnApplyUpdates => 'Record has been changed'

    SELECT ROWID, FROM MY_TABLE
  10. I

    change fields in OnApplyUpdates => 'Record has been changed'

    Tried to implement next architecture: 1) Generate fake id's on AfterInsert statement MyDS.FieldByName('MY_ID').AsInteger := nFakeID; 2) Change them to real ones on OnApplyUpdates: MyDS.FieldByName('MY_ID').AsInteger := nRealID; Applied => FALSE to let DOA do rest of the work => Record...
  11. I

    Use case: direct rollback

    Sorry, but i didn't specify exactly my use case. I don't need refresh as i need to try to re-commit local uncommitted changes. I don't want lost them after first failed try.
  12. I

    Delphi: How to pass a table of records as a parameter to an Oracle Stored procedure

    Hi Marco! What about associative array? http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/05_colls.htm
  13. I

    Use case: direct rollback

    Hi. I have DOA v 4.1 and I have an TOracleDataset which works with next parameters: CachedUpdates=FALSE CommitOnPost = FALSE So, when i post record it is written to DB. After that it might be situation that i will roll back my changes. How can revert my TOracleDataset to meaningful state in...
  14. I

    Array DML: declaration

    no, i mean 'PL/SQL Table' vs 'Array DML' variable
  15. I

    Array DML: declaration

    It's clear from documentation on how to declate 'PL/SQL Table' at runtime (DeclareVariable + DimPLSQLTable.) but i don't see any guide on how to declare simple array variable at runtime for Array DML... I'm using DOA 4.1
See more
Back
Top