Why is variable remains "null for no reason even after I set the value to equal something

[davegri]

davegri, doesn't quite explain why variable would have correct value in Debug but then following line showed it was empty.

Well, when strange things appear to be happening, my thought was to try the search to rule out some possibility of duplicating names.


If names are duplicated, who know which the debug.print might be looking at?

[Welshgasman]

Can't explain why, but when I change the Variable name from "FLAG" to "FLG" it works fine. Can't find a reason why such a change worked, but it did. I came up with the idea after doing various "tests" to see what was happening, and the fact when I used various different variable names, everything worked (I did a Replace all variables in entire Project).

Thanks for the help anyways, and sorry for taking up everyone's time.

Ken L

Well Flag does not appear to be a reserved word, so no ide as to why that worked.

[June7]

Welsh, the actual variable was FLAGShippingCost - "FLAG" was my shorthand.

[Welshgasman]

Welsh, the actual variable was FLAGShippingCost - "FLAG" was my shorthand.

I was just going on what the O/P stated.

Without a DB to see, we will all be guessing.