太奇怪了。。。这个问题。。。。我是老山。快来帮帮忙!!!! 上次看到另外一个帖子上有相关内容。好像使用@@match_monitor_id或是##match_monitor_id。详细的我忘了。不过数据库里最好少用自动编号的字段。容易出错。也不好控制。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 baoxiang(包香):有什么好主意??快一点呀。。我等着用啊!! 这样行吗?? CnSql.open "insert into match_official(match_id,referee_id,assist_referee1_id,assist_referee2_id,official_no4_id) values(" & matchid & "," & Strcaipan & "," & Strdiyi & "," & Strdier & "," & Strdisi & ")" 一定有的。再找找吧。@@match_official_id没用吗? CnSql.Execute "insert into match_official(match_official_id,match_id,referee_id,assist_referee1_id,assist_referee2_id,official_no4_id) values(@@match_official_id," & matchid & "," & Strcaipan & "," & Strdiyi & "," & Strdier & "," & Strdisi & ")" 这种情况应该是在insert的时候键值没有赋值又不能为空造成的.查查你的自动编号项是不是设置对了?(数据类型,识别种子,递增量) set rs=cnn.Execute("select * from 你的数据表")rs.movelast "数据库的表match_official中有一个字段match_official_id她是自动编号的字段我要是执行cnsql.execute。就出错。提示:cannot insert the value null into column 'match_monitor_id',table 'football.dbo.match_official';column does not allow nulls. insert fails"不用给自动编号付值!!改成这个样子:CnSql.Execute "insert into match_official(referee_id,assist_referee1_id,assist_referee2_id,official_no4_id) values(" & Strcaipan & "," & Strdiyi & "," & Strdier & "," & Strdisi & ")"一定行的!我以前也遇到过! 有人帮我看看http://www.csdn.net/expert/topic/392/392672.shtm吗? 这是个什么错误???cannot insert explicit value for identity column in table 'match_official'when identity_insert is set to off VB怎么写HTTP头伪搜索来源 有关右击菜单的问题 请教excel生成图表显示的问题 文本文件导入到sql server出现的问题 一个简单问题,请高手帮忙。(给分50) 有谁做过SPC(统计过程控制系统) 如何制作一个可以检测POP邮箱信件的工具? 简单的问题 读取硬盘信息 VB有经典书吗?我是指那种advanced书 各位CSDN的同仁,有谁能向我讲解一下SQLDMO的概念及在VB中的用法。谢谢 在窗体中使用API SetFocus,提示参数错误或无效,为什么,使用其它API都正常。
CnSql.open "insert into match_official(match_id,referee_id,assist_referee1_id,assist_referee2_id,official_no4_id) values(" & matchid & "," & Strcaipan & "," & Strdiyi & "," & Strdier & "," & Strdisi & ")"
@@match_official_id没用吗?
CnSql.Execute "insert into match_official(match_official_id,match_id,referee_id,assist_referee1_id,assist_referee2_id,official_no4_id) values(@@match_official_id," & matchid & "," & Strcaipan & "," & Strdiyi & "," & Strdier & "," & Strdisi & ")"
查查你的自动编号项是不是设置对了?(数据类型,识别种子,递增量)
rs.movelast
她是自动编号的字段我要是执行cnsql.execute。就出错。
提示:cannot insert the value null into column 'match_monitor_id',table 'football.dbo.match_official';column does not allow nulls. insert fails"不用给自动编号付值!!改成这个样子:
CnSql.Execute "insert into match_official(referee_id,assist_referee1_id,assist_referee2_id,official_no4_id) values(" & Strcaipan & "," & Strdiyi & "," & Strdier & "," & Strdisi & ")"一定行的!我以前也遇到过!
cannot insert explicit value for identity column in table 'match_official'
when identity_insert is set to off