Assign: Conversion from type 'DBNull' to type 'Integer' is not valid

Help Something Else
1

Hi All,

Can someone explain the cause of this error

image
image2544×1438 224 KB

2

Hi @Pavan_kumar15

Try this syntax:

CInt(If(IsDBNull(A), 0, A)) + CInt(If(IsDBNull(CurrentRow(ReadDtIndex)), 0, CurrentRow(ReadDtIndex)))

Regards

4

Making the error go away doesn’t address the root cause, and we don’t know that simply returning 0 instead of null is appropriate and meets the requirements for this automation.

5

Why are you using ReadDTIndex? That’s your problem. ReadDTIndex is the ROW index, but you’re trying to use it as a COLUMN index.

CurrentRow(x) means give me the value of column X in CurrentRow. You need to give it the COLUMN index inside CurrentRow, or give it the column name, ie CurrentRow(“Column Name”).ToString

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.