how the hell you allocate a null value for a smalldatetime sql field?
Now, I'm putting a false date because of I'm stuck with this f.. and then I do an update:
.Parameters("@.FecEnajenacion").Value = "1999-01-01"
error:
.Parameters("@.FecEnajenacion").Value = vbNull
.Parameters("@.FecEnajenacion").Value = Null
.Parameters("@.FecEnajenacion").Value = SqlDbType.?
Try
Parameters("@.FecEnajenacion").Value = Nothing
-Jamie
|||hi jamie,
Well, it doesn't works because of my code wait any value:
Public Overrides Sub PreExecute()
sqlCmd = New SqlCommand(sSql, sqlConn)
sqlParam = New SqlParameter("@.FecEnajenacion", SqlDbType.SmallDateTime)
sqlCmd.Parameters.Add(sqlParam)
....
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
.....
With Sqlcmd
If dFecha2 = "0000/00/00" Then
.Parameters("@.FecEnajenacion").Value = Nothing
Else
.Parameters("@.FecEnajenacion").Value = dFecha2
End If
.ExecuteNonQuery()
End With
End Sub
Prepared statement '(@.Ejercicio smallint,@.NIFPerc char(9),@.NIFRep char(9),@.Nombre va' expects parameter @.FecEnajenacion, which was not supplied.
|||enric,
the DBNull data type must be used when setting the parameter value property to null.
i recommend that you post this question to the ADO.NET forum for further assistance.|||thank you
No comments:
Post a Comment