7,763
社区成员
发帖
与我相关
我的任务
分享
use db
update ***
insert ****
select A,B from t1
select C,D,E from t2
recordset.Open "select ***",ConnectorString, adOpenKeyset, locktype
dim sql as string
dim rs as adodb.recordset
sql="select A,B from t1; select C,D,E f……
rst.Movenext
dim sql as string
dim rs as adodb.recordset
sql="select A,B from t1; select C,D,E from t2"
set rs=new adodb.recordset
rs.open sql....
do until rs is nothing
do while not rs.eof
debug.? rs.field(0)
rs.movenext
loop
set rs= rs.nextrecordset '下一个记录集
loop
ub LeftRightJoinX()
Dim dbs As Database, rst As Recordset
' 在您的计算机中修改此行使其正确指到 Northwind 的路径。
Set dbs = OpenDatabase("Northwind.mdb")
' 选择所有单位,包含那些不含员工的单位。
Set rst = dbs.OpenRecordset _
("SELECT [Department Name], " _
& "FirstName & Chr(32) & LastName AS Name " _
& "FROM Departments LEFT JOIN Employees " _
& "ON Departments.[Department ID] = " _
& "Employees.[Department ID] " _
& "ORDER BY [Department Name];")
'移居记录集。
rst.MoveLast
' 调用 EnumFields 来打印 Recordset 的内容。
' 通过 Recordset 对象和需要的字段宽度。
EnumFields rst, 20
dbs.Close
End Sub