![]() |
#13 |
Участник
|
X++: { ODBCConnection odbc ; Statement statement; ResultSet res; str queryText; FolioConnectionParameters_NV folioConnectionParameters = FolioConnectionParameters_NV::find(); LoginProperty loginProperty; ; loginProperty = new LoginProperty(); loginProperty.setUsername(folioConnectionParameters.UserName); loginProperty.setPassword(folioConnectionParameters.UserPassword); loginProperty.setServer (folioConnectionParameters.ServerName); loginProperty.setDatabase(folioConnectionParameters.Database); odbc = new ODBCConnection(loginProperty); if(odbc) { statement = odbc.createStatement(); queryText = strfmt("SELECT * FROM SCL_ARTC"); odbc.ttsbegin(); res = statement.executeQuery(queryText); res.next(); info(strfmt("%1 %2", res.getString(1), res.getString(2))); odbc.ttscommit(); } } |
|