B4J Question [BANanoSQL] [SOLVED] Deletes Error (alasql.loadTableData is not a function)

[Mashiane]

Hi there

Attached here is a smaller version of my app, that details the error I am experiencing.

1. Inserts - execute 10 inserts to a table - check
2. Updates - update the 'parentid' of all records - check
3. Deletes - dololo
4. Selects - selects all records from the db - check

The records created are random based on the dummy generator.

The b4j project is herein attached. I really need help!!

Thanks

 

[Mashiane]

SOLUTION

This has been documented as an issue on the AlaSQL github site, here

Changing my query to

DELETE FROM items where 1=1

to clear my table records works!

Ta!