i-effect Manual

Table from SQL

This widget displays the result of an SQL as a table with nameable columns.

image2022-3-9_13-43-41.png

The SQL may only contain single quotes ', as separator between database and table only a . is allowed. With the button "Get fields" all fields are listed and can be activated and named by checkbox. Additionally, the order can be changed by drag and drop.

image2022-3-9_13-42-54.png