-
- 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
Webserver table
This is where you can load pages from if you not uses files. The webserver table can hold templates, pages, elements and dqls.
Field Type Description ID text 10 A sequence field that are required, read only, indexed and unique. Usually set with derivation: sequence from "ELM00001" Type text 10 The different types of server documents. Supported types are Base, Page, Element, DQL and Setting Name text 52 The name of the document. This is used when looking up templates, elements and dqls Url text 255 The url used looking up pages. Can have several section and can end with a * to catch all and manage the rest as parameters. Security choice What security to use on a page. Can have values None, Low3, Low2, Low1, Medium3. Medium2, Medium1 and High and is the same as levels in DataEase except for None that let you show the page to users not logged in as well. Template text 52 The name of template to use with page SupportQuery Yes/No Tell if page support the DataEase query as first after ? or not. If not the part between ? and & will be converted to a key value pair that can be used as data-enty or as a lookup paramameter in dql using DEOS("@getserverinfo","parameters", key). Default is Yes meaning that the first parameter between ? and & is a DataEase query and not a query parameter. SupportParameters choice What type of query paramters are supported. Can be none, dataentry, sorting, dataentry and sorting, no definition and all. Default is all. This is to limit what users can add to the url to manipulate what comes back from the server. By setting dataentry, only the paramters supported by you underlying dql can be run and not json=1 to list data instead of html. Can be used at the end of development to lock down ways to look into inner working of your application. Code memo the code for the entry [TimeStamp] text 14 A readonly time stamp for the document that can be used to see what version of a document is newer. Ex. dirivation used: concat(Year(current date),if (Month(current date)<10,concat("0",Month(current date)),Month(current date)),if (Day(current date)<10,concat("0",Day(current date)),Day(current date)),if(Hours(current time)<10,concat("0",Hours(current time)),Hours(current time)),if(Minutes(current time)<10,concat("0",Minutes(current time)),Minutes(current time)),if (Seconds(current time)<10,concat("0",Seconds(current time)),Seconds(current time)))