What is the format for the SELECT option? I cannot get this to work, it has to be empty. I expected it to be something like: column1, column2
but that gives an error
Best answer by takashi
View original
Example SQLITE reader with SQL Parameters
+1
Userlevel 2
+17
- Contributor
- 7538 replies
-
10 June 2017
- Best Answer
Hi @kimo, you can set a SQL SELECT statement to the SELECT Statement parameter to perform query on the database. The reader feature type outputs the query result, regardless of the schema configuration displayed on Workbench Canvas.
For example, if you set this SELECT statement to the parameter, the reader feature type reads features having column1 and column2 from "my_table" table.
select column1, column2 from my_tableThe SQLCreator/SQLExecutor can be used to execute any SQL statements more conveniently, so I don't know the SELECT Statement parameter in a database reader feature type should be used in what kind of situation.
+1
Thank you for the example, sadly missing in the help. I was only putting in column1,column2. I did not have to enter where in the where clause.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.