--
You received this message because you are subscribed to the Google Groups "App Inventor Open Source Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to app-inventor-open-so...@googlegroups.com.
To post to this group, send email to app-inventor-o...@googlegroups.com.
Visit this group at http://groups.google.com/group/app-inventor-open-source-dev?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
>> email to app-inventor-open-source-dev+unsub...@googlegroups.com.
>> To post to this group, send email to
>> app-inventor-o...@googlegroups.com.
>> Visit this group at
>> http://groups.google.com/group/app-inventor-open-source-dev?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "App Inventor Open Source Development" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to app-inventor-open-source-dev+unsub...@googlegroups.com.
James,
Re SQLite component performance, performed a quick test. On employee table (columns: id, fk_id, name, ssn - see attached, replaced 10 with 1000):
- insert: 1,000 rows took about 9 seconds
I tested a little bit, great job! Your examples work fine!
I additionally tested using that example http://zetcode.com/db/sqlite/introduction/ and I found out that somehow transactions don't work?
In the screenshot you can see I first tried to RunQuery each statement separately and got a "false" back with the "end transaction" statement (I also tried "commit" instead of "end transaction")
Then I tried to execute the transaction in one block with the RunQuery block, this results in true but there are no records in the table?
Some "nice to have" features:
if there is a syntax error in the sql statement it would be nice to get some kind of error message back instead of only "false"...
for insert, update and delete statements it would be nice to get a message "n rows affected" back instead of only a "true" for the select statement it would be nice to define, if you like to get the header of the table back or not
again: great job!
Did a few lat, long selects based on a bounding box, nice ! This will open lots of doors.
https://plus.google.com/hangouts/_/bb533932dc31f91f7f42b985a9a0766331ef5861?authuser=0&eid=116831753302186936352&hl=en-GB
cheers,
José
--
You received this message because you are subscribed to the Google Groups "App Inventor Open Source Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to app-inventor-open-so...@googlegroups.com.
To post to this group, send email to app-inventor-o...@googlegroups.com.
Visit this group at http://groups.google.com/group/app-inventor-open-source-dev.
https://plus.google.com/hangouts/_/bb533932dc31f91f7f42b985a9a0766331ef5861?authuser=0&eid=116831753302186936352&hl=en-GB
cheers,
José
Please use the AILiveComplete forum for questions about that distribution. Thanks!
--------------------------------------------
mobile. brevity.typos.cheers
--
You received this message because you are subscribed to the Google Groups "App Inventor Open Source Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to app-inventor-open-so...@googlegroups.com.
To post to this group, send email to app-inventor-o...@googlegroups.com.
Visit this group at http://groups.google.com/group/app-inventor-open-source-dev.
For more options, visit https://groups.google.com/d/optout.