Difference between revisions of "EDT:Code snippets"

NumberOfWeeks Int;

const NUMBEROFDAYS INT = 7;

myInt Int[]?;

 record CUSTOMER type Entity{@table{name = "CUSTOMER"}}
     NAME string
     COUNTRY string{@id};
     STATE string?;
     CUSTID string;
 end

 function getCust{id String in} returns (Customer)
     ds SQLDataSource?{@resource {}};
     aCust Customer;
     get aCust from ds using(id);
     return (aCust);
 end

 function addCust{customer Customer in}
     ds SQLDataSource?{@resource {}};
     add customer to ds;
 end

 function loopCust()
     ds SQLDataSource?{@resource{bindingkey = "MyDB"}};
     rs SQLResultSet?;
 
     open rs from ds with #sql{
	SELECT * FROM CUSTOMER
     };
 
     myCust Customer;
 
     //Loop through results and write out customer name
     while(rs.setNext())
        get myCust from rs;
        Syslib.writeStdOut (Customer name: " + myCust.name);
     end
 
 end