Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: How in firebird/Zeos to pick up changes made in background thread?


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 0
Mark Patterson

Posts: 15
Registered: 5/28/07
How in firebird/Zeos to pick up changes made in background thread?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 11, 2015 9:44 PM
Hi

I have a job that runs a background thread adding new tables. When it is finished I have to close the app and reopen it to see the new tables.

What is the right way to pick them up immediately? I have tried a couple of things in the main thread after the background thread has finished. It has worked disconnecting and reconnecting the database in the main thread, but that is crashing at present. I am getting I/O Error during "open" for file ... Error code -902.

I was advised to commit any transaction and start a new one in, but that didn't make the new table available.

I'm using Zeos and Firebird 2.5 embedded.

TIA
Mark

Edited by: Mark Patterson on Oct 12, 2015 3:03 PM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02