Welcome, Guest Login

Support Center

EXECUTE SQL

Last Updated: Jul 14, 2016 10:04AM EDT
Execute SQL


Introduction
'Execute SQL' is a Tutorial App which illustrates how to use the action 'Execute SQL Statement'

Install the app
If you don't have the ap installed in your workspace:
click here to automatically instal the Tutorial app 'Execute SQL'
 

App Overview
Execute SQL uses an On Device Local SQL Db to store a static value 'John Doe' to illustrate the use of a SQL statement.
In an actual app, you can replace the static value by a variable, the content of a feed or any value of your choosing.
Execute SQL local on device DB was created using Cloud Collection.
Cloud Collection lets you create a data structure which can then be turned into either a local SQL Databases or a live XML feed.

The most complex part is likely to set up the local DB than to set up the SQL statement!
We try to cover the App Data Architecture as thoroughly as possible, it is not that easy!
Don't hesitate to ask question, use the 'Ask Question' section at the end of this article.


SQL Statement

The SQL statement used in this demo app is in the Tap Event of the Text Bloc
'Add John Doe into Directory SQL DB'

 

The actual SQL statement

 

This statement insert a new value into the local database.
To understand how tables are named learn more on Execute SQL Statement here 

Help us improve! Rate this article:

Yes I found this article helpful

Ask a Question   

support@eachscape.com
http://assets0.desk.com/
false
eachscape
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete