hi every one here.
i hope some expert here in vb6.0 could help me on my problem handling null values of dtpicker.
i'm bothering about this error how to solve this. this is my code:
sql = "INSERT INTO NOSOld ("
sql = sql & "ID, "
sql = sql & "Name, "
sql = sql & "Specialization, "
sql = sql & "Date_of_NOS, "
sql = sql & "Date_Encoded, "
sql = sql & "Case_Officer, "
sql = sql & "Notes, "
sql = sql & "Status"
sql = sql & ")"
sql = sql & "VALUES "
sql = sql & "("
sql = sql & "'" & lngID & "', "
sql = sql & "'" & Text2.Text & "', "
sql = sql & "'" & Text3.Text & "', "
If DTPicker2.CheckBox = True Then
sql = sql & "'" & CDate(DTPicker2.Value) & "', "
Else
sql = sql & Null & ", "
End If
If DTPicker1.CheckBox = True Then
sql = sql & "'" & CDate(DTPicker1.Value) & "', "
Else
sql = sql & Null & ", "
End If
sql = sql & "'" & Combo1.Text & "', "
sql = sql & "'" & Text4.Text & "', "
sql = sql & "'" & Combo2.Text & "' "
sql = sql & ")"
cn.Execute (sql)
when i hit enter the error message pop upping saying "INVALID USE OF NULL". i've tried other suggestions but didn't lucky and still getting the same error.
please need some help.
thanks in advance,
- Add new comment
- 43 views
re: Inserting a null value dtpicker
value of dtpicker
re: value of dtpicker
value of sql
re: value of sql
error type mismatch
re: error type mismatch
I created a sample for you:
Insert Null Value into Date/Time Field.
ignore
already done sir
Add new comment