Cannot accept the arguments: , [MAX(id) 415], [1]

MIT App Inventor Help
1

Hello.
Can anyone help?
I want to find out the max ID in the table tblKnihy in SQLite.
It still comes down to:
The operation + cannot accept the arguments: , [MAX(id) 415], [1]

gID is 0.

blocks(23)
blocks(23)1172×774 80.4 KB

Ondrej

2

The result from the sqlite database contains the header row, which is in your example MAX(id)
The result you want to get is in the example 415

So just set the property IgnoreHeadee to true before executing the query

The real error occurs later... it looks like you are using the + operation somewhere...

Btw. are you sure you want to Import the initial database on each run of the app?

Generally use Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools
Taifun

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by icon24 Taifun.

3

Thanks!
How can you arrange in your SQLite extension so that IMPORT is used only once on the first run on mobile? How to test that it has already been run once and that database is usable?
Ondrej

4

See the documentation and check the example project there how to do it

Taifun