Commands

Jan Moxter edited this page Apr 17, 2015 · 7 revisions

#Commands

#Query Language

COMMAND := PRINT | INSERT | UPDATE | DELETE | EXECUTE

Print Command

Definition

PRINT := 'print' OBJECT 'select' SELECT 'order by' ORDER

###Example

Print the Object with OID 567.123 presenting the values for the Attributes "Name" and "Date"

print 567.123 select attribute[Name],attribute[Date]

Insert Command

Definition

INSERT := 'insert' 'type' TYPE 'set' UPDATE_ATTRIBUTE

Example

Insert a new Invoice and set the Name and Crosstotal:

insert type Sales_Invoice set Name = "001-00001", CrossTotal = 180.00

Update Command

Definition

UPDATE := 'update' OBJECT 'set' UPDATE_ATTRIBUTE

Example

Update the Object with OID 124.879 and set the Attribute Code to 22.

update 124.879 set Code=22

Update the Object with OID 124.879 and set values for the Attributes Code, Name and Level.

update 124.879 set Code="asdsd", Name="asdaddds",Level="welt"

Delete Command

Definition

DELETE:= 'delete' OBJECT;

Example

Delete the Object with OID 124.879.

delete 124.879

Execute Command

Definition

EXECUTE:= 'execute' | 'exec' ESJP PARAMETERS SELECT;

Example

Execute the ESJP org.efaps.demo.Test and get the returned values 1, 5 and 8.

'exec' org.efaps.demo.Test 'select' 1 as Key, 5 as Demo, 8 as etwas


Parts

ESJP

Name of a eFaps Stored Java Program.

ESJP := valid classname as defined by the Java Convention

PARAMETERS

Comma separated List of Numeric or String Parameters

PARAMETERS := NUM ',' STR

TYPE

Name of a type from eFaps like 'Sales_Invoice', 'Admin_User_Person' etc.

TYPE := ('A'..'Z') ('a'..'z' | 'A'..'Z' | '_')*

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.