查询科目明细帐的时提示错误代号"9" 下标越界.
- 浏览：1158 - 发布时间：2007-07-26 10:41:00.0
| 问题版本: |
49-用友通标准版10.1PLUS2 |
问题模块: |
1-总账 |
| 所属行业: |
0-通用 |
问题状态: |
1-UU通注册用户 |
| 关 键 字: |
下标越界 |
适用产品: |
用友通 |
| 补 丁 号: |
|
开放状态: |
0-UU通注册用户 |
| 原问题号: |
|
提交时间: |
2007-7-26 10:41:00 |
| 问题名称: |
查询科目明细帐的时提示错误代号"9" 下标越界. |
| 问题现象: |
查询科目明细帐的时提示错误代号"9" 下标越界. |
| 原因分析: |
执行如下脚本 if exists (select * from sysobjects where name='temp_GL_myoutput') drop table temp_GL_myoutput go select cauth into temp_GL_myoutput from GL_myoutput group by cauth,cfieldnum having count(*)>1 go delete from GL_myoutput where cauth in (select cauth from temp_GL_myoutput) go insert into GL_myoutput select * from UFDATA_999_2006..GL_myoutput where cauth in (select cauth from temp_GL_myoutput) go drop table temp_GL_myoutput |
| 解决方案: |
执行如下脚本 if exists (select * from sysobjects where name='temp_GL_myoutput') drop table temp_GL_myoutput go select cauth into temp_GL_myoutput from GL_myoutput group by cauth,cfieldnum having count(*)>1 go delete from GL_myoutput where cauth in (select cauth from temp_GL_myoutput) go insert into GL_myoutput select * from UFDATA_999_2006..GL_myoutput where cauth in (select cauth from temp_GL_myoutput) go drop table temp_GL_myoutput | |
