Using SQLite in AI2LiveComplete?

[Francisco Pérez]

I am testing AI2LiveComplete and I do not undersand how to use the Component SQLite.

The possibilites of SQLite are only 3 types of blocks: display tables, drop tables and run queries.

For example I tried to CREATE a simple table, then to INSERT some values into that tables and SELECT some values from that tables using  the Run query instruction.

I don't know how to combine the blocks. I have Google for some code example I have found http://puravidaapps.com/sqlite.php, but it doesn't work for me.

The code to be used must be written within an empty text box after the runquery block? code if from SQLite3 version? for example from SQLite3 Manager firefox add-on?

Anybody have a working example for SQLite within AppInventor?

[M. Hossein Amerkashi]

This blog posting might help:

http://amerkashi.wordpress.com/2014/01/29/using-sqlite-component-with-listpicker/

--
For Java Bridge (sdkBridger), visit http://code.google.com/p/apptomarket/
---
You received this message because you are subscribed to the Google Groups "AppToMarket" group.
To unsubscribe from this group and stop receiving emails from it, send an email to apptomarket...@googlegroups.com.
Visit this group at http://groups.google.com/group/apptomarket.
For more options, visit https://groups.google.com/groups/opt_out.

[Kevin Blakely]

Francisco, I'm trying to figure this out myself. There are some examples that can get you started (search Hossein's blog) but they're pretty basic.

So I'm playing around with some test apps to understand how to better work with SQLite in AI2LiveComplete.

Need to store variables into the db and retrieve it back into variables

If ANYONE has examples of working apps using SQLite please share.

[M. Hossein Amerkashi]

What's your usecase? Provide description of what you like to accomplish

--
For Java Bridge (sdkBridger), visit http://code.google.com/p/apptomarket/
---
You received this message because you are subscribed to the Google Groups "AppToMarket" group.
To unsubscribe from this group and stop receiving emails from it, send an email to apptomarket...@googlegroups.com.
Visit this group at http://groups.google.com/group/apptomarket.

For more options, visit https://groups.google.com/d/optout.

[Kevin Blakely]

Hossein, I have a screen which accumulates data. This data would be date, time and 160 variables (all numbers). So I need to store these numbers in the table and recall then by date at a later time.

I have RazorSQL which is great for creating and testing queries. Just trying to work these into the SQL blocks.

Consider the following code:

INSERT INTO penguin_feed (date, ash_c, ash_s, ash_v, ash_m) VALUES (20150804, 10, 4, 1, 0)

How would this line be coded if the VALUES (20150804, 10, 4, 1, 0) were coming from variables, as in:

enter_date=20150804

var_ac=10

var_as=4

var_av=1

var_am=0

Wondering if this would work... or is there an easier way