Appendix: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
(36 intermediate revisions by 3 users not shown) | |||
Line 17: | Line 17: | ||
vbOK, vbCANCEL | vbOK, vbCANCEL | ||
|- | |- | ||
| String || vbCR, vbCRLF | | String || vbCR (carriage return \r), vbCRLF (carriage return + linefeed \n), vbLF (linefeed \n), vbTAB (tab \t), vbVERTICALTAB (vertical tab \v) | ||
|- | |- | ||
| VARTYPE || vbEMPTY, vbNULL, vbINTEGER, vbLONG, vbSINGLE, vbDOUBLE, vbCURRENCY, vbDATE, vbSTRING, vbOBJECT, vbERROR, vbBOOLEAN, vbVARIANT, vbDATAOBJECT, vbDECIMAL, vbBYTE, vbARRAY | | VARTYPE || vbEMPTY, vbNULL, vbINTEGER, vbLONG, vbSINGLE, vbDOUBLE, vbCURRENCY, vbDATE, vbSTRING, vbOBJECT, vbERROR, vbBOOLEAN, vbVARIANT, vbDATAOBJECT, vbDECIMAL, vbBYTE, vbARRAY | ||
|- | |- | ||
| Global || NSBVersion, AppBuildStamp, AppLegalCopyright, AppVersion, AppTitle, | | Global || [[NSBVersion]], AppBuildStamp, AppLegalCopyright, AppVersion, AppTitle, [[NSBCurrentForm|NSB.currentForm]], [[NSB.cacheStatus]], NSB.jqxSettings | ||
|} | |} | ||
== B. Specifications == | == B. Specifications == | ||
=== Statements === | |||
{| class = "wikitable" | |||
|- | |||
| Error Handling || [[try...catch|Try...Catch]] | |||
|- | |||
| Flow of Control || [[call|Call]], [[do...loop|Do...Loop]], [[exit|Exit]], [[for...next|For...Next]], [[for each...next|For Each...Next]], [[if...then...else|If...Then...Else]], [[select case|Select Case]], [[while...wend|While...Wend]], [[with...end with|With...End With]] | |||
|- | |||
| Other || [[debugger|Debugger]], [[execute|Execute]], [[html|HTML]], [[javascript...end javascript|JavaScript]], [[print|Print]], [[sleep|Sleep]], [[sql|SQL]], [[Style/End Style|Style]], [[waitcursor|WaitCursor]] | |||
|- | |||
| Structure || [[function|Function]], [[sub|Sub]] | |||
|- | |||
| Variables || [[const|Const]], [[dim|Dim]], [[erase|Erase]], Option, Explicit, Private, Public, [[redim|ReDim]], [[set|Set]] | |||
|} | |||
=== Functions === | |||
{| class = "wikitable" | |||
|- | |||
| Arithmatic|| [[abs|Abs]], [[asc|Asc]], [[atn|Atn]], [[cos|Cos]], [[exp|Exp]], [[fix|Fix]], [[int|Int]], [[log|Log]], [[rnd|Rnd]], [[round|Round]], [[sgn|Sgn]], [[sin|Sin]], [[sqr|Sqr]], [[tan|Tan]] | |||
|- | |||
| Conversion || [[conversions|Cbool]], [[conversions|Cbyte]], [[conversions|Ccur]], [[conversions|Cdate]], [[conversions|CDbl]], [[conversions|Chr]], [[conversions|Cint]], [[conversions|CLng]], [[conversions|CSng]], [[conversions|CStr]], [[hex|Hex]], [[oct|Oct]] | |||
|- | |||
| Date/Time || [[date|Date]], [[dateadd|DateAdd]], [[datediff|DateDiff]], [[dateserial|DateSerial]], [[date|Date]], [[datepart|DatePart]], [[day|Day]], [[hour|Hour]], [[minute|Minute]], [[month|Month]], [[monthname|MonthName]], [[now|Now]], [[second|Second]], [[time|Time]], [[timeserial|TimeSerial]], [[weekday|Weekday]], [[weekdayname|WeekdayName]], [[Year]] | |||
|- | |||
| Formatting || [[escape|Escape]], [[Formatting_Functions|FormatCurrency]], [[Formatting_Functions|FormatDateTime]], [[Formatting_Functions|FormatNumber]], [[Formatting_Functions|FormatPercent]], [[space|Space]], [[escape|Unescape]] | |||
|- | |||
| Input/Output || [[inputbox|InputBox]], [[msgbox|MsgBox]] | |||
|- | |||
| Other || [[eval|Eval]], [[settimeout|SetTimeOut]], [[sqlopendatabase|SQLOpenDatabase]], [[sysinfo|SysInfo]] | |||
|- | |||
| String Handling || [[filter|Filter]], [[Instr/instrrev|InStr]], [[Instr/instrrev|InStrRev]], [[join|Join]], [[lcase|LCase]], [[left|Left]], [[len|Len]], [[ltrim|LTrim]], [[mid|Mid]], [[replace|Replace]], [[right|Right]], [[rtrim|RTrim]], [[split|Split]], [[strcomp|StrComp]], [[strreverse|StrReverse]], [[string|String]], [[trim|Trim]], [[ucase|UCase]] | |||
|- | |||
| Variable Handling || [[array|Array]], [[Is (function)|IsArray]], [[Is (function)|IsDate]], [[Is (function)|IsEmpty]], [[Is (function)|IsNull]], [[Is (function)|IsNumeric]], [[Is (function)|IsObject]], [[lbound|LBound]], [[typename|TypeName]], [[ubound|UBound]], [[vartype|VarType]] | |||
|} | |||
=== Operators === | |||
{| class = "wikitable" | |||
|- | |||
| Arithmatic || Addition (+), Division (/), Exponentiation (^), Mod, Muliplication (*), Negation (-), Subtraction (-) | |||
|- | |||
| Boolean || [[and|And]], [[eqv|Eqv]], [[imp|Imp]], [[not|Not]], [[or|Or]], [[is (operator)|Is]], =, <, >, [[xor|Xor]] | |||
|- | |||
| String || Concatenation (&) | |||
|} |
Revision as of 14:30, 13 December 2016
A. Constants
Color | vbBLACK, vbRED, vbGREEN, vbBLUE, vbYELLOW, vbMAGENTA, vbCYAN, vbWHITE |
Comparison | vbBINARYCOMPARE, vbTEXTCOMPARE |
Date/Time | vbSUNDAY, vbMONDAY, vbTUESDAY, vbWEDNESDAY, vbTHURSDAY, vbFRIDAY, vbSATURDAY, vbFIRSTJAN1, vbFIRSTFOURDAYS, vbFIRSTFULLWEEK, vbUSESYSTEM, vbUSESYSTEMDAYOFWEEK |
Date Format | vbGENERALDATE, vbLONGDATE, vbSHORTDATE, vbLONGTIME, vbSHORTTIME |
MSGBOX | Display options (add to combine):
vbOKONLY, vbOKCANCEL |
Return values:
vbOK, vbCANCEL | |
String | vbCR (carriage return \r), vbCRLF (carriage return + linefeed \n), vbLF (linefeed \n), vbTAB (tab \t), vbVERTICALTAB (vertical tab \v) |
VARTYPE | vbEMPTY, vbNULL, vbINTEGER, vbLONG, vbSINGLE, vbDOUBLE, vbCURRENCY, vbDATE, vbSTRING, vbOBJECT, vbERROR, vbBOOLEAN, vbVARIANT, vbDATAOBJECT, vbDECIMAL, vbBYTE, vbARRAY |
Global | NSBVersion, AppBuildStamp, AppLegalCopyright, AppVersion, AppTitle, NSB.currentForm, NSB.cacheStatus, NSB.jqxSettings |
B. Specifications
Statements
Error Handling | Try...Catch |
Flow of Control | Call, Do...Loop, Exit, For...Next, For Each...Next, If...Then...Else, Select Case, While...Wend, With...End With |
Other | Debugger, Execute, HTML, JavaScript, Print, Sleep, SQL, Style, WaitCursor |
Structure | Function, Sub |
Variables | Const, Dim, Erase, Option, Explicit, Private, Public, ReDim, Set |
Functions
Arithmatic | Abs, Asc, Atn, Cos, Exp, Fix, Int, Log, Rnd, Round, Sgn, Sin, Sqr, Tan |
Conversion | Cbool, Cbyte, Ccur, Cdate, CDbl, Chr, Cint, CLng, CSng, CStr, Hex, Oct |
Date/Time | Date, DateAdd, DateDiff, DateSerial, Date, DatePart, Day, Hour, Minute, Month, MonthName, Now, Second, Time, TimeSerial, Weekday, WeekdayName, Year |
Formatting | Escape, FormatCurrency, FormatDateTime, FormatNumber, FormatPercent, Space, Unescape |
Input/Output | InputBox, MsgBox |
Other | Eval, SetTimeOut, SQLOpenDatabase, SysInfo |
String Handling | Filter, InStr, InStrRev, Join, LCase, Left, Len, LTrim, Mid, Replace, Right, RTrim, Split, StrComp, StrReverse, String, Trim, UCase |
Variable Handling | Array, IsArray, IsDate, IsEmpty, IsNull, IsNumeric, IsObject, LBound, TypeName, UBound, VarType |
Operators
Arithmatic | Addition (+), Division (/), Exponentiation (^), Mod, Muliplication (*), Negation (-), Subtraction (-) |
Boolean | And, Eqv, Imp, Not, Or, Is, =, <, >, Xor |
String | Concatenation (&) |