PANTHEON™ manual

 Categories
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Collapse]Program
     [Expand]Document Types
     [Expand]Reports in PANTHEON
      Document Texts
      Delivery Methods
     [Expand]Loyalty Cards
     [Expand]Administration Panel
     [Expand]Dashboard Components
      Dashboard Reports
      Ad-hoc analysis
     [Expand]ARES
      SQL urejevalnik
    [Expand]Documentation
    [Expand]Change User
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Expand]User Manuals for PANTHEON
[Expand]PANTHEON Web
[Expand]PANTHEON Granules
[Expand]User Site

Load Time: 765.6513 ms
print   |
Label

SQL Editor

 

Here you can run SQL queries and export query results. It is also possible to execute multiple SQL statements, each result is then displayed in separate TAB.

Open a new SQL Editor window (form)
Open a new tab for a new query
Script: delete/update/insert (the tab that opens is used for statements other than the classic (select) query)
Retrieve a saved query
Save a query from the currently open tab
Save all queries (from all tabs)
Data conversion
Export table (DBF, XML, VTD)
Export to Excel
Building SQL queries by clicking (CTRL+Q) (Querry Editor)
Start query (F5)
Cancel (start query)
Download the query to Ad-hoc analysis

 

 

Related topics:

SQL Editor

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