groovy1

" import org.compiere.util.DB
 import groovy.sql.Sql
 import org.compiere.model.GridTab

int id = ((Integer)A_Tab.getValue("M_Requisition_ID")).intValue();

//    def sql = " select name  from m_product where m_product_id=? ";
//    String r  = DB.getSQLValueString(null, sql, [50002]  );
//    sql=Sql.newInstance('jdbc:sqlserver://127.0.0.1:1433;databaseName=compiere','compiere','compiere',
//    'com.microsoft.sqlserver.jdbc.SQLServerDriver' )
def str = "xxxxx---xxxxx";
sql=Sql.newInstance('jdbc:postgresql://127.0.0.1:5432/tg0924','adempiere', 'adempiere','org.postgresql.Driver' )
//sql.eachRow(
// 'select  p.name from adempiere.m_requisitionline l inner join adempiere.m_product p on p.m_product _id=l.m_product _id where _requisition_id=' + id )
//{ str = str +"$it.name "+"\n" }

GridTab m_tabParent = A_Tab.getParentTab();
m_tabParent .setValue("Help", str  )
m_tabParent.dataRefreshAll();

return """