Conditional load with exit script statement

[tommyl]

Hello,

I have a table(switch) with single column(status) and it has value either 'true' or 'false'. 

I want my script to loaded if the value is only 'true' and to be not loaded if the value is 'false'. 

I wrote this in the editor:

LOAD status;

[switch]:
SELECT status
FROM [schema].[switch];

let vButton = fieldvalue(status, 1) ;
if (vButton='true') then

------ Load scripts-------

else
EXIT Script;
End If;

But this does not work. Anytime i load, it automatically exits script. 

Could you please help me on this issue?

Regards,

Tommy,

[tresesco]

Try putting quotes around field name, like:

let vButton = fieldvalue('status', 1) ;

[tommyl]

Thank you for your response. Unfortunately it did not work. 

[Gabriel]

Hi,

Can I suggest 

if $(vButton)='true'  then

------ Load scripts-------

else
EXIT Script;
End If;

[Kushal_Chawda]

try this 

LOAD status;

[switch]:
SELECT status
FROM [schema].[switch];

let vButton = fieldvalue(status, 1) ;
if ('$(vButton)'='true') then

------ Load scripts-------

else
EXIT Script;
End If;

[tommyl]

I get this error:

The following error occurred:

Unexpected token: ')', expected one of: 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', 'and', ...

The error occurred here:

if ( = 'true'>>>>>>)<<<<<< then

[tommyl]

Unfortunately Kush, it didnt work out either. Thank you for the response. 

[Kushal_Chawda · Accepted solution]

LOAD status;

[switch]:
SELECT status
FROM [schema].[switch];

let vButton = fieldvalue('status', 1) ;
if ('$(vButton)'='true') then

------ Load scripts-------

else
EXIT Script;
End If;

[tommyl]

Thanks Kush for the solution. It worked well.

Btw, I dont get the idea behind, if you have some short clue on that or a link to a document, could you pls share?

[Kushal_Chawda]

Sorry.  I did not get your request? Are you asking how this worked?