iOS Question attempt to insert nil object from objects[3]?

[tufanv]

Hello,

While I am executing a sql query i am getting this error.

sqlfleet.ExecNonQuery("INSERT INTO tblfleet VALUES('19','0','"&lblmonthly3.Text&"','" & resultsetaircrafts.GetString("aircraft") & "','" &alinantur & "','" & "0" & "','" & lblcountry.text & txtcountry.text & "','" & NewID & "')")



TY

 

[Pendrush]

Try to use
sqlfleet.ExecNonQuery2

 

[tufanv]

Try to use
sqlfleet.ExecNonQuery2

Ty for answer. I have billions of code with execnonquery changing all to execnonquery2 will take too much time. Maybe there is another solution ?

 

[Pendrush]

Your error is probably in this part
resultsetaircrafts.GetString("aircraft")
before

sqlfleet.ExecNonQuery("INSERT INTO tblfleet VALUES('19','0','"&lblmonthly3.Text&"','" & resultsetaircrafts.GetString("aircraft") & "','" &alinantur & "','" & "0" & "','" & lblcountry.text & txtcountry.text & "','" & NewID & "')")

add this line and check log

Log(resultsetaircrafts.GetString("aircraft"))

objects start from [0] I think.