adodc.recordstring="select * from b1 Join inner b2 as b2.id=b1.id"
解决方案 »
- 如何调用执行 另一个程序 的方法?
- vb 中的 sstab控件的颜色怎么改变,为什么都是默认的颜色啊
- TerminateProcess()函数在XP中不能实现吗?是我第二个参数有问题吗,我这是任意写的一个数.如何获得EXITCODE呢?
- 如何求没有输入焦点的按钮?
- 求教2000读进程!
- 写了个Excell宏的VBA小游戏,大家瞧瞧。
- 如何设置RECORDSET的CURSORTYPE属性?(在线等答案,解决给分!)
- 一个在VB中与ASP页面交互的问题
- 请问vb里面如何用代码建立一个临时表?将第一次查询的数据存储起来,再在这基础上进行二次查询?
- vb如何与mysql建立连接,最好能给个例子
- 关于VB连接ACESS数据库 来实现查询功能!
- 错误 BOF或EOF中有一个是真,或者但前的记录已被删除
'==========================================
Option Explicit
'Dim rstdh_codedict As ADODB.Recordset
Dim rstFind As ADODB.Recordset
Dim rstFind2 As ADODB.Recordset
Dim temp1 As ADODB.Recordset
Public main_ztname As String
Public main_path As String
Public Gcomputername As StringPublic MYCON As ADODB.ConnectionPrivate Sub Command1_Click() main_path = App.Path
main_ztname = main_path & "\MYDB.mdb"
Set MYCON = New ADODB.Connection
MYCON.CursorLocation = adUseClient
MYCON.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;data source=" & main_ztname & ";jet oledb:database password=828"
Set rstFind = New ADODB.Recordset
Set rstFind2 = New ADODB.Recordset
'暂停 rstFind.Open "select id,krz_id,xm,rq,jfje,DFJE into temp1 from krmxz", MYCON, adOpenStatic, adLockReadOnly
'暂停 rstFind2.Open "select id,krxm,krda_id from krz", MYCON, adOpenStatic, adLockReadOnly
'暂停 rstFind2.Open "select id,krxm,krda_id update temp1 from krz", MYCON, adOpenStatic, adLockReadOnly
rstFind2.Open "select * from krz inner join krmxz on krz.id =krmxz.id", MYCON, adOpenStatic, adLockReadOnly
rstFind.Open "select * from krmxz", MYCON, adOpenStatic, adLockReadOnly
ReportMod.Sections(3).Controls("text2").DataField = "dfje"
ReportMod.Sections(3).Controls("text2").Visible = True
ReportMod.Sections(3).Controls("text1").DataField = "krxm"
ReportMod.Sections(3).Controls("text1").Visible = True
ReportMod.Sections(3).Controls("text3").DataField = "fh"
ReportMod.Sections(3).Controls("text3").Visible = True
ReportMod.Sections(3).Controls("text4").DataField = "rq"
ReportMod.Sections(3).Controls("text4").Visible = True
Set ReportMod.DataSource = rstFind
ReportMod.Show'显示报表窗体
End Sub'==========================================看能不能帮我改改代码,谢谢。
下面为我的代码: Dim rstFind As ADODB.Recordset
Public main_ztname As String
Public main_path As String
Public MYCON As ADODB.ConnectionPrivate Sub Command1_Click()
Dim SqlStr As String
main_path = App.Path
main_ztname = main_path & "\MYDB.mdb"
Set MYCON = New ADODB.Connection
MYCON.CursorLocation = adUseClient
MYCON.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;data source=" & main_ztname & ";jet oledb:database password=828"
Set rstFind = New ADODB.Recordset SqlStr = "select * from krmxz LEFT JOIN (select * from krz) as krz on krz.id =krmxz.id" '关键是这一句 rstFind.Open SqlStr, MYCON, adOpenStatic, adLockReadOnly
Set ReportMod.DataSource = rstFind
With ReportMod
ReportMod.Sections(3).Controls("text2").DataField = "dfje"
ReportMod.Sections(3).Controls("text2").Visible = true
ReportMod.Sections(3).Controls("text1").DataField = "krxm"
ReportMod.Sections(3).Controls("text1").Visible = True
ReportMod.Sections(3).Controls("text3").DataField = "fh"
ReportMod.Sections(3).Controls("text3").Visible = True
ReportMod.Sections(3).Controls("text4").DataField = "rq"
ReportMod.Sections(3).Controls("text4").Visible = True
End With
ReportMod.Show
End Sub
'=================================================现在有新的问题了,如果是在两个不同的数据库中的表进行查询操作,如何处理了。 "select * from AA表 LEFT JOIN (select * from BB表) as BB表 on BB表.id =AA表.id" 关键还是这一句如何改了。假如说AA库是在数据库mydb.mdb中,BB表在mydb2.mdb中
就肯定不是上面这句语句了。请各位指教。。QQ:40218719