主键ID怎么给

zyygod

如图，主键ID是DK_CHTC_FID字段，但是这个主键不是自己生成的，而是别的地方生成的。那么概念这边主键默认值和主键关系应该怎么填...并且页面bizData在aotuLoad查询数据库的时候SELECT  DK_CHTC.BZ AS BZ, DK_CHTC.CGYT AS CGYT, DK_CHTC.CHDW AS CHDW, DK_CHTC.DKMJ AS DKMJ, DK_CHTC.fID AS DK_CHTC, DK_CHTC.EAST AS EAST, DK_CHTC.FCREARTPSNFID AS FCREARTPSNFID, DK_CHTC.FCREATORDEPTCODE AS FCREATORDEPTCODE, DK_CHTC.FCREATORDEPTID AS FCREATORDEPTID, DK_CHTC.FCREATORDEPTNAME AS FCREATORDEPTNAME, DK_CHTC.FCREATOROGNCODE AS FCREATOROGNCODE, DK_CHTC.FCREATOROGNID AS FCREATOROGNID, DK_CHTC.FCREATOROGNNAME AS FCREATOROGNNAME, DK_CHTC.FCREATORPSNCODE AS FCREATORPSNCODE, DK_CHTC.FCREATORPSNID AS FCREATORPSNID, DK_CHTC.FCREATORPSNNAME AS FCREATORPSNNAME, DK_CHTC.FCREATTIME AS FCREATTIME, DK_CHTC.FLASTUPDATEPSN AS FLASTUPDATEPSN, DK_CHTC.FLASTUPDATEPSNID AS FLASTUPDATEPSNID, DK_CHTC.FLASTUPDATETIME AS FLASTUPDATETIME, DK_CHTC.FREMARK AS FREMARK, DK_CHTC.FREMARK1 AS FREMARK1, DK_CHTC.FREMARK2 AS FREMARK2, DK_CHTC.FREMARK3 AS FREMARK3, DK_CHTC.FSFHF AS FSFHF, DK_CHTC.ND AS ND, DK_CHTC.NORTH AS NORTH, DK_CHTC.OBJECTID AS OBJECTID, DK_CHTC.RKRY AS RKRY, DK_CHTC.RKSJ AS RKSJ, DK_CHTC.RKZT AS RKZT, DK_CHTC.SHAPE AS SHAPE, DK_CHTC.SOUTH AS SOUTH, DK_CHTC.SSXZDM AS SSXZDM, DK_CHTC.SZFW AS SZFW, DK_CHTC.SZXZ AS SZXZ, DK_CHTC.TCLX AS TCLX, DK_CHTC.WEST AS WEST, DK_CHTC.WYRY AS WYRY, DK_CHTC.WYSJ AS WYSJ, DK_CHTC.XMQKID AS XMQKID, DK_CHTC.XZQDM AS XZQDM, DK_CHTC.XZQMC AS XZQMC, DK_CHTC.YWH AS YWH, DK_CHTC.VERSION AS version FROM DK_CHTC DK_CHTC  WHERE  (XMQKID = '2D13D1C907C84B18B044A303921E7471')，里面会有一个DK_CHTC.fID AS DK_CHTC，我ontology中根本没有fID这个字段，导致查询出错...

jishuang

http://docs.wex5.com/bex5-server-question-list-10030/

zyygod

jishuang 发表于 2018-11-20 15:28
http://docs.wex5.com/bex5-server-question-list-10030/

按照帖子设置了。

1. 刷新数据失败！ ,
   
2. 执行KSQL出错, KSQL: SELECT DK_CHTC.* FROM DK_CHTC DK_CHTC WHERE ((XMQKID = '2D13D1C907C84B18B044A303921E7471') AND (DK_CHTC.XMQKID='2D13D1C907C84B18B044A303921E7471')) LIMIT 0, 20
   
3. --> sql: SELECT DK_CHTC.BZ AS BZ, DK_CHTC.CGYT AS CGYT, DK_CHTC.CHDW AS CHDW, DK_CHTC.DKMJ AS DKMJ, DK_CHTC.DK_CHTC_FID AS DK_CHTC, DK_CHTC.DK_CHTC_FID AS DK_CHTC_FID, DK_CHTC.EAST AS EAST, DK_CHTC.FCREARTPSNFID AS FCREARTPSNFID, DK_CHTC.FCREATORDEPTCODE AS FCREATORDEPTCODE, DK_CHTC.FCREATORDEPTID AS FCREATORDEPTID, DK_CHTC.FCREATORDEPTNAME AS FCREATORDEPTNAME, DK_CHTC.FCREATOROGNCODE AS FCREATOROGNCODE, DK_CHTC.FCREATOROGNID AS FCREATOROGNID, DK_CHTC.FCREATOROGNNAME AS FCREATOROGNNAME, DK_CHTC.FCREATORPSNCODE AS FCREATORPSNCODE, DK_CHTC.FCREATORPSNID AS FCREATORPSNID, DK_CHTC.FCREATORPSNNAME AS FCREATORPSNNAME, DK_CHTC.FCREATTIME AS FCREATTIME, DK_CHTC.FLASTUPDATEPSN AS FLASTUPDATEPSN, DK_CHTC.FLASTUPDATEPSNID AS FLASTUPDATEPSNID, DK_CHTC.FLASTUPDATETIME AS FLASTUPDATETIME, DK_CHTC.FREMARK AS FREMARK, DK_CHTC.FREMARK1 AS FREMARK1, DK_CHTC.FREMARK2 AS FREMARK2, DK_CHTC.FREMARK3 AS FREMARK3, DK_CHTC.FSFHF AS FSFHF, DK_CHTC.ND AS ND, DK_CHTC.NORTH AS NORTH, DK_CHTC.OBJECTID AS OBJECTID, DK_CHTC.RKRY AS RKRY, DK_CHTC.RKSJ AS RKSJ, DK_CHTC.RKZT AS RKZT, DK_CHTC.SHAPE AS SHAPE, DK_CHTC.SOUTH AS SOUTH, DK_CHTC.SSXZDM AS SSXZDM, DK_CHTC.SZFW AS SZFW, DK_CHTC.SZXZ AS SZXZ, DK_CHTC.TCLX AS TCLX, DK_CHTC.WEST AS WEST, DK_CHTC.WYRY AS WYRY, DK_CHTC.WYSJ AS WYSJ, DK_CHTC.XMQKID AS XMQKID, DK_CHTC.XZQDM AS XZQDM, DK_CHTC.XZQMC AS XZQMC, DK_CHTC.YWH AS YWH, DK_CHTC.VERSION AS version FROM DK_CHTC DK_CHTC WHERE (XMQKID = ?) AND (DK_CHTC.XMQKID = ?)
   
4. --> binds: [2D13D1C907C84B18B044A303921E7471, 2D13D1C907C84B18B044A303921E7471]
   
5. 编码：JUSTEP150210
   
6. 显示详细
   
7. 关闭
   

复制代码

KSQL放在数据库中执行是没问题的，但是SQL放在数据库执行报错。主要是多了一个DK_CHTC.fID AS DK_CHTC，因为我的ontology文件中根本就没有fID这个字段，所以报错，但是我不知道这个fID是从哪边来的。SQL里面把这一段去掉就能查出数据...

jishuang

主键不是fID看2楼发的链接中主键的设置啊

zyygod

jishuang 发表于 2018-11-20 16:30
主键不是fID看2楼发的链接中主键的设置啊

谢谢！已解决。问题出在：我这张表跟这个流程下的其他表不在一个库里面。必须要新建一个业务模块，然后在该流程下引用这张表。