-
- Command line
- Server Settings
- Webserver table
- Commands
- Session
- Authentication
- Custom authentication
- External authentication
- Basic authentication
- Token authentication
- Folder Security
- Data manipulation
- Read one record
- Read many records
- Write one record
- Write many records
- Delete one record
- Direct Page/DQL
- Page data definition
- Directory listing
- File handling
- Prism lists
- Data Defintions
- Get data definitions
- Create data Definitions
- Update data definitions
- Delete data definitions
- Definition format
- run dql
- run script
- A web page
- Page definition
- DQL pages
- Single file/memo DQL
- Single file/memo Page
- LiveText tags
- Url commands
- Tags
- How data is triggered in a page
- .end
- .form header
- .form trailer
- .items
- assign
- application status
- backup db
- begin transaction
- break
- call menu
- call program
- case
- cluster by
- commit
- connect
- copy all from
- data-entry
- db status
- delete records
- define
- disconnect
- do
- documents
- exec SQL
- else
- end
- enter a record
- error messages off
- error messages on
- exit
- export
- for
- global
- if
- import
- imports
- in
- input using
- install application
- into
- list records
- lock
- lock db
- modify records
- message
- named
- others
- prompt
- query selection
- record entry
- records
- reorganize
- restore db
- rollback
- run procedure
- servers
- temp
- then
- tran off
- tran on
- unclustered
- unlock
- unlock db
- via form
- while
- with
- abs
- acos
- addressof
- ampm
- anylookup
- asin
- atan
- atan2
- ceil
- CHR
- concat
- ConsoleCopy
- ConsoleMemoCopy
- ConsoleShow
- ConsoleWriteToFile
- cos
- cosh
- date
- DatePicker
- day
- DEOS
- DialogOpen
- DialogOpenRelated
- DocumentCloseName
- DoesObjectExist
- ExecDQL
- ExecuteFile
- exp
- FileExecDQL
- firstc
- firstlast
- firstw
- FixedWidth
- floor
- futurevalue
- GetCurrent
- GetVar
- hours
- if
- installment
- jointext
- julian
- lastc
- lastfirst
- lastw
- length
- log
- log10
- lower
- MemoChunk
- MemoCopy
- MemoDecodePair
- MemoExecDQL
- MemoFind
- MemoGetGlobal
- MemoLength
- MemoMemoCopy
- MemoMemoReplace
- MemoReadFromFile
- MemoReplace
- MemoSetGlobal
- MemoStringBetween
- MemoStringFrom
- MemoStringTo
- MemoWordCount
- MemoWriteToFile
- midc
- midw
- minutes
- mod
- month
- OpenForm
- OpenMenu
- OpenProcedure
- OpenReport
- periods
- power
- presentvalue
- proper
- random
- rate
- RefreshForm
- RefreshScreen
- RefreshStatus
- Remote
- Remote authentication
- Remote POP3
- Remote IMAP
- Remote SMTP
- Remote XML
- seconds
- SetColor
- SetCurrent
- SetFocus
- SetLabelText
- SetMemoValue
- SetState
- SetStyle
- SetValue
- SetVar
- sin
- sinh
- spellcurrency
- spelldate
- spellmonth
- spellnumber
- spellweekday
- sqrt
- StringBetween
- StringEscape
- StringFind
- StringFrom
- StringReplace
- StringTo
- tan
- tanh
- textpos
- timeampm
- ToText
- UniqueID
- upper
- Wait
- weekday
- WriteToFile
- year
- yearday
- yearweek
- " (quotation marks)
- () (parentheses)
- + (addition)
- , (comma)
- - (subtraction)
- . (period)
- -- (comment)
- / (division)
- * (multiplication)
- * (asterisk)
- ? (question mark)
- ~ (tilde)
- : (colon)
- := (assignment operator)
- ; (semicolon)
- < (less than)
- <= (less than or equal to)
- = (equals)
- > (greater than)
- >= (greater than or equal to)
- all
- all files
- and
- any
- between
- blank
- count
- count of
- file
- highest of
- in groups
- in groups with group-totals
- in order
- in reverse
- item (Statistical)
- item (Conditional Statistical)
- lock files
- lock nothing
- lock records
- lookup
- lowest of
- max
- mean
- mean of
- min
- not
- number
- numeric string
- or
- pause
- percent
- selected record
- std.dev.
- std.err.
- sum
- sum of
- text
- time
- to
- variance
- window
- @GetDefinition
- . document
- . listcommands
- . listdocuments
- . listdrives
- . listfiles
- . listfunctions
- . listinternals
- . listoperators
- . listrelated
- . listtables
- . object
- . table
- . testdql
- @SetDefinition
- . document
- . object
Tags
The page tags are the one starting with [% and ending with %]. There are used for manipulating what is loaded into the page. To most used is [%body%] that must be present in templates for them to work.
body The tag telling a template where to insert the page code. Can be placed anywhere in a template but there must not be more than one. Ex [%body%] element Load and execute this element. Ex [%element /elements/sidemenu.html%] elementcache Load and calculate this element only the first time it is loaded. After this it will only returned the calculated value as a text element.
Ex [%elementcache /elements/sidemenudql.html%]elementcase Load one of these elements based on the livetext paramter. If none match the list one can be used as default by using defaul: as key.
Ex. [%elementcase user.level high:/elements/highheading.html medium3:/elementsmedium3userheading.html :/elements/notloggedinheading.html default:/elements/therestheading.html%]elementif Load one or the other based on bool calculation. The format is [%elementif boolcalulation trueresult falseresult%] but you can skip the result for false and only load on true. Then your format is [%elementif checktrue toloadiftrue%]
Checks supported:
- direct true/false | Ex. user.isloggedin if the value returned from live text is any case of "true", "yes" or "1" then we have a success
- livetext[operator]livetext
- livetext[operator]blank for a dataease blank check
- livetext[operator]number for a numeric test. To get a number you have to start with -0123456789
- livetext[operator]"string" for a direct string test
[operator] can be >, >=, <, <=, =, == and !=. We have = and == for equal as datease user use = for equal and the developers are used to ==. The tests are case insensitive to High=high is true.
Ex. [%elementif user.isloggedin /elements/headingloggedin.html /elements/headingnotloggedin.html%] can be used to load a login dialog if not logged in and show your name and a logout link if you are.
Ex. [%elementif user.username="ulrik" /elements/ulriksmenu.html /elements/normalmenu.html%] let you test on a hard coded string to get a named persons special menu.