iGarment Wiki

User Tools

Site Tools

Trace:
en:db_api

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:db_api [2026/06/03 09:52] – administratoren:db_api [2026/06/05 07:14] (current) – administrator
Line 1: Line 1:
-====== Datebase API ======+====== Database API ======
  
 ===== iGarment API: Query ===== ===== iGarment API: Query =====
Line 36: Line 36:
 Example, single SQL Example, single SQL
  
- { 
    select orderNo from saomstr where issdate >= '2024-05-15' limit 2 into t_Filter;    select orderNo from saomstr where issdate >= '2024-05-15' limit 2 into t_Filter;
    select a.orderno, a.issdate, b.style, b.description from SAOMSTR a inner join t_Filter o on o.OrderNo = a.OrderNo inner join SAOSTYLE b on b.OrderNo = a.OrderNo    select a.orderno, a.issdate, b.style, b.description from SAOMSTR a inner join t_Filter o on o.OrderNo = a.OrderNo inner join SAOSTYLE b on b.OrderNo = a.OrderNo
- } 
  
 Return data Return data
en/db_api.1780480329.txt.gzip · Last modified: by administrator