tufanv Expert Licensed User Longtime User Jun 12, 2015 #1 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: Jun 12, 2015
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 Well-Known Member Licensed User Longtime User Jun 12, 2015 #2 Try to use sqlfleet.ExecNonQuery2 Upvote 0
tufanv Expert Licensed User Longtime User Jun 12, 2015 #3 Pendrush said: Try to use sqlfleet.ExecNonQuery2 Click to expand... Ty for answer. I have billions of code with execnonquery changing all to execnonquery2 will take too much time. Maybe there is another solution ? Upvote 0
Pendrush said: Try to use sqlfleet.ExecNonQuery2 Click to expand... 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 Well-Known Member Licensed User Longtime User Jun 12, 2015 #4 Your error is probably in this part resultsetaircrafts.GetString("aircraft") before Code: Copy 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 Code: Copy Log(resultsetaircrafts.GetString("aircraft")) objects start from [0] I think. Upvote 0
Your error is probably in this part resultsetaircrafts.GetString("aircraft") before Code: Copy 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 Code: Copy Log(resultsetaircrafts.GetString("aircraft")) objects start from [0] I think.
