access数据库如何创建视图? 如下:mssql数据库成功创建的,access数据库怎么写呢?
''创建收款结算明细 视图的代码
Dim s As String="S.elect b.发生日期,b.往来单位,b.应收单号,b.单据类型,b.科目名称,b.科目代码 ,b.应收金额,b.已收金额,b.剩余金额,a.操作单单号,a.借贷方向,a.原始单类型,a.原始单单号,a.贷方本币 As 本次收款金额,a.备注 ,a._identify As _identify ,a.创建人,a.创建日期,a.编辑人,a.编辑日期 from {CW_会计凭证明细} a left join {CW_应收单} b on a.单据单号=b.应收单号" ' where a.操作单单号='" & r("收款单号") & "' and a.借贷方向='贷'"
Dim cmd As New SQLCommand
cmd.C
Dim sql As String
sql = " CREATE VIEW V_YW_收款结算明细 As " & s
cmd.CommandText =sql
output.show(cmd.ExecuteNonQuery())
cmd.CommandText ="S.ELECT count(*) FROM V_YW_收款结算明细"
output.show(cmd.ExecuteScalar)