static void RMTODBCConnection(Args _args)
{
LoginProperty loginProperty;
ODBCConnection odbcConnection;
Statement statement;
ResultSet resultSet;
ResultSetMetaData resultSetMetaData;
Counter counter;
;
loginProperty = new LoginProperty();
loginProperty.setDSN("Test"); // Datasource name for the Axapta database
odbcConnection = new ODBCConnection(loginProperty);
statement = odbcConnection.createStatement();
resultSet = statement.executeQuery("select * from CustTable");
resultSet.next();
resultSetMetaData = resultSet.getMetaData();
for (counter=1; counter <= resultSetMetaData.getColumnCount(); counter++)
{
switch (resultSetMetaData.getColumnType(counter))
{
case 0,1 :
info(resultSet.getString(counter));
break;
case 3 :
info(date2StrUsr(resultSet.getdate(counter)));
break;
}
}
}
{
LoginProperty loginProperty;
ODBCConnection odbcConnection;
Statement statement;
ResultSet resultSet;
ResultSetMetaData resultSetMetaData;
Counter counter;
;
loginProperty = new LoginProperty();
loginProperty.setDSN("Test"); // Datasource name for the Axapta database
odbcConnection = new ODBCConnection(loginProperty);
statement = odbcConnection.createStatement();
resultSet = statement.executeQuery("select * from CustTable");
resultSet.next();
resultSetMetaData = resultSet.getMetaData();
for (counter=1; counter <= resultSetMetaData.getColumnCount(); counter++)
{
switch (resultSetMetaData.getColumnType(counter))
{
case 0,1 :
info(resultSet.getString(counter));
break;
case 3 :
info(date2StrUsr(resultSet.getdate(counter)));
break;
}
}
}