create temp table in sqlite function

Question

I have function in sqlite and I want to use temp table for declaring variables in this function. when I use this query out of function, it works, but use it inside function, returns null value.

problem is cause of using temp table in function. what shold I do?

this is the code:

create temp table if not exists tmp(output varchar);

delete from tmp;
insert into tmp(output) values(@arg);

select output from tmp;

this is the body of function. just define a function and call function with @arg argument and see what it returns — Reza Akraminejad, Dec 19 '15 at 12:26
but in sqlite studio I created and used it. in here I cant call it outside of sqlite studio. what should I do? — Reza Akraminejad, Dec 20 '15 at 05:46

score 1 · Accepted Answer · answered Dec 20 '15 at 12:34

The SQLiteStudio documentation says:

Custom SQL functions created in SQLiteStudio exist only in context of SQLiteStudio. [...] If you want to use some function in your own application, you have to register that function in SQLite from your application.

create temp table in sqlite function

1 Answers1