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

'app-layout' is not a known element: how to share Component with different Modules

Image
0 My application was working fine until I decided to go with lazy loading: So, my shared component looks like this: import { Component, Renderer2 } from '@angular/core'; export interface FormModel { captcha?: string; } @Component({ selector: 'app-layout', templateUrl: './app-layout.component.html', styleUrls: ['./app-layout.css'] }) export class FullLayoutComponent { } app-layout.component.ts I am using this component in my Another component say school-home.component.html like this: <app-layout> </app-layout> and it was working fine until I created a Module school-home.module.ts like this: import { NgModule } from '@angular/core'; import { CommonModule } from '@angular/common'; import { SchoolhomeRoutingModule ...
Read more

android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 This is a simple project showing cubes on Unity, exported to android project and imported on Android studio. On maifest file it showed following warning: Expecting <uses-feature android:name="android.software.leanback" android:required="false" /> tag I have no information about it. And also on default emptyview android project does not use/mention this feature. I know it is required by TV's and such but why its not added by default? Why is this? And Should I concern about it? android unity3d ...
Read more

WPF add header to Image with URL pettitions [duplicate]

Image
up vote 0 down vote favorite This question already has an answer here: Image source URI requiring authorization 3 answers Add header to all* HTTP requests on a machine 1 answer first of all sorry for my english. Recently I added some security in the backend of my project, and now I need to send a validation code(apiKey) inside the headers to retrieve the images. I have a problem with ALL images in my project that I had attached in my UI. For example, before I had: <Image Height="90" Source="{Binding Video.Thumbnail}"/> Now I need to change my code to create a CUSTOM petition add the apiKey in the header:...
Read more