clsdatabaseset.cls

一个ERP系统可以用来学习之用

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "clsdatabaseset"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Public Function in_db(ByVal table As String) As Boolean
    mydb.opendb
    
    sqlstmt = "select * from " + Trim(table) + ""
    
    Dim isexe As Boolean
    Dim rstable As ADODB.Recordset
    in_db = mydb.exesql(sqlstmt, rstable, False)
    
    mydb.closedb
    
End Function

Public Sub delete(ByVal table As String)
      mydb.opendb
      
      sqlstmt = "delete from " + Trim(table) + ""
      
      Dim isexe As Boolean
      Dim rstable As New ADODB.Recordset
      
      isexe = mydb.exesql(sqlstmt, rstable, True)
      mydb.closedb
         
End Sub