Save text to variable

[tepagom]

how to save a textfield text into a variable in order to be used later as a filter value into sql query?

[Michael]

You can use Text widget to hold variable

See the example save_variable.pma (519.3 KB)

[tepagom]

Thankyou very much!
and how can i use this variable to filter a database table? i have used this syntax and din´t work

SELECT * FROM data WHERE “field2” LIKE ‘document.childByName(“textVar”).content.plainText’ LIMIT 0, -1

thanks in advance again!

[Michael]

1. Select Script code in the Type argument list

2. Add the following code:
    

   “select * from data where field3 LIKE '%”

   • document.childByName(“input”).content.text
   • “%’”

See the example sql_query.pma (560.7 KB)