Package com.ipc.oce.query

Examples of com.ipc.oce.query.OCQueryResult

434
435
436
437
438
439
440
441
442
443
444
      case OCType.OCT_REF_ENUM: {
        res = new OCEnumRef(object);
        break;
      }
      case OCType.OCT_QUERY_RESULT: {
        res = new OCQueryResult(object);
        break;
      }
      case OCType.OCT_ARRAY: {
        res = new OCArray(object);
        break;
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
   
    // set parameters
    query.setParameter("NUM_A", new OCVariant(number));
    query.setParameter("DATE_A", new OCVariant(docDate));
   
    OCQueryResult result = query.execute();
    OCQueryResultSelection selection = result.choose();
    OCDocumentRef ref = null;
    if (selection.next()) {
      ref = new OCDocumentRef(selection.getObject(0));
    } else {
      ref = emptyRef();
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
275
    OCApp instance = OCApp.getInstance(getAssociatedSessionID());
    OCQuery query = instance.newQuery("SELECT Doc.Ref FROM Document." + managerName + " AS Doc WHERE Doc.Number = &NUM_A");
   
    query.setParameter("NUM_A", new OCVariant(number));
   
    OCQueryResult result = query.execute();
    OCQueryResultSelection selection = result.choose();
    int selectionSZ = selection.size();
    List<OCDocumentRef> refList = new ArrayList<OCDocumentRef>(selectionSZ);
    while (selection.next()) {
      refList.add(new OCDocumentRef(selection.getObject(0)));
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
 
  @Test
  public void getResultAndUnload() throws JIException {
    QueryTemplate qt = new QueryTemplate(app);
    OCQueryResultSelection selection = qt.queryForSelection("SELECT * FROM Catalog.Валюты");
    OCQueryResult result = selection.getOwner();
    OCValueTable vt = result.unload();
    assertTrue(vt.size() > 0);
    OCValueTableColumnCollection vtCC = vt.getColumns();
    int vtCCSZ = vtCC.size();
    assertTrue(vtCCSZ > 0);
    System.out.println(vt.size());
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
217
    catSel.next();
    OCCatalogRef orgRef = catSel.getRef();
   
    query.setParameter("Организация", new OCVariant(orgRef));
   
    OCQueryResult result = query.execute();
    OCValueTable table = result.unload();
    System.out.println(table.listColumns());
   
    OCStructure structure = app.newStructure();
    structure.insert("ТаблицаДанных", table);
   
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
 
  public boolean execute() throws SQLException {
    ResultSet rSet = null;
    boolean res = false;
    try {
      OCQueryResult result = getOceStatement().execute();
      rSet = new OCEResultSet(result, this);
      if (rSet != null) {
        res = true;
        lastVisitedResultSet = rSet;
      }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
 
  public ResultSet executeQuery(String query) throws SQLException {
    ResultSet rSet = null;
    try {
      oceStatement.setText(query);
      OCQueryResult result = oceStatement.execute();
      rSet = new OCEResultSet(result, this);
      lastVisitedResultSet = rSet;
    } catch (JIException e) {
      throw new SQLException(e.toString());
    }
View Full Code Here
TOP

Related Classes of com.ipc.oce.query.OCQueryResult

  • com.ipc.oce.jdbc.OCEPreparedStatement
  • com.ipc.oce.jdbc.OCEStatement
  • com.ipc.oce.junit.JUReport01
  • com.ipc.oce.junit.UnloadResultSetToLocal
  • com.ipc.oce.objects.OCDocumentManager
  • com.ipc.oce.OCObject
  • com.ipc.oce.OCValueTable
  • com.ipc.oce.OCValueTree
  • com.ipc.oce.OCVariant
  • com.ipc.oce.varset.EQueryResultIteration
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.