Hi
Can somebody please tell me what is wrong with the following coding
'erase a job
i=Msgbox ("Are You Sure To Erase The Selected Job? ","Erase Job",cMsgBoxYesNo,cMsgBoxQuestion)
If i=6 Then
text="Delete From Jobs Where JobName = " & quote & ListJobs.Text & quote
'Msgbox (text)
cmd.CommandText=text
cmd.ExecuteNonQuery
con.Close
End If:sign0161:
I am trying to delete a jobname from the SQLLite database.:sign0085:
Thanks
Michael
Can somebody please tell me what is wrong with the following coding
'erase a job
i=Msgbox ("Are You Sure To Erase The Selected Job? ","Erase Job",cMsgBoxYesNo,cMsgBoxQuestion)
If i=6 Then
text="Delete From Jobs Where JobName = " & quote & ListJobs.Text & quote
'Msgbox (text)
cmd.CommandText=text
cmd.ExecuteNonQuery
con.Close
End If:sign0161:
I am trying to delete a jobname from the SQLLite database.:sign0085:
Thanks
Michael