frdfsnlght/aix-sqlite

AppInventor extension for SQLite

aix-sqlite's Issues

Online SQL database

I'm a little bit confused. Is this extension strictly for local SQL database useage? Can it connect to an external MySQL server, or just update from it?

How to customize the separator and use mode (like .mode json)?

Thanks for this great extension.

Is it possible to customize the separator use in a select query or to use a specific mode (I have seen the properties "ReturnColumnNames" but it doesn't return a list of lists so it's still difficult to parse the result)?

Thanks!

Export DB error - simple fix

On new file API ExportDatabase/ImportDatabase/ExecuteFile/InsertFile do not work due to improper handling of filenames in resolveFileName.
The workaround to use application specific directory looks SIMPLE: remove all resolveFileName and have user create proper filename.

Any update?

Hi, your extensions worked extremely well until Android 10 came.
Do you plan any update?
Or have an idea how to import files on Android 10+?

Am ready to pay a fee for such update.

Thank you very much.

Problem with transactions

Begintransaction works but when I try an insert or an insert async the app hangs.
If I open a transaction and commit or rollback I don't have problem but of course nothing happened.
If I start transaction after the first one the app also hangs.

Select blocks not returning proper lists, only text in brackets

When using with the SQLiteTest.aia project , Select blocks return a list of string not a list of lists.

Example: When executing "select name, updates from months" return a list of 11 rows, but each row should be a list of two items (name and updates) but its a text in brackets "[January, 0]".

Is this normal ?, because according to docs it should return a list of lists, between "( )" . Checking the source code, AppyBuilder uses Yaillist for normal list but the sql query returns an ArrayList,

Hope you can help me, Thanks.

Execute script error

when I tried to run the bulk of query to create a table and insert only the first line executed and ignore the rest (insert commands)

Problem with list of lists

I’m trying to add a list of items that are the result of a select via SQLite, but an invalid arguments error appears. Have you tried using the shape of the image below? Below are two images, one of the code blocks and another with the designer.

I need to do it this way because I want to define what will appear inside the ‘listview’ for future modifications. For example, if I do a ‘select’ and return me 2columns name, type, but I want the list to include only name.

I know that return is a list of lists, but I can not adapt.

https://imgur.com/GamYmBY