topic Using variable to define load conditions in App Development

Using variable to define load conditions

Posb1 — Fri, 10 Dec 2021 15:34:26 GMT

Hi,

I am writing a load script and want to use the same condition when loading tables on multiple occasions. The condition is simple: I want to load only where a reference field is bigger than a certain number. But, I want to be able to change this later without having to go back and change it in all these places. I hoped making a variable (SET vMinRef = '1000';) and then using this in the where clause (WHERE ref >= vMinRef;) would do the trick. But this won't work, saying it can't find the field.

Is it possible to do this in the load script? How should I go about this?

Re: Using variable to define load conditions

chrismarlow — Fri, 10 Dec 2021 16:14:16 GMT

Hi,

I think in your load you need to wrap the variable in $(), so ref>=$(vMinRef).

Cheers,

Chris.

Re: Using variable to define load conditions

Posb1 — Mon, 13 Dec 2021 11:22:22 GMT

Thanks Chris,

This worked great. I must have overlooked this in the documentation. Thanks!