# Cannot query user\_version from SQLite Database

**URL:** <https://discourse.julialang.org/t/cannot-query-user-version-from-sqlite-database/107829>\
**Category:** Data\
**Tags:** sqlite\
**Created:** [December 19, 2023, 8:30pm UTC](https://discourse.julialang.org/t/cannot-query-user-version-from-sqlite-database/107829 "2023-12-19T20:30:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![guilhermebodin](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/guilhermebodin/32/6982_2.png) [@guilhermebodin](https://discourse.julialang.org/u/guilhermebodin)\
**Post date:** [December 19, 2023, 8:30pm UTC](https://discourse.julialang.org/t/cannot-query-user-version-from-sqlite-database/107829/1 "2023-12-19T20:30:39Z")

</div>

Hello, does anybody know how should I execute this query?

```julia
using SQLite
db = SQLite.DB()
SQLite.execute(db, "PRAGMA user_version = 3;")
@show version = SQLite.execute(db, "PRAGMA user_version;") # returns 100

```

---

<div class="post-metadata">

**Author:** ![guilhermebodin](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/guilhermebodin/32/6982_2.png) [@guilhermebodin](https://discourse.julialang.org/u/guilhermebodin)\
**Post date:** [December 19, 2023, 8:37pm UTC](https://discourse.julialang.org/t/cannot-query-user-version-from-sqlite-database/107829/2 "2023-12-19T20:37:34Z")

</div>

@quinnj anwsered in slack.

```julia
using SQLite
db = SQLite.DB()
DBInterface.execute(db, "PRAGMA user_version = 3;")
@show version = DBInterface.execute(db, "PRAGMA user_version;") # returns 3

```