Appendix: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
 
(32 intermediate revisions by 3 users not shown)
Line 17: Line 17:
vbOK, vbCANCEL
vbOK, vbCANCEL
|-
|-
| String || vbCR, vbCRLF, vbFORMFEED, vbLF, vbNEWLINE, vbNULLCHAR, vbTAB, vbNULLSTRING, vbVERTICALTAB
| 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, AppEXEName, NSBCurrentForm, NSBFramework
| Global || [[NSBVersion]], AppBuildStamp, AppLegalCopyright, AppVersion, AppTitle, [[NSBCurrentForm|NSB.currentForm]], [[NSB.cacheStatus]], NSB.jqxSettings
|}
|}


Line 32: Line 32:
| Error Handling || [[try...catch|Try...Catch]]
| 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]]
| 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|JavaScript]], [[print|Print]], [[sleep|Sleep]], [[sql|SQL]], [[waitcursor|WaitCursor]]
| 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]]
| Structure || [[function|Function]], [[sub|Sub]]
|-
|-
| Variables || [[const|Const]], [[dim|Dim]], [[erase|Erase]], [[option|Option]], [[explicit|Explicit]], [[private|Private]], [[public|Public]], [[redim|ReDim]], [[rem|Rem]], [[set|Set]]
| Variables || [[const|Const]], [[dim|Dim]], [[erase|Erase]], Option, Explicit, Private, Public, [[redim|ReDim]], [[set|Set]]
|}
|}


=== Functions ===
=== 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 ===
=== Operators ===


 
{| class = "wikitable"
 
|-
=== Controls ===
| 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 (&)
|}

Latest 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 (&)