very strange behavor

[Trapulo]

If CStr(params(4).Value).Length = 0 Then params(4).Value = DBNull.Value

Debugging I check this:
? CStr(params(4).Value).Length = 0

False

? CStr(params(4).Value)

"3"

But executing the code params(4).Value = DBNull.Value is executed!!

p.s. Dim params(4) As SqlParameter, where sql parameter came from MS Data
access block

[Armin Zingler]

"Trapulo" <no**********@qui.it> schrieb

If CStr(params(4).Value).Length = 0 Then params(4).Value =
DBNull.Value

Debugging I check this:
? CStr(params(4).Value).Length = 0

False

? CStr(params(4).Value)

"3"

But executing the code params(4).Value = DBNull.Value is
executed!!

p.s. Dim params(4) As SqlParameter, where sql parameter came from MS
Data access block

Change the code from a single-line If-then to a block If-then:

If CStr(params(4).Value).Length = 0 Then
params(4).Value = DBNull.Value
end if

Check again to see if the code is /really/ executed. Sometimes the IDE
behaves as if the statement in a single-line if-then is executed, but it
isn't.
--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Cor]

Hi Armin,

That is a nice message.
I did not know that.

Thanks,

Cor

[Herfried K. Wagner [MVP]]

* "Trapulo" <no**********@qui.it> scripsit:

If CStr(params(4).Value).Length = 0 Then params(4).Value = DBNull.Value

Debugging I check this:
? CStr(params(4).Value).Length = 0

False

? CStr(params(4).Value)

"3"

But executing the code params(4).Value = DBNull.Value is executed!!

I don't think so. The 'If' is executed, not the 'Then' "branch",
nevertheless, the whole line is marked. You can see that by using the
block 'If...Then':

\\\
If ... Then
...
End If
///

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Trapulo]

Yes, if I split IF..THEN in more than one row the condition in evaluated.

Bug of the ide or of the compiler.. :(
"Armin Zingler" <az*******@freenet.de> wrote in message
news:eM**************@tk2msftngp13.phx.gbl...

Change the code from a single-line If-then to a block If-then:

If CStr(params(4).Value).Length = 0 Then
params(4).Value = DBNull.Value
end if

Check again to see if the code is /really/ executed. Sometimes the IDE
behaves as if the statement in a single-line if-then is executed, but it
isn't.

[Armin Zingler]

"Trapulo" <no**********@qui.it> schrieb

Yes, if I split IF..THEN in more than one row the condition in
evaluated.
This was not the quetstion. The condition is always evaluated.
Bug of the ide or of the compiler.. :(

IDE
--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html