Alexis

Iterate through table values to create SQL expression [SOLVED]

Discussion created by Alexis on Mar 8, 2017
Latest reply on Mar 13, 2017 by Alexis

I want to create a SQL expression based on records selected by the user.

For example my input table has only one column "HOLEID" with two records "4943" and "4944" (string).

I want to iterate through that table to generate the following SQL expression : "HOLEID" IN ('4943','4944') .

I'll then store that expression in a variable and use it in several places to select and delete records in other tables.

I'm still searching for an easy way to do that but sor far with no success. I'm not a Python pro but I can understant basic scripting.

Any ideas ?

Thanks

Outcomes