Appendix: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
m →‎Controls: Fixed link.
(11 intermediate revisions by the same user 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]]
| Global || [[NSBVersion]], AppBuildStamp, AppLegalCopyright, AppVersion, AppTitle, [[NSBCurrentForm|NSB.currentForm]], [[NSB.cacheStatus]], NSB.jqxSettings
|}
|}


Line 34: Line 34:
| 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...end 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]]
Line 51: Line 51:
| 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]]
| 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]], [[format|FormatCurrency]], [[format|FormatDateTime]], [[format|FormatNumber]], [[format|FormatPercent]], [[space|Space]], [[escape|Unescape]]
| 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]]
| Input/Output || [[inputbox|InputBox]], [[msgbox|MsgBox]]
Line 71: Line 71:
|-
|-
| String || Concatenation (&)
| String || Concatenation (&)
|}
=== Controls ===
{| class = "wikitable"
|-
| [[Audio]] || Play sounds.
|-
| [[Checkbox|CheckBox]] || One or more checkboxes in a column.
|-
| [[Combobox|ComboBox]] || Displays a picker for different values.
|-
| [[Button|CommandButton]] || Standard command button.
|-
| [[Grid]] || Displays data in a table.
|-
| [[Htmlview|HTMLView]] || Displays HTML formatted table.
|-
| [[Image]] || Displays an image file.
|-
| [[Label]] || Standard Label.
|-
| [[Menu]] || Displays a list of items to go to.
|-
| [[Multiinput|MultiInput]] || One or more input feilds in a column.
|-
| [[Button|OptionButton]] || Displays one or more mutually exclusive choices.
|-
| [[PictureBox]] || General purpose object for buttons, pictures, text and graphics.
|-
| [[Textarea|TextArea]] || Multi line input field.
|-
| [[Textbox|TextBox]] || Single line input field.
|-
| [[Titlebar|TitleBar]] || Top bar on screen. Can include buttons.
|-
| [[Video]] || Display video that is part of the app or on a website.
|}
|}

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