Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

"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?

Find more posts tagged with

AI Studio

SQL

Accepted answers

All comments

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