Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Unanswered: Refreshing Oracle DB in Delphi Application

    I have very interesting problem here. I've built client application in Delphi 7 using dbexpress, which connects to Oracle DB and retrieves data from tables. When I edit records in application, all changes after applying can be viewed in Oracle by SELECTS... However when I add a row in Oracle to any table, Delphi application doesnt refresh its content even after dataset's refreshing....... And the most interesting thing: when I create a trigger and run it in Oracle, and after that refreshes dataset in application - it works ! - all records are refreshed...... !

    So, tu sum up, refreshin dataset in application works only after creating and running trigger in Oracle's sqlplus - looks like running trigger refreshes DB, or ODBC.. have no idea. If I dont run trigger, refresh doesnt work, even after restarting application...

    Anyone can help me with this? Thank You.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Are you sure you have commits in the relevant places? If you are restarting your Delphi (or any) app and not seeing updates made by other connections, then it is almost certainly because those changes haven't been commited.

    There are many other issues between [Oracle/SqlServer/Db2] and a [Delphi/Vb/C++/Pro*C] application and dataset refreshes, but this looks like a missing commit to me.

    Hth
    Bill

  3. #3
    Join Date
    Jun 2003
    Posts
    2

    no comments :)

    Thnx man..... I just cant belive this )) I didnt commit ... now all works fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •