CDBL : Giving error “Type mismatch on negative number” [on hold]











up vote
0
down vote

favorite












I am trying to convert the below string to Double "-5470.66". During runtime i am getting Type mismatch error.



Code:



sTempBal = "-5470.66"

sCntBal = cDbl(sTempBal)'''Getting Error "Type mismatch CDbl on the same

Msgbox sCntBal





vbscript hp-uft uft14







share|improve this question













put on hold as off-topic by Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity 2 days ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity

If this question can be reworded to fit the rules in the help center, please edit the question.









  • 1




    It works fine for me, are you sure you're pasting the code correctly?
    – Motti
    2 days ago






  • 2




    Note that CDbl is locale-dependent, you might want to include your locale settings to help us reproduce the issue. As-is, I can't reproduce this with common EU and US locale settings.
    – Erik von Asmuth
    2 days ago















up vote
0
down vote

favorite












I am trying to convert the below string to Double "-5470.66". During runtime i am getting Type mismatch error.



Code:



sTempBal = "-5470.66"

sCntBal = cDbl(sTempBal)'''Getting Error "Type mismatch CDbl on the same

Msgbox sCntBal





vbscript hp-uft uft14







share|improve this question













put on hold as off-topic by Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity 2 days ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity

If this question can be reworded to fit the rules in the help center, please edit the question.









  • 1




    It works fine for me, are you sure you're pasting the code correctly?
    – Motti
    2 days ago






  • 2




    Note that CDbl is locale-dependent, you might want to include your locale settings to help us reproduce the issue. As-is, I can't reproduce this with common EU and US locale settings.
    – Erik von Asmuth
    2 days ago













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I am trying to convert the below string to Double "-5470.66". During runtime i am getting Type mismatch error.



Code:



sTempBal = "-5470.66"

sCntBal = cDbl(sTempBal)'''Getting Error "Type mismatch CDbl on the same

Msgbox sCntBal





vbscript hp-uft uft14







share|improve this question













I am trying to convert the below string to Double "-5470.66". During runtime i am getting Type mismatch error.



Code:



sTempBal = "-5470.66"

sCntBal = cDbl(sTempBal)'''Getting Error "Type mismatch CDbl on the same

Msgbox sCntBal





vbscript hp-uft uft14




vbscript hp-uft uft14






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 2 days ago









nishit dey

443413




443413




put on hold as off-topic by Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity 2 days ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity

If this question can be reworded to fit the rules in the help center, please edit the question.




put on hold as off-topic by Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity 2 days ago


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – Lankymart, Michael Dodd, Erik von Asmuth, K.Dᴀᴠɪs, Machavity

If this question can be reworded to fit the rules in the help center, please edit the question.








  • 1




    It works fine for me, are you sure you're pasting the code correctly?
    – Motti
    2 days ago






  • 2




    Note that CDbl is locale-dependent, you might want to include your locale settings to help us reproduce the issue. As-is, I can't reproduce this with common EU and US locale settings.
    – Erik von Asmuth
    2 days ago














  • 1




    It works fine for me, are you sure you're pasting the code correctly?
    – Motti
    2 days ago






  • 2




    Note that CDbl is locale-dependent, you might want to include your locale settings to help us reproduce the issue. As-is, I can't reproduce this with common EU and US locale settings.
    – Erik von Asmuth
    2 days ago








1




1




It works fine for me, are you sure you're pasting the code correctly?
– Motti
2 days ago




It works fine for me, are you sure you're pasting the code correctly?
– Motti
2 days ago




2




2




Note that CDbl is locale-dependent, you might want to include your locale settings to help us reproduce the issue. As-is, I can't reproduce this with common EU and US locale settings.
– Erik von Asmuth
2 days ago




Note that CDbl is locale-dependent, you might want to include your locale settings to help us reproduce the issue. As-is, I can't reproduce this with common EU and US locale settings.
– Erik von Asmuth
2 days ago

















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

Popular posts from this blog

Can a sorcerer learn a 5th-level spell early by creating spell slots using the Font of Magic feature?

Image
28 6 $begingroup$ Per the Font of Magic feature, sorcerer can use Flexible Casting to create 5th-level spell slots at level 7, even though they are not typically available until level 9. You can transform unexpended sorcery points into one spell slot as a bonus action on your turn. The Creating Spell Slots table shows the cost of creating a spell slot of [5th level is 7] If such a sorcerer levels up while still having this 5th-level spell slot, can they choose a 5th-level spell as the spell they gain upon levelling up? The Spellcasting feature states: Additionally, when you gain a level in this class, you can choose one of the sorcerer spells you know and replace it with another spell from the sorcerer spell list, which also must be of a level for which you have spell slots.
Read more

Does disintegrating a polymorphed enemy still kill it after the 2018 errata?

Image
up vote 13 down vote favorite 1 After the 2018 errata, the disintegrate spell description now reads: A creature targeted by this spell must make a Dexterity saving throw. On a failed save, the target takes 10d6 + 40 force damage. The target is disintegrated if this damage leaves it with 0 hit points. If you were to polymorph an enemy into a rat and then disintegrate it, would the enemy be disintegrated or would it just return to its original form? I know that for Druids, it’s not an instant kill anymore, but is this the case for polymorph as well? dnd-5e spells polymorph errata share | improve this question edited 18 hours ago
Read more

A Topological Invariant for $pi_3(U(n))$

Image
3 3 $begingroup$ Recently, I saw a construction of topological invariant for $pi_3(U(n))$ with $ngeq 2$ : $$ N=frac{1}{24pi^2}int_{S^3} d^3x epsilon^{ijk} Tr[(U^{-1}partial_{x_i}U)(U^{-1}partial_{x_j}U)(U^{-1}partial_{x_k}U)] , $$ where $Uin U(n)$ depends on $boldsymbol{x}=(x_1,x_2,x_3)in S^3$ , $epsilon^{ijk}$ is the Levi-Civita symbol, $i,j,k=1,2,3$ , and the duplicated indexes are summed over. It is claimed that $N$ is an integer, but why? Update 02/02/2019 I think I got an argument for $n=2$ . In this case, $U=e^{i varphi} q$ with $qin SU(2)$ . Due to the trace and the Levi-Civita symbol in $N$ , $varphi$ does not contribute to $N$ . As $Tr[q^{dagger}partial_i q]=0$ and $(q^{dagger}partial_i q)^{dagger}=-q^{dagger}partial_i q$ , $q^{dagger}partial_i q$ in geneeral has the form $q^{dagger}partia
Read more