# How to pass value from Database (SQLite) to Internal Memory Tags **URL:** \ **Category:** Ignition\ **Tags:** ignition81, scripting\ **Created:** [November 17, 2021, 4:43am UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166 "2021-11-17T04:43:41Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![p.srikanth0707](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Post date:** [November 17, 2021, 4:43am UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/1 "2021-11-17T04:43:41Z")
Hello all, Good Morning, Could you please help me how to pass the values from database table column values to Memory tags ? Appreciated for your quick response with the simple solutions Regards, Srikanth P ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [November 17, 2021, 6:22am UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/2 "2021-11-17T06:22:35Z")
Welcome! Why a memory tag, instead of a query tag? ---
**Author:** ![p.srikanth0707](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Post date:** [November 17, 2021, 7:00am UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/3 "2021-11-17T07:00:23Z")
As I understood Query tag read from the database, I want to pass some data from the table on particular events if that I can achieve with Memory tag, that would be helpful for me. ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [November 17, 2021, 11:44am UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/4 "2021-11-17T11:44:06Z")
Do you want to pass the entire table’s dataset to a memory tag of type dataset, or individual cells to individual tags? ---
**Author:** ![p.srikanth0707](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Post date:** [November 17, 2021, 2:25pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/5 "2021-11-17T14:25:11Z")
Individual tags to Individual Memory Tags. ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [November 17, 2021, 2:26pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/6 "2021-11-17T14:26:52Z")
Tags to tags? I thought you were going table data to tags? If the latter, which columns and rows need to go to tags, all, albeit one at a time? Or just selected rows etc? ---
**Author:** ![p.srikanth0707](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Post date:** [November 17, 2021, 2:40pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/7 "2021-11-17T14:40:39Z")
Table data Example : If there is a table having 3 rows and 3 columns, I want to pass first row first column table value from Database to Memory Tag (Float) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [November 17, 2021, 3:52pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/8 "2021-11-17T15:52:04Z")
Consider transaction groups. [https://inductiveuniversity.com/videos/transaction-group-introduction/8.1](https://inductiveuniversity.com/videos/transaction-group-introduction/8.1) ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [November 17, 2021, 5:44pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/9 "2021-11-17T17:44:38Z")
A query tag that writes to a memory tag in its tag change event seems pretty easy. ---
**Author:** ![p.srikanth0707](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\ **Post date:** [November 22, 2021, 2:01pm UTC](https://forum.inductiveautomation.com/t/how-to-pass-value-from-database-sqlite-to-internal-memory-tags/53166/10 "2021-11-22T14:01:42Z")
Thank you so much @Kevin.Herron This way is very simple thanks for the reply with an great Idea ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/d/5d16185f3e7796e1bd438188b6d30994ef010b89.png)