rowid 无效,求救,谢谢! 本帖最后由 wrhclone 于 2010-11-08 09:10:20 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --in要用括号update fisheruser.message set read =1 where rowid in(‘AAAVKUAAAAAHOKWAAa;ABAVKUAMAAAHOKWAAa’) update fisheruser.message set read =1 where rowid in(‘AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa’) [code=SQL]--你用的括号也是中文的,要用英文的括号update fisheruser.message set read =1 where rowid in('AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa')[/code] update fisheruser.message set read =1 where rowid in('AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa'); 三处错误,一是in要用括号,二是in的分隔符中逗号不是分号,三是in中的值列表如下是字符串,那每个值是独立的字符串,用单引号标识出来,而不是所有的值放在一起做为一个字符串。update fisheruser.message set read =1 where rowid in (‘AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa’)代码应当如下:string strsql = "update fisheruser.message set read =1 where rowid in (";boolean isfirst = true ;for(int i=0;i<= this.datagridviewSms.Rows.Count-1,i++){ if(this.datagridviewSms.Rows[i].Cells[5].Value.ToString()==0) { this.datagridviewSms.Rows[i].Cells[5].Value = "1"; if(!isfirst) { strsql += ","; isfirst = false; } strsql += "'" + this.datagridviewSms.Rows[i].Cells[6].Value.ToString() + "'"; }}strsql += ")";oraclecommand cmd = new oraclecommand(strsql, m_sqlcon);cmd. ExecuteNOnQuery(); update fisheruser.message set read =1 where rowid in('AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa') 字段类型为NUMBER(10)时1与10000占的存储空间一样吗 关于数据库约束的意义? OCCI查询时getstring不能获取长字符串 求救~~~ 向大家请教一个SQL(4) DBA_AUDIT_XXXX这些表是做什么的 关于rowid的问题。来看看 如何在window 2000下用oracle9i手工创建数据库(不用助手) 对备份的数据进行查询?? 如何先disable 外键约束再enable它? 如何得到EXIT 的返回值 数据库连接类型
update fisheruser.message set read =1 where rowid in(‘AAAVKUAAAAAHOKWAAa;ABAVKUAMAAAHOKWAAa’)
update fisheruser.message set read =1 where rowid in('AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa')[/code]
update fisheruser.message set read =1 where rowid in('AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa');
三处错误,一是in要用括号,二是in的分隔符中逗号不是分号,三是in中的值列表如下是字符串,那每个值是独立的字符串,用单引号标识出来,而不是所有的值放在一起做为一个字符串。
update fisheruser.message set read =1 where rowid in (‘AAAVKUAAAAAHOKWAAa','ABAVKUAMAAAHOKWAAa’)代码应当如下:
string strsql = "update fisheruser.message set read =1 where rowid in (";
boolean isfirst = true ;
for(int i=0;i<= this.datagridviewSms.Rows.Count-1,i++)
{
if(this.datagridviewSms.Rows[i].Cells[5].Value.ToString()==0)
{
this.datagridviewSms.Rows[i].Cells[5].Value = "1";
if(!isfirst)
{
strsql += ",";
isfirst = false;
}
strsql += "'" + this.datagridviewSms.Rows[i].Cells[6].Value.ToString() + "'";
}
}
strsql += ")";
oraclecommand cmd = new oraclecommand(strsql, m_sqlcon);
cmd. ExecuteNOnQuery();