We have made a POS system.
Made in Delphi 2010.
Its made of 2 seperate programs. A backend and a frontend. backend uses TIB to communicate with the database.
Frontend uses IBObjects.
The program will do a lot of read-committed.
Upon an update/insert/delete the program will do a start transaction ... do whatever insert/update/delete ... Commit.All in a try...except with a rollback in the except. No user inpt from start to commit.
I am pretty sure we do not use any prepare anyware.
I will check though.
I am aware that you cant give a more precise answer sinse you dont know the programs.
This limbo transaction has only happen 3 times over the past 1½ year. And only on one database.
The programs we make are the same to every user. Database as well.
__._,_.___
Posted by: Michael.Vilhelmsen@Microcom.DK
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (12) |
Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment