Recent content by SteLal

  1. S

    Problem with VARRAYs

    Thanks, I will negotiate this with my boss.
  2. S

    Problem with VARRAYs

    DOA 3.3.2 Oracle 8.1.7 C++Builder 5 I'm trying to use an object variable to call a procedure using a VARRAY type, defined as: create or replace type my_array as VARRAY(50) of number And I get an access violation when I try this: TOracleObject* obj = new TOracleObject(session, "my_array"...
  3. S

    Default date conversions

    I am not really sure that the problem come from TOracleSession (I suspect Oracle instead) I've found a clean workaround to my problem: " alter session set NLS_DATE_FORMAT = 'DD/MM/YYYY' " just after Connected = true ...and all works fine ! Thanks for replying ------------------ St
  4. S

    Default date conversions

    DOA 3.3.2 / Oracle 8.1.7 / BCB5 / French I am changing dynamically the login propery of my unique TOracleSession. Example: (session 's' already connected) Before: executing "SELECT TO_CHAR(SYSDATE)FROM DUAL" -> OK s->Connected = false; s->Login = "NewSchema"; s->Connected = true; After...
  5. S

    RefreshRecord does not refresh LOBs

    Oracle 8i 8.1.6 / DOA 3.3.2 / BCB5 When I use RefreshRecord (w/ refresh options set to roAllFields) my LOBs fields are not refreshed... RefreshRecord documentation doesn't talk about LOBs. Is there a trick ? Is this supported in version 3.3.2 or do I write some code in AfterRefreshRecord to do...
  6. S

    RecordCount is not up to date after deleting a record

    Thanks Marco ! To always have RecordCount up to date, this solution works fine: - Set CountAllRecords to TRUE - Open the DataSet. - Set CountAllRecords to FALSE, assuming correct recordcount when adding/removing records. - Don't forget to Set CountAllRecords to TRUE before each re-opening...
  7. S

    RecordCount is not up to date after deleting a record

    Windows NT / Oracle 8i / BCB5 / DOA 3.3.2 RecordCount is not up to date after deleting a record: I have a OracleDataset based on a "normal" table or on a temporary table. By example, it contains 8 records. RecordCount is 8. When I delete one record (ore more), record count stills says 8. Via...
  8. S

    TOracleDataSet : BookmarkValid but bookmark not found

    Windows NT / Oracle 8i / BCB5 / DOA 3.3.2 I get a bookmark of a record in a TOracleDataSet. I delete this line (Delete()) When I ask "BookmarkValid", the DataSet answers TRUE, but if then I try to "GotoBookmark", it fails on "Bookmark not found (recno)" BookmarkValid isn't supposed to be up...
Back
Top