"How to pass calculated parameters to Execute SQL operator?"
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?
Find more posts tagged with
Sort by:
1 - 3 of
31
this method can be used to pass an extracted text from GetPage to another GetPage, too?
Altair EmployeeOf 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,
martin
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,
martin
you can either look at the context menu or use the operators, e.g. extract macro.
Cheers,
Martin