• 遍历AOT表


     1 static void findStr(Args _args)
     2 {
     3     Dictionary     dictionary = new Dictionary();
     4     SysDictTable   dictTable;
     5     SysDictField   dictField;
     6     Common         common;
     7     int        i, j, _tableId, _fieldId;
     8    ;
     9     for (i = 1; i <= dictionary.tableCnt(); i++)
    10     {
    11         _tableId  = dictionary.tableCnt2Id(i);
    12         dictTable = new DictTable(_tableId);
    13         common    = dictTable.makeRecord();
    14         for (j = 1; j <= dictTable.fieldCnt(); j++)
    15         {
    16             _fieldId  = dictTable.fieldCnt2Id(j);
    17             dictField = new DictField(_tableId,_fieldId);
    18             if(dictField && !isSysId(_fieldId)
    19                && (dictField.baseType() == types::String  ||
    20                    dictField.baseType() == types::RString ||
    21                    dictField.baseType() == types::VarString) )
    22             {
    23                while select RecId from common where common.(_fieldId) like "*text*"
    24                {
    25                     info("tablename:" + dictTable.name()
    26                          + " fileldname:" + dictTable.fieldName(_fieldId)
    27                          + " recid:" + int642str(common.RecId));
    28                }//while
    29             }//If
    30         }//for
    31     }//for
    32 }//function
  • 相关阅读:
    三、Oracle 查询+where条件
    二、Oracle 数据库基本操作
    一、Oracle 安装
    18.JAVA经典编程题(50题及答案)
    17.网络编程
    16.xml
    Js模块化开发--seajs和gruntJs
    git命令行指南
    nodejs学习笔记---1
    面向对象及组件开发---笔记1
  • 原文地址:https://www.cnblogs.com/Jinnchu/p/2658895.html
Copyright © 2020-2023  润新知