ETL and Data Integration tools - Modern ETL software for everyone

Hi everyone,

After connecting to a SQlite database, how do I run query for "PRAGMA user_version".

I tried using the "SQl Statement" and run it but it returns nothing.

www.sqlite.org/pragma.html

Thanks

What did you expect to see?

I could be wrong but according to the documentation, even if pragma is wrong it will not return anything or report an error

# Specific pragma statements may be removed and others added in future releases of SQLite. There is no guarantee of backwards compatibility.
# No error messages are generated if an unknown pragma is issued. Unknown pragmas are simply ignored. This means if there is a typo in a pragma statement the library does not inform the user of the fact.

Mike