AppML Reference

## AppML Basic

AppML HOME AppML How To AppML Download AppML Architecture AppML Reference

## AppML Case Study

Case Intro Case Prototyping Case Models Case Templates Case Employees Case Customers Case Products Case Future

## Tutorials

WebSites

# <apppML> Reference

« Previous
Next Chapter »

## The <AppML> Data Model:

<appml security="security">
<datasource>
Datasource definition goes here
</datasource>
<filters>
Filter definitions goes here (if any)
</filters>
<update>
Update definitions goes here (if any)
</update>
<anything>
Anything you want to add to the model
</anything>
</appml>

## <AppML>Security

<AppML> security is taken care of by the security attribute in the <AppML> tag.

<appml security="artists">

An application starting with the security defined above, can only be run by a user logged as an artist.

In this context, the user must be logged in with a username defined as a member of the group "artists".

## The <datasource> Element

The <datasource> element defines the 4 different types of data sources an <AppML> application can have:

### Sub Elements (only one can apply)

Element | Description
--- | ---
<database> | Defines a database source
<xmlfile> | Defines an XML source file
<csvfile> | Defines a comma separated text file

## The <database> Element

The <database> element defines a database source.

### Sub Elements

Element | Description
--- | ---
<connection> | The name of a database connection
<execute> | SQL to be executed before data retrieval (optional)
<sql> | The SQL statement for retrieving data
<maintable> | The main table for this application (optional)
<keyfield> | The key field for the main table (optional)

## Data Stored in SQL Databases

This is the most common solution for data oriented applications.

<datasource>
<database>
<connection>CDDataBase</connection>
<sql>SELECT Artist, Title, Country FROM CD_Catalog</sql>
</database>
</datasource>

The model above selects three data items (Artist, Title, Country) from a table called "CD_Catalog", in an SQL database called "CDDataBase".

The number of rows returned is unknown.

## Data Stored in XML Files

<AppML> can read data from XML files:

## Example

<appml>
<datasource>
<xmlfile src="cd_catalog.xml">
<record>CD</record>
<item>
<name>Title</name>
<nodename>TITLE</nodename>
</item>
<item>
<name>Artist</name>
<nodename>ARTIST</nodename>
</item>
<item>
<name>Country</name>
<nodename>COUNTRY</nodename>
</item>
</xmlfile>
</datasource>
</appml>
Try it yourself »

This method makes it possible to store data in XML files on the server.

## Data Stored in Text Files

<AppML> can read data from text files:

## Example

<appml>
<datasource>
<csvfile src="cd_catalog.txt">
<item>
<name>Title</name>
<index>1</index>
</item>
<item>
<name>Artist</name>
<index>2</index>
</item>
<item>
<name>Price</name>
<index>5</index>
</item>
</csvfile>
</datasource>
</appml>
Try it yourself »

This method makes it possible to store data in Text files on the server.

## Create a Database if Needed

With <AppML> you can also create a database if needed:

<database>
<connection>CDDataBase</connection>
<execute>
CREATE TABLE CD_catalog (
CD_Id INT IDENTITY,
Title NVARCHAR(255),
Artist NVARCHAR(255),
Country NVARCHAR(255),
Company NVARCHAR(255),
Price NUMBER,Published INT)
</execute>
</database>

Perfect for rapid prototyping!

« Previous
Next Chapter »

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE