Data Model:

_Datasource definition goes here_ _Filter definitions goes here (if any)_ _Update definitions goes here (if any)_ _Anything you want to add to the model_

Security

security is set through the security attribute in the tag. The application starts with a security definition attribute, allowing only users in the artists group to log in. In this case, the username of the user logging in must be a member of the "artists" group.

Element

The element of an application defines four different data types:

Sub-elements (only one can be applicable)

Element	Description
	Defines the data type
	Defines the XML source file
	Defines a comma-separated text file

Element

The element defines the database

Sub-elements

Element	Description
	The name of the database to connect to
	SQL statement to execute before data retrieval (optional)
	SQL statement used to retrieve data
	The main table of the application (optional)
	The key field of the main table (optional)

Data Stored in SQL Database

This is the most common solution for data-oriented applications. CDDataBase SELECT Artist, Title, Country FROM CD_Catalog The above model selects three data options (Artist, Title, Country) from the "CD_Catalog" table in the "CDDataBase" database. The number of rows returned in the result is unknown.

Data Stored in XML File

can read data from an XML file:

Example

CD Title TITLE Artist ARTIST Country COUNTRY Try it » This method stores data in an XML file on the server.

Data Stored in Text (Text) File

can read data from a text file:

Example

Title 1 Artist 2 Price 5 Try it » This method stores data in a text file on the server.

You Can Create a Database if Needed

If needed, you can create a database with : CDDataBase CREATE TABLE CD_catalog ( CD_Id INT IDENTITY, Title NVARCHAR(255), Artist NVARCHAR(255), Country NVARCHAR(255), Company NVARCHAR(255), Price NUMBER,Published INT) Enhance your rapid prototyping model!