你好 ,请问 vb + ado +sql 如何判断 表A 内 是否存在字段 abc 呢 ?
解决方案 »
- 进程通讯,wm_copydata,求解.
- 求VB5.0或VB6.0基础教程(电子书),谢谢!
- rdo
- 完蛋了!花了好长时间做完一套系统,测试中遇到重大问题!输入框无法接受:德语、法语等等小语种!
- 如何根據系統語言調用不同的res的多語言塊?
- 小问题
- 如何在程序中得到控件的所有接口
- 请问一下asp是不是不支持VB里的PRINTER对象,为什么调用不了的?十万火急!!!!
- 大神们,百分急求个urldecode.急死了,试了好多函数都不行,中文字符解码不出来.超感谢!
- CSDN参与分自动增加器下载 (可以把参与分兑换为可用分)http://home.dqt.com.cn/~jera/richincsdn.zip
- 给自己的账户转分,勿进!
- 求救:RecordSet 记录集的操作
Public Function IsExistField(TableName As String, FieldName As String) As Boolean
On Error GoTo err1
Dim SQL As String
SQL = "SELECT " & FieldName & " FROM " & TableName
Conn.execute SQL, , adcmdtext
IsExistField = True
Exit Function
err1:
Err.Clear
IsExistField = False
End Function
Dim i As Long
Set rst = conn.Execute(str_sql)
For i = 0 To rst.Fields.Count - 1
if rst.Fields(i).name="abc" then exit for
Next
SQL = "select 列名 from A where 列名='abc'"
rs.open SQL, conn, 1, 3
If Not rs.EOF Then
'你的代码
Else
'你的代码
End If
UPDATE ybtp200412, yb200412
SET yb200412.cql = ybtp200412.cql
WHERE ybtp200412.no = yb200412.no
SET a.cql = dbo.ybtp200412.cql
WHERE a.no=dbo.ybtp200412.no
SET yb200412.cql = ybtp200412.cql
WHERE ybtp200412.no = yb200412.no
不要样写UPDATE yb200412 a
SET a.cql = dbo.ybtp200412.cql
WHERE a.no=dbo.ybtp200412.no
SET a.cql = dbo.ybtp200412.cql
WHERE a.no = dbo.ybtp200412.no现在 俺就这样子执行了,它 提示 a 附近有 语法错误! 郁闷
SET yb200412.cql = (select cql from ybtp200412 where cql=yb200412.cql)
WHERE yb200412.no = (select no from ybtp200412 where no=yb200412.no)
UPDATE yb200412
SET yb200412.cql = (select cql from ybtp200412 where no=yb200412.no)
WHERE yb200412.no = (select no from ybtp200412 where no=yb200412.no)
试下这个:
表c1和C2种都是 ID,name 2个字段declare @id int,@name char(10)
DECLARE aa CURSOR FOR
SELECT * FROM c1
OPEN aa
FETCH NEXT FROM aa into @id,@name
WHILE @@FETCH_STATUS = 0
begin
declare @newname char(16)
set @newname=NULL
select @newname=c2.name from c2 where c2.id=@id
print @newname
if (not @newname is null)
begin
update c1 set c1.name=@newname where C1.id=@id
end
FETCH NEXT FROM aa into @id,@name
end
close aa
DEALLOCATE aa
go
where sysobjects.name='表名' and sysobjects.id=syscolumns.id ok le