Script variables as fixed string

[#1]

Good morning,

I have

set DC_Ind_Budget = 'C';

and then

MyTable:
load
$(DC_Ind_Budget)) as [Debit / Credit Indicator];

This results in error "Field not found - <C>". The following doesn´t work neither

''' & $(DC_Ind_Budget)) & ''' as [Debit / Credit Indicator];

Thanks in advance for your suggestions,

Leonardo

[Anonymous]

try

MyTable:
load
'$(DC_Ind_Budget))' as [Debit / Credit Indicator];

[cesaraccardi]

Hi,

Also check the closing parenthesis at the end, looks like you have one extra.

MyTable:
load
'$(DC_Ind_Budget)' as [Debit / Credit Indicator];

[sunny_talwar]

Or you can do this:

SET DC_Ind_Budget = Chr(39) & 'C' & Chr(39);

MyTable:
LOAD $(DC_Ind_Budget) as [Debit / Credit Indicator];