Toad World® Forums

Varial Window pops up when I try to run a statement

I have the following code

[update WALLET_SHARE.WS_1MO set TOTAL_DISP_QTY = 20.0, BX_OPP_QTY = 10.0, BX_OPP_AMT = 185.0 where GNN = ‘TETANUS &DIPHTHERIA TOX,ADULT’ and PARENT_ID = 100241164 and DISP_UNIT = ‘DOSES’;

delete from WALLET_SHARE.WS_1MO where GNN = ‘TETANUS &DIPHTHERIA TOX,ADULT’ and PARENT_ID = 100241164 and DISP_UNIT = ‘ML’;

commit]

When I try to run the first statement I get a Variables Pop-up box, The name of the GNN I’m referencing is exsactly as it is in the WS_1MO table. How do I get this statement to run when the name contains spaces, commas, and “&”?

If executing using F9 then set substitution variable prompting to . See the Substitution Variable Prompting flyout on Editor rt-click menu.

If executing as script, F5, then add SET DEFINE OFF at the top of your script.