Why does this coding in error? 1

[nvtjellis]

WhilePrintingRecords;
Global NumberVar Nxt_IDCODE02;
Global NumberVar Old_IDCODE01;
ToNumber next({IDCodes.IDCode});
({@Nxt_IDCODE02} = Next ({IDCodes.IDCode}));
ToNumber ({IDCodes.IDCode});
({@Old_IDCODE01} = ({IDCodes.IDCode}));
({@Nxt_IDCODE02}) - ({@Old_IDCODE01});

I need to subtract the next records IDCODE from the current IDCODE. Both are string fields in the DB.....

 

[lbass]

Try:

tonumber({IDCodes.IDCode}) - tonumber(next({IDCodes.IDCode}))

-LB