PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Collapse]Getting Started
     Dictionary of terms
     First steps with PANTHEON
    [Expand]Using PANTHEON at Tecta, a fictional company
    [Expand]Instructions for Ensuring Compliance of PANTHEON with SAS
    [Expand]PANTHEON Installation
    [Expand]PANTHEON System
    [Collapse]PANTHEON Basics
     [Expand]Entering PANTHEON
     [Collapse]PANTHEON windows and forms
      [Expand]PANTHEON windows
      [Collapse]PANTHEON forms
        Form header
       [Expand]Form
        Form central part
       [Collapse]Toolbar
         Navigation Buttons
        [Collapse]Templates Menu
          Form Authorizations
          Mandatory fields
          Copying settings to users
          Show Object Names
          Reset Window Layout
          Reset Table Layout
          Scale Window Contents
         [Collapse]Edit Template
           Use SQL sentence in value
           Variables for Dates in Templates
           Using Variables for Dates in Templates
          Review SQL queries
        [Expand]Wizards Menu
        [Expand]Reports
        [Expand]Import/Export Data
         Help
        Search by
     [Expand]Entering data and navigating across PANTHEON
     [Expand]Instructions for PANTHEON
    [Expand]PANTHEON Help
    [Expand]Materials and Goods Movements
    [Expand]Assigning Identifiers
    [Expand]Frequently asked questions about Pantheon (F.A.Q.)
    [Expand]Archive
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 484.3282 ms
"
   1000738 | 200774 | 342829 | Updated
Label

Using a SELECT statement in a value

Use select statement in the Value field

010379.gif 010380.gif 010381.gif 010411.gif 010382.gif 010383.gif

 

When we want to describe a dataset using SQL, we write a SELECT statement.. The SELECT statement contains a complete description of the dataset that we want to get from the database.

In the Edit templates window, we enter the desired SELECT statement into the Value field in the lower section Set object values.

We have defined a simple SELECT statement for the item field:

When using the template, the program will input the result of the SELECT statement to the item criterion:

In the Items register, we have item LARA3 with the name TENT LARA 3:

 

RELATED TOPICS:

Edit templates

Templates

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!