Generate SQL stored procedure for XCRI CAP 0.1.7.25

The purpose of this form is to map SQL database locations of course information to their XCRI CAP equivalents, generating a SQL stored procedure on submission of the form which will extract this data as XML.

This is still a prototype, with a number of limitations:

All the database objects, the course and presentation tables (or views), must currently reside in the same database that the stored procedure will be created in.
Little parsing or validation of database object names is done.
Only a small, but valid, subset of XCRI CAP 1.1 is handled.
All course information must come from the same table (or view). All presentation information must come from the same table (or view). Unless a method of joining new tables can be found, if data is scattered around, a preprocessing step of preparing appropriate course and presentation views may be necessary.

Databases Database to create stored procedure in: My stored procedure should be called:

XCRI CAP 1.1 mapping to SQL objects

Database table names should be of the form [schema].[table/view], where [schema] is optional. For example, [dbo].[tbl_Course]. You can leave out the square brackets if there are no problematic characters.

The first two text fields are for literal values for default provider properties.

catalog
- provider
  - identifier (literal string):
  - title (literal string):
  - course (table):
    - identifier (table!column): Note that the foreign key in the presentation table has to use the same column name as this (another current limitation).
    - title (table!column):
    - subject (table!column):
    - description: aim (table!column):
    - qualification
      - title (table!column):
      - level (table!column):
    - presentation (table):
      - identifier (table!column):
      - start (table!column):
      - studyMode (table!column):

Last updated: 2010-07-30.


	by Project


		Graphics


			Charting


			Heraldry