'--------------------------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