Android Question Strange ExecNonQuery2

incendio

Well-Known Member
Licensed User
Longtime User
Hi guys,

I have this code
B4X: 
Main.SQLMem.ExecNonQuery2("insert into MEM_CSH_BNK_IN_OT values(?,?,?,?,?,?,?)", Array As Object(RowId,Main.PUB_ID_PYMNT_TYP,IdAcN,txtCB.Text,Amnt,DscP))

It runs OK in B4A 10 without any errors even though the array size is different with the number of parameters.

The MEM_CSH_BNK_IN_OT is a sqlite in memory table.
 
Sort by date Sort by votes

drgottjr

Expert
Licensed User
Longtime User
the problem is that there is no error message. there should be. the bound parameters are a miscount.
 
Upvote 0
M

Mahares

Expert
Licensed User
Longtime User
Michael2150 said:
Try taking away a ? from the SQL statement or you are meant to add one more argument to the array that you forgot maybe
Click to expand...
The OP is telling you that there is no error. That is what is strange. She should be getting an error. Maybe the OP needs to make his post clearer and post some more code and maybe his table structure, etc. He is not giving enough information. Please read his first post again.
 
Upvote 0

drgottjr

Expert
Licensed User
Longtime User
the miscount is supposed to have thrown an error. it didn't. that's why he says it strange. he knows there is a difference between the number of placeholders and the actual number of parameters passed. sqlite's documentation says it throws an error, but we don't know exactly how our sql.jar handles things.
 
Upvote 0

mc73

Well-Known Member
Licensed User
Longtime User
Missing parameter values are set to null. On the other hand a miscount of ? will throw an error. I have to guess it's an error catch somewhere.
 
Upvote 0

drgottjr

Expert
Licensed User
Longtime User
in the interest of full disclosure, these queries behave the same way on b4j and b4a:

when the parameters passed are fewer than the number of placeholders, no error. (*see below)
when the parameters passed are greater in number than the number of placeholder, crash.

*in the case of fewer parameters, and where the missing parameters was of type int, a 0 was conveniently filled in. so, in my tests, the missing parm was not set to null.
 
Upvote 0

incendio

Well-Known Member
Licensed User
Longtime User
In my opinion, if number of place holders are not the same with the number of parameters, error should be raised.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question ExecNonQuery2 Insert using (?)
Replies
1
Views
1K
JonnyCav
E
  • Question
Android Question Solved: How to insert or update NULL in Sqlite with ExecNonQuery2
Replies
13
Views
4K
Mahares
M
  • Question
Android Question [Solved] DEBUG ExecNonQuery2 with LOG()
Replies
4
Views
2K
makis_best
  • Question
Android Question [SOLVED] B4XTable ExecNonQuery2 Select
Replies
8
Views
3K
jimmyF
  • Locked
  • Article
Android Tutorial SQL tutorial
7 8 9
Replies
161
Views
302K
luciano deri
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…