仓位审核时报错
金蝶云社区-bj李超
bj李超
0人赞赏了该文章 1,079次浏览 未经作者许可,禁止转载编辑于2017年01月03日 21:33:31

仓位值集列表审核仓位时报错:错误编号: BOS_ExecuteNonQuery错误信息: 表“T_BAS_FLEXVALUESDETAIL”的 索引“IDX_BAS_FLEXVALUESDETAIL_U”在键列表中具有 80 个列。索引 键列列表的最大限制为 16。
Sql语句: IF NOT EXISTS (SELECT 1 FROM (SELECT SYSOBJECTS.NAME AS TABLE_NAME, SYSINDEXES.NAME AS INDEX_NAME FROM SYSOBJECTS INNER JOIN SYSINDEXES ON SYSINDEXES.ID = SYSOBJECTS.ID) AS KSQL_INDEXES WHERE INDEX_NAME = 'IDX_BAS_FLEXVALUESDETAIL_U')
BEGIN
CREATE UNIQUE INDEX IDX_BAS_FLEXVALUESDETAIL_U ON T_BAS_FLEXVALUESDETAIL (FF100011, FF100012, FF100013, FF100014, FF100015, FF100016, FF100017, FF100018, FF100019, FF100020, FF100021, FF100022, FF100023, FF100024, FF100025, FF100026, FF100027, FF100028, FF100029, FF100030, FF100031, FF100032, FF100033, FF100034, FF100035, FF100036, FF100037, FF100038, FF100039, FF100040, FF100041, FF100042, FF100043, FF100044, FF100045, FF100046, FF100047, FF100048, FF100049, FF100050, FF100051, FF100052, FF100053, FF100054, FF100055, FF100056, FF100057, FF100058, FF100059, FF100060, FF100061, FF100062, FF100063

请总部尽快给处理一下,我QQ:1092450624