X++:
CCADOConnection connection = new CCADOConnection();
CCADOCommand command = new CCADOCommand();
CCADORecordSet recordSet;
CCADORecordSet recordSetLine;
CCADOFields fields;
CCADOFields fieldsLine;
;
try
{
connection.open("Строка подключения");
command.activeConnection(connection);
command.commandText("SQL операторы");
recordSet = command.execute();
while (!recordSet.EOF())
{
fields = recordSet.fields();
info(fields.itemIdx(0).value());
recordSet.moveNext();
}
}
catch(Exception::Error)
{
throw error("Обработка прекращена.");
}