I am trying to create a database in kodular and after running the app in the companion it closes.
I have an SQLite database when initializing Screen1, I have the create table creation block and it doesn’t work:
When Screen1.Initialize
do call .Single SQL
sql “CREATE TABLE products (product_id INTEGER PRIMARY KEY AUTOINCREMENT, product_name VARCHAR NOT NULL, quantity INTEGER NOT NULL DEFAULT 0);”
This statement is copied from the sqlite website.
When you run the application, it closes. KODULAR FAIL
Any ideas?
Thank you
It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.
To get an image of your blocks, right click in the Blocks Editor and select “Download Blocks as Image”. You might want to use an image editor to crop etc. if required. Then post it here in the community.
@Norba_TIC You are correct and I confirmed it. The reason it was not happening for me is due to fact that I was using a companion that I had built that includes some updates to SQLite component. This issue will be addressed in next release.
Issue: The issue is with Toast property (below). You had this unchecked. For now, enable it (Supress Toast) and all should be okay. Use Event blocks to get runtime-result / status:
. We’ll address the Toast issue in upcoming release