这是最直接的方法,懒得去查sql功能 sub(rst as recordset,data1 as recordset) dim array1() as string dim i as integer i=0 rst.movefirst while not rst.recordset.eof array1(i)=cstr(rst[ID]) i=i+1 rst.movenext wend while not data1.recordset.eof if i<=data1.recordcount data1![str]=array1(i) i=i+1 end if data1.recordset.movenext wend end sub
更正: sub(rst as recordset,data1 as recordset) dim array1() as string dim i as integer i=0 rst.movefirst while not rst.eof array1(i)=cstr(rst[ID]) i=i+1 rst.movenext wend i=0 while not data1.recordset.eof if i<=data1.recordcount data1![str]=array1(i) i=i+1 end if data1.recordset.movenext wend end sub
我知道的SQL_SERVER是可以用一个SQL语句写的,你的问题无非是一个关联更新的问题 如 1. update table1 a SET A.FIELD1=B.FIELD1 FROM TABLE2 B WHERE A.ID=B.ID AND A.FIELD1<1002.update table1 a SET A.FIELD1=B.FIELD1 FROM (SELECT * FROM TABLE2 WHERE ....) B WHERE A.ID=B.ID AND A.FIELD1<100
sub(rst as recordset,data1 as recordset)
dim array1() as string
dim i as integer
i=0
rst.movefirst
while not rst.recordset.eof
array1(i)=cstr(rst[ID])
i=i+1
rst.movenext
wend
while not data1.recordset.eof
if i<=data1.recordcount
data1![str]=array1(i)
i=i+1
end if
data1.recordset.movenext
wend
end sub
sub(rst as recordset,data1 as recordset)
dim array1() as string
dim i as integer
i=0
rst.movefirst
while not rst.eof
array1(i)=cstr(rst[ID])
i=i+1
rst.movenext
wend
i=0
while not data1.recordset.eof
if i<=data1.recordcount
data1![str]=array1(i)
i=i+1
end if
data1.recordset.movenext
wend
end sub
比如select to_char(id) id1 ,name .....
rst=dbs.openrecordset(...)
set data1.recordset=rst
首先,我说的SQL语句做手脚指的是类似于
select to_char(id) id1 ,name ..... 这样一个语句,这是ORACLE的,你可以查一查ACCESS的转换类型函数,
如果有问题,可以联系我[email protected]
set data1.recordset=rst
你不是会吗?
所以我问的是怎样从rst中得到Data1.recorset,其中ID为String.
set data1.recordset=rstTemp
可是recordset就无法执行SQL语句吗?
我记得好象有.sql或.execute方法可以用啊?
但是细节不清楚了。
如
1.
update table1 a SET A.FIELD1=B.FIELD1 FROM
TABLE2 B WHERE A.ID=B.ID AND A.FIELD1<1002.update table1 a SET A.FIELD1=B.FIELD1 FROM
(SELECT * FROM TABLE2 WHERE ....) B
WHERE A.ID=B.ID AND A.FIELD1<100
这个问题好像很有年头了,现在还没解决吗?
如FlexGrid
select to_char(id,'99999990.00') id1 ...
这么写他想不对齐都难啊
rs.fields.add dd
do until rs.eof
rs.fields("dd")= trim(rs.fields("aa"))
rs.movenext
loop
'看看可不可以
(Integer---->String)