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

User: "MacPhotoBiker"
New Altair Community Member
Updated by Jocelyn
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?

Find more posts tagged with

Sort by:
1 - 3 of 31
    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
    User: "Kintaro"
    New Altair Community Member
    this method can be used to pass an extracted text from GetPage to another GetPage, too?
    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