Hello, I am having an issue with a Double variable which I read from a website. ( I first read it as a String) I have to write this variable on a DB column, (float) using Run Query. For the cases when the variable is empty, I have written an if: if(String.IsNullOrEmpty(readSalesIRR),nothing,Doub…

the validation message about is that the IF is not returning always the same datatype have a look here [grafik] [grafik] [grafik] set the variable datatype to Object for harmonization reasons. Later the correct datatype will be used as showcased within the immediate panel if(String.IsNullOrEm…

Double variable inserted as 0 instead of NULL on DB

Help Studio

ppr (Peter Preuss) November 4, 2022, 9:57am 2

give a try at:

if(String.IsNullOrEmpty(readSalesIRR),DBNull.Value,Double.Parse(readSalesIRR, CultureInfo.InvariantCulture))

Topic		Replies	Views
Inserting into database Activities database	1	358	April 20, 2023
Reset double variable Help	9	4616	July 29, 2019
Null to SQL for DateTime Variable and default datetime value in SQL Studio	2	2863	August 4, 2020
Assign: Conversion from type 'DBNull' to type 'Double' is not valid. If the Value is null I want to assign it as 0 Activities excel , activities , studio , activities_panel	10	667	September 24, 2023
Inserting blank value to a sql table decimal field Help	3	2820	November 23, 2023

Double variable inserted as 0 instead of NULL on DB

Related topics