"How to pass calculated parameters to Execute SQL operator?"

MacPhotoBiker

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?

MartinLiebig

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,

Martin

Kintaro

this method can be used to pass an extracted text from GetPage to another GetPage, too?

MartinLiebig

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,

martin