new Field(AppLocal.getIntString("label.prodname"), Datas.STRING, Formats.STRING, true, true, true)
);
Table table = new Table(
"PRODUCTS_COM",
new PrimaryKey("ID"),
new Column("PRODUCT"),
new Column("PRODUCT2"));
lpr = row.getListProvider(app.getSession(),
"SELECT COM.ID, COM.PRODUCT, COM.PRODUCT2, P.REFERENCE, P.CODE, P.NAME " +
"FROM PRODUCTS_COM COM, PRODUCTS P " +
"WHERE COM.PRODUCT2 = P.ID AND COM.PRODUCT = ?", filter);