以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp)
--  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2)
----  datacolchange事件不触发  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=42409)

--  作者:longtechwj
--  发布时间:2013/11/11 10:05:00
--  datacolchange事件不触发
在载入数据之前我有改过列名,这个事件有执行过
但是我在修改行的数据之后这个事件就不触发了,
非实体表应该不影响的,以前没有遇到过这种情况
而且我特别把messagebox弹框写在
if e.DataCol.Name="...." then
end if
的外面还是没有触发,不知道是怎么了

--  作者:Bin
--  发布时间:2013/11/11 10:10:00
--  
是否是表达式列? 项目文件发上来看看, 新建一个项目是否有同样的问题?
--  作者:longtechwj
--  发布时间:2013/11/11 10:12:00
--  
其它的模块没有
--  作者:longtechwj
--  发布时间:2013/11/11 10:13:00
--  
....
图片点击可在新窗口打开查看此主题相关图片如下:qq截图20131111101122.jpg
图片点击可在新窗口打开查看

--  作者:longtechwj
--  发布时间:2013/11/11 10:16:00
--  
其实这个表的数据是我用union all动态构建的数据
--  作者:Bin
--  发布时间:2013/11/11 10:18:00
--  
如果是SQL查询表,也应该会有效果的. 最好能上个例子我测试分析一下.
--  作者:longtechwj
--  发布时间:2013/11/11 10:20:00
--  
这个是我的SQL语句
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'1#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'2#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'3#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'4#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'5#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'6#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'7#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'8#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'9#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'10#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'11#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'12#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'13#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'14#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'15#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'16#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'17#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'18#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'19#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013 UNION ALL
select \'AW130114-1\' As Job_No,\'603010-001721\' As Item_No,\'20#\' as Mach_No,0 As October_16Dayt2013,0 As October_17Dayt2013,0 As October_18Dayt2013,0 As October_19Dayt2013

--  作者:longtechwj
--  发布时间:2013/11/11 10:22:00
--  
....
图片点击可在新窗口打开查看此主题相关图片如下:qq截图20131111102112.jpg
图片点击可在新窗口打开查看

--  作者:Bin
--  发布时间:2013/11/11 10:24:00
--  
这个和SQL语句是无关的,你做个例子上来看看吧.
--  作者:longtechwj
--  发布时间:2013/11/11 10:53:00
--  
....
 下载信息  [文件大小:   下载次数: ]
图片点击可在新窗口打开查看点击浏览该文件:管理项目3.rar