This was my last attemp for the day.
This doesn't work, I don't understand. This line of code shouldn't be any different then the below it and the one below works good.
---------------doesn't work-----------------------------------------
cmd.CommandText = "INSERT INTO pictures values('" & txtAngle.text & "', & cmd.FileToBLOB(" AppPath " & "\" & '" & txtAngle.text & "') &")"
------------------does work----------------------------------------
cmd.CommandText = "insert into WorkData values('" & txtInternal.Text & "','" & txtColdOd.Text & "','" & txtColdFp.Text & "','" & txtHotOd.Text & "','" & txtHotFp.Text & "','" & txtAmtWire.Text & "','" & txtPph.Text & "','" & txtWireSize.Text & "','" & txtCyctime.Text & "','" & txtMach.Text &"')"
delete , update and insert uses the format above and seems to be working fine. The data base checks out fine when I use these three commands with the above format. The top one with filetoblob is being a real stickleer. Well tomorrow another day. Being a third shift person it's my bed time. Tomorrow is another day. Have a good one all.
dennishea