static void dbODBCConnection(Args _args)
{
LoginProperty loginProp;
ODBCConnection conn;
Resultset resultSet, resultSetCount;
Statement statement1, statement2;
;
loginProp = new LoginProperty();
loginProp.setServer('name');
loginProp.setDatabase(‘Database name');
conn = new ODBCConnection(loginProp);
statement1 = conn.createStatement();
resultSet = statement1.executeQuery("SELECT * from CustTable where DATAAREAID = ‘CEU’");
while (resultSet.next())
{
info(resultSet.getString(1));
}
}
{
LoginProperty loginProp;
ODBCConnection conn;
Resultset resultSet, resultSetCount;
Statement statement1, statement2;
;
loginProp = new LoginProperty();
loginProp.setServer('name');
loginProp.setDatabase(‘Database name');
conn = new ODBCConnection(loginProp);
statement1 = conn.createStatement();
resultSet = statement1.executeQuery("SELECT * from CustTable where DATAAREAID = ‘CEU’");
while (resultSet.next())
{
info(resultSet.getString(1));
}
}
No comments:
Post a Comment