Dear All, Can someone point out where I'm going wrong? I have a list of records displayed in a list box from which I can double click to open records for editing in a new window. Each window is opened in its own thread and I explicitly start a transaction. For the first record opened its OK, but when trying to open a second record (in a new thread in a new window) I get this error :
"Cannot start a transaction within a transaction" I don't understand why. Surely it must be possible to open multiple simultaneous transactions, especially if they're running in their own threads? Oobviously I have a single globally accessible connection to the database open and I'm wondering if that's the issue. I'm not to keen on opening and closing lots of separate connections as it seems wasteful and may affect performance. Note that I get the exact same problem if am adding 2 new records i.e. the error occurs on an attempt to start adding the second record whilst the first one is still open). Finally, if I remove the explicit request to start a transaction then I get no error, but this is of no practical use. Regards, Narinder. -- ___________________________________________ | Narinder Chandi, | ToolBox Systems Limited, | Surrey, England, UK. | http://www.toolbox.uk.com |___________________________________________ | Consultancy * Development * Support |___________________________________________ _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
