"How to pass calculated parameters to Execute SQL operator?"
MacPhotoBiker
New Altair Community Member
Hi,
I'm trying to run an SQL statement with with parameters I calculated in previous statements.
For example, the statement "DELETE FROM `Table` WHERE `Year` = 2015" works just fine.
However, I'd like pass the year (2015) as a parameter value because the value is being calculated dynamically.
The statement I'm trying to execute is
"DELETE FROM `Table` WHERE `Year` = CalculatedYear"
How could I achieve this?
I'm trying to run an SQL statement with with parameters I calculated in previous statements.
For example, the statement "DELETE FROM `Table` WHERE `Year` = 2015" works just fine.
However, I'd like pass the year (2015) as a parameter value because the value is being calculated dynamically.
The statement I'm trying to execute is
"DELETE FROM `Table` WHERE `Year` = CalculatedYear"
How could I achieve this?
0
Answers
-
You can use it as a macro and use %{calculatedYear}.
you can either look at the context menu or use the operators, e.g. extract macro.
Cheers,
Martin0 -
this method can be used to pass an extracted text from GetPage to another GetPage, too?0
-
Of course.
The method of Macros (better name: Process variables) enables you to get information from one point to the other or control several operators at a time.
If you need further help just post here
Cheers,
martin0
Altair Employee