ADO API Reference

'--------------------------2006.5.29--------------------------

Dim InitlistBoxFlag As Boolean

'Read  Alarm File And Write Alarm To Table

'msdn=microsoft developed network

'Language Reference Manual.pdf
Input # filenumber, variablelist

'---------------------------2006.5.31---------------------

Lcase/Ucase
Trim/Ltrim/Rtrim

'sub,function,dim????

'---------------------------2006.6.2---------------------
InStr
Right/Left
Len

Open filename$ [For mode] [Access access] As [#]filenumber
Line Input #filenumber, name
Input(n , [ #]filenumber )

'---------------------------2006.6.5---------------------
Array()
string = Mid(strgvar,begin,length)
Space[$] (number )

On Error GoTo ErrorHandler
....
ErrorHandler:
...

ByRef ByVar

'---------------------------2006.6.6-----------------------
While
...
Wend

Do while ...
..
Loop

'---------------------------2006.6.7------------------------
Like(SQL)

'--------------------------2006.6.8--------------------------
Select Case testvar
 Case var1
  Statement Block
 Case var2
  Statement Block
 Case Else
  Statement Block
End Select

'---------------------------2006.6.9------------------------
'分页程序（ASPS）
ADODB.RecordSet
ADODB.Connention
'--------------------------2006.6.12------------------------
SELECT select_list
[ INTO new_table ]
FROM table_source
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]

'-----------------------2006.6.14---------------------------
connection.Open ConnectionString, UserID, Password, Options
recordset.Open Source, ActiveConnection, CursorType, LockType, Options

RecordSet.field.item()

'-----------------------2006.6.16---------------------------
'ADO API Reference

ADO Object
 Command
 Connection
 Recordset
 Error

ADO Methods
 rs.AddNew
 obj.Close
 CreateObject
 rs.MoveLast/MoveNext/MoveFirst
 cnn.Open/rs.Open
 rs.Update
        cmd.Execute/cnn.Execute
 Query
------------------------2006.6.20-----------------------------
AMADAS LogOn.pxd/test.pxd/AlarmOverView.pxd
SQLServer/Mytest/..
msdn.com/ConnectionString