Member Avatar for Zulu79

I am in the process of converting a program from vb 6 to VB.Net. I am taking a large amount of data and placing it in the proper sql collum.
Any help will be greatly appreciated.

I am getting this error code here:

If ExistsInrsTemp("NextMthDue") = True Then

If InStr(NullSafeValue(rsTemp, "NextMthDue"), "/") > 1 Then
 Mid(sDocTrans, 43, 2) = Format(CInt(Left(NullSafeValue(rsTemp, "NextMthDue"), InStr(NullSafeValue(rsTemp, "NextMthDue"), "/") - 1)), "00")

 Mid(sDocTrans, 45, 2) = Format(CInt(Mid(NullSafeValue(rsTemp, "NextMthDue"), InStr(NullSafeValue(rsTemp, "NextMthDue"), "/") + 1)), "00")

End if
Edited by pritaeas because: Added markdown.
  • 2 Contributors
  • 2 Replies
  • 199 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by Zulu79
Member Avatar for Reverend Jim

"_0" is not an integer. Strip off the underscore before you try to convert.

Member Avatar for Zulu79

Thank you. I did some reseach, and the user entered the wrong vaule.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.