SQL Query
Access
imos Ribbon : Main data > Main data > Element Manager > Output
Organizer > Tab Element Manager > Output
General Information
SQL queries can be entered. They define with which information the tables is filled.
Explanation of the SQL Statements via the example "All parts"
SELECT
NAME1 AS Partname,
MATID AS Material,
FLENG AS Length,
FWIDTH AS Width,
FTHK AS Thickness
FROM IDBGPL
WHERE
ORDERID='<<IMOSORDERID>>'
ORDER BY Partname
| SELECT | The Select Statement is required to select data from a database, e.g. for output. | |
| NAME1 AS Partname, | The entry from the field NAME1 is applied to enter it in the column Partname. |
NAME1 = Name of the part The name of the part results from the part type. Only for the output file support |
| MATID AS Material, | The entry from the field MATID is applied to enter it in the column Material. |
MATID = Clear indication for the material. This indication corresponds with the column NAME in the material table MAT.dbf. |
| FLENG AS Length, | The entry from the field FLENG is applied to enter it in the column Length. |
FLENG = Length in mm (finished dimension) |
| FWIDTH AS Width, | The entry from the field FWIDTH is applied to enter it in the column width. |
FWIDTH= Width in mm (finished dimension) |
| FTHK AS Thickness | The entry from the field FTHK is applied to enter it in the column Thickness. |
FTHK= Thickness in mm (finished dimension) |
| FROM IDBGPL | All previous named fields are in the table IDBGPL. | |
| WHERE ORDERID='<<IMOSORDERID>> | Searches for the order number | <<IMOSORDERID>> is a placeholder and is filled with the current name by imos . |
| ORDER BY Partname | Sorted by part names. |