# Update database for each transaction **URL:** \ **Category:** V5 Question\ **Created:** [March 17, 2019, 8:06pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617 "2019-03-17T20:06:14Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 8:06pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/1 "2019-03-17T20:06:15Z")
how can i update database on every transaction? i want when i sell any item to update database directly cause i want to use more than 1 selling point ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 8:08pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/2 "2019-03-17T20:08:26Z")
What do you mean more than 1 selling point? You mean price? ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 8:10pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/3 "2019-03-17T20:10:26Z")
more than 1 selling computer ---
**Author:** ![JTRTech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jtrtech/32/21270_2.png) [@JTRTech](https://forum.sambapos.com/u/JTRTech)\ **Post date:** [March 17, 2019, 8:42pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/4 "2019-03-17T20:42:40Z")
You need to use SQL Express and set each terminal to that database. Data is saved to database on ticket close/submitting and all data is consolidated in the single DB ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 8:49pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/5 "2019-03-17T20:49:35Z")
so what i should do is to make an action and update ticket state on ticket closing right? ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 8:51pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/6 "2019-03-17T20:51:14Z")
I think we are confused here. You want to use multiple terminals right? ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 8:52pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/7 "2019-03-17T20:52:03Z")
yes more than 1 computer … 1 database ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 8:54pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/8 "2019-03-17T20:54:32Z")
Ok so you need to download and install the latest version of SQL Express and then you need to go to Settings \> Local Settings \> Database and set your connection. Then you go to Local Settings \> General and set your terminal names for each terminal. Server, Terminal 1 etc. Here is instructions to get it working with SQL Express. [https://kb.sambapos.com/en/2-1-3-a-sql-express-server-setup/](https://kb.sambapos.com/en/2-1-3-a-sql-express-server-setup/) ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 8:55pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/9 "2019-03-17T20:55:04Z")
Each terminal would need to be connected to the database aka main terminal. ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 8:55pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/10 "2019-03-17T20:55:31Z")
You would need to network them. ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 8:56pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/11 "2019-03-17T20:56:18Z")
i already works on express 2014 ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 9:03pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/12 "2019-03-17T21:03:15Z")
Then just install SambaPOS to the other terminal and set the connection string to that server. But are you sure your using SQL Express 2014 or SQL Express LocalDB? ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 9:05pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/13 "2019-03-17T21:05:02Z")
> [@Jesse](#): > > But are you sure your using SQL Express 2014 or SQL Express LocalDB? yes i’m sure of that ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 9:06pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/14 "2019-03-17T21:06:53Z")
Ok so just setup Sambapos on the other terminal then connect it via the connection string. then set the terminal name. Thats all you do. ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 9:07pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/15 "2019-03-17T21:07:56Z")
ok i think only one step remains which is knowing how to update db on each transaction ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 9:09pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/16 "2019-03-17T21:09:07Z")
> [@Mohab](#): > > so what i should do is to make an action and update ticket state on ticket closing > right? is this true? seems it doesnt work with me ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 9:09pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/17 "2019-03-17T21:09:16Z")
What do you mean by that? what are you wanting to update? ---
**Author:** ![Mohab](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/m/d78d45/32.png) [@Mohab](https://forum.sambapos.com/u/Mohab)\ **Post date:** [March 17, 2019, 9:11pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/18 "2019-03-17T21:11:36Z")
when i sell a product it decreases from db when i add sth its added for all now i only update the db when i end work period and i dont want to end work period for every transaction done ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 9:12pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/19 "2019-03-17T21:12:30Z")
Ok so you want to track inventory? > [@Mohab](#): > > when i add sth its added for all No idea what sth is. > [@Mohab](#): > > now i only update the db when i end work period What are you updating the database for? ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [March 17, 2019, 9:13pm UTC](https://forum.sambapos.com/t/update-database-for-each-transaction/19617/20 "2019-03-17T21:13:40Z")
I think you are confused. Did you actually download and install Microsoft SQL Express 2017? Or did you install the one SambaPOS asked you to install? [Next page](https://forum.sambapos.com/t/update-database-for-each-transaction/19617.md?page=2)