Dollar sign expansion in loading script not working

[dt_g_tsar]

Hello All,

It seems I have come across a rather strange behaviour which I cannot explain.

I have been using EXECUTE and TRACE statements in my loading script for quite a while and in several cases I have been using variables in there to formulate the string. The way I am doing that is by using the usual dollar sign expansion to grab the value in the variable. I have now come across a specific EXECUTE string where the variable does not evaluate but it just shows as $(numPage), effetively breaking my execute statement.

Are there any specific string conditions where dollar sign expansion would not work?

Thank you,

George

[jonathandienst]

Hi

Please post the script (at least the offending portion)

Regards

Jonathan

[dt_g_tsar]

Here is the script for what I am trying to do...

___________________________________________

Let numPage = 1;

FOR i=0 to 5

          EXECUTE curl/curl.exe -u api-customer@customer.com/token:sometoken https://customer.zendesk.com/api/v2/tickets.json?page=$(numPage) -k -o ..\QVD\Zendesk\tickets$(numPage).json;

          let numPage = ($(numPage) + 1);

          trace $(numPage);

next i;

___________________________________________________________________

So I would expect $(numPage) to be resolved correctly in my string as it usually does but it does not unfortunately.