PilotFish Interface Exchange (PIE)

A marketplace for eiConsole (IDE) interface templates, components and industry bundles
eiConsole IDE 90-Day Free Trial!
Prerequisites
The eiConsole IDE is highly recommended to support graphical development of interfaces for deployment to the eiPlatform runtime The eiPlatform is required to run in production interfaces configured using the eiConsole
Version
eiConsole 10.13R1
Release Date
October 19, 2012
Resource Type
Tutorial

Product details

SQLXML - Inserting and Updating Rows
(eiConsole III - Training & Interface)

Prerequisite

A full or Trial License of the eiConsole (Download a 90-Day Trial Now!). Completion of Level I Training.

Synopsis

This interface and related tutorials demonstrate and explain the use of SQLXML, a database-agnostic, XML-based language used in the eiConsole to query and update databases. In this tutorial we expand on SQLXML basics and introduce the "Update" and "Insert" instructions for updating and inserting rows.

Core Concepts:

  • Databases
  • SQLXML Basics
  • SQLXML "Insert"
  • SQLXML "Update"

How to Use This Example

Download the interface using the Free Download button under the eiConsole Interface logo.

Note: if you are not logged in to the eiConsole, or have arrived at this page via a browser, you will be prompted to login before the interface downloads into your eiConsole "PIE" inbox.

Note: If you have not downloaded and installed a FREE Trial you will have the opportunity to register via a simple process after you click the Free Download button.. Once you are logged in the interface will automatically download into your "PIE" inbox.

Next, download one of the tutorials on this page (from the right column) and walk through it step-by-step. You may check your work against the provided Route (Sample Data).