OpenConn(db_type, db_path,db_version, db_name, db_user, db_pass) | 打开数据库连接 |
CloseConn() | 关闭数据库连接 |
Query(ByRef sTable,ByRef sFileds,ByRef sWhere,ByRef sOrder,ByRef sGroup,ByRef sCursorType,ByRef sLockType) | 查 - 返回Recordset对象 |
Add(ByRef sTable,ByRef sFileds,ByRef sValues) | 增 - 返回id |
Edit(ByRef sTable,ByRef sFileds,ByRef sValues,ByRef sWhere) | 改 - 返回状态 |
Del(ByRef sTable,ByRef sWhere) | 删 - 返回状态 |
AutoId(ByRef TableName) | 自动ID |
SqlQuery(ByRef sTable,ByRef sFileds,ByRef sWhere,ByRef sOrder,ByRef sGroup) | sql语句查询 |
SqlAdd(ByRef sTable,ByRef sFileds,ByRef sValues) | sql语句添加 |
SqlEdit(ByRef sTable,ByRef sFileds,ByRef sValues,ByRef sWhere) | sql语句修改 |
SqlDel(ByRef sTable,ByRef sWhere) | sql语句删除 |
SqlExecute(ByRef sql) | sql语句执行 |
CreateAccess(ByRef db_name) | 创建Access数据库 |
CompactAccess(ByRef db1,ByRef db2) | 压缩Access数据库 |