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

tufanv

tufanv

Expert
Licensed User
Longtime User
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
 
Last edited:
Sort by date Sort by votes
Pendrush

Pendrush

Well-Known Member
Licensed User
Longtime User
Your error is probably in this part
resultsetaircrafts.GetString("aircraft")
before
B4X: 
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
B4X: 
Log(resultsetaircrafts.GetString("aircraft"))

objects start from [0] I think.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

A
  • Question
iOS Question __NSPlaceholderArray initWithObjects:count:]: attempt to insert nil object from objects[1]
Replies
5
Views
791
Alex_197
A
A
  • Question
iOS Question Attempt to insert nil object from objects[2] error
Replies
1
Views
2K
Erel
  • Question
iOS Question [Solved] Attempted to insert nil object - File.Exists
Replies
7
Views
2K
Erel
R
  • Question
iOS Question [__NSPlaceholderArray initWithObjects:count:]: attempt to insert nil object from objects[2]
Replies
11
Views
5K
iCAB
I
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
153K
Erel