-
- Command line
- Server Settings
- Commands
- Session
- Authentication
- Custom authentication
- External authentication
- Basic authentication
- Folder Security
- Data manipulation
- Read one record
- Read many records
- Write one record
- 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
- About DataEaseConnect
- checkquery
- callbacksuccess
- clearrecord
- connectonfieldchange
- convertvaltonumber
- decodequery
- deletedata
- deletetdf
- displayerrormsg
- doaction
- ensurequry
- fetchrecord
- fetchrecords
- finddatatype
- findfieldindef
- formdata
- formdefs
- forminit
- forminitdone
- formloaded
- generateid
- getcookied
- getdata
- getelement
- getfield
- getmyhost
- getnumlines
- getrecordcontent
- getrecorddef
- getrecordnofromurl
- gettdf
- gettablefromurl
- istrueval
- login
- logout
- makenewline
- multirecordinit
- newdata
- newtdf
- rundql
- populateoneselect
- selectpopulate
- setcsrfheader
- setelement
- setfield
- singlerecordinit
- stringify
- stripsuffix
- updatedata
- updatetdf
- useisodatetime
- usenumber
- version
- About jsBridge.js
- Action names
- deCheckVersion
- DEOS
- getnumlines
- GetCurrent
- GetValue
- GetVar
- jsAction
- jsActionExt
- jsActionExt2
- jsAddClass
- jsDEOS
- jsDerivation
- jsDerivationDebug
- jsDocumentDelete
- jsDocumentEdit
- jsDocumentOpen
- jsExecDQL
- jsGetActiveDocState
- jsGetVar
- jsGetCurrent
- jsGetDocumentState
- jsGetValue
- jsGetPRISMValue
- jsHide
- jsInt21
- jsLiveText
- jsLog
- jsMemoExecDQL
- jsMenuItem
- jsNewBlankForm
- jsOpenAppCat
- jsPrismDerivation
- runPrismFunction
- jsRefreshDocuments
- jsReorganize
- jsReorganizeAll
- jsRemoveClass
- jsSetFixedValue
- jsSetVarFromField
- jsSetValue
- jsSetVar
- jsSetCurrent
- jsSetWebField
- jsSetWebFieldFromVar
- jsShow
- jsToggle
- jsToggleClass
- makenewline
- SetCurrent
- SetValue
- SetVar
- startdebugger
- About decommon.js
- The loader
- calccaretpos
- decodequery
- generateid
- insertitem
- loadfilelist
- loadfile
- loadinternals
- message
- rundql
- runpage
- savefile
- selectitem
- testdql
- version
- .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
LiveText tags
The LiveText tag can be used in any place that goes into a page generation engine. This is done in all templates, dql and page. The LiveText can be a single string or .-separated. When a single name the current context is what is looked up, when .-separated the global context is used. In the global context you have a lot of fixed name spaces to lookup. This document gives you all these.
app
name The repository name. Ex [{app.name}] path The repository path. Ex. [{app.path}]
server
The server context is all values global for the server this application is running on. Each LiveText lookes like [{server.thekey}]
dateformat The format used for dates. Ex. DD/MM/YYYY for international dates if the date separator is / datesep The separator used by DataEase when returning dates. Ex. 31/12/2017 the separator is / decimal The decimal separator used by DataEase when returning decimal numbers. Ex. 2 003,14 the decimal separator is , and the triplet is " " internaltime A internal time used by the server. It is a 64 bit value that counts in ns. timeformat The format used for time. Ex. HH:MM:SS if the time separator is : timesep The separator used by DataEase when returning time values. Ex. 14:15:16 the separator is : triplet The triplet separator used by DataEase when returning decimal numbers. Ex. 2 003,14 the decimal separator is , and the triplet is " " page
The page context is the current page rendered. This can be a dql or a page and any templates used for any of these share the current page context when rendered. This is why [{page.name}] in the title of a template gives different results for each page the template is used.
body The body that will be rendered when the page loads code The code to be executed when the page loads id The id where used for looking up the page. This can be used to load the page form the WebServer table into a editor. name The information found in .name at the top of the page security Security set on the page from None to High template Template used by the page. You can get the name, id, code and body by [{page.template.id}] etc. The template name is return when no extra parameter given. type The page type like Page, Element etc. url The registered url that well be used by a browser to locate the page. user
isloggedin yes/no if you are logged in or not level Level as text form high to low3 numlevel
Numeric level from 8 not logged in to 1 meaning high sessiondata sessionid Your session id used for the cookie set in your browser. This is the identifier for your session whether you are logged in or not username The name registered on the user. This is the same as the name in Users table timeout how long in ms to you session times out (0) is never. token The token used to identify posts, puts and deletes from browser to server. The information about the logged in user.
dqlerror
errorcode The numeric value returned by prism when running a dql. 0=DPE_SUCCESS, any other is a error code errorincode Show your 100 char of code with the ##*-> pointing to the position of the error in the code errormsg The text version of the error given by error code errorpos The position in the code where the error was discovered Error messages given by a dql run on a page. The format is [{dqlerror.val}] an will list problems running a dql in a page. Very useful to add on the main template when you are developing.
global
This will later be used for global shared values set in dqls.
session
Returns values regarding the currently loaded page an the environment it is loaded into. This holds all the query and parameters given in the url and the live url it self.
query Getting a query parameter by giving the query parameter name Ex. to get /listall?&field1=something you can use [{session.query.field1}] to return the value something url Get a url part by adding the numeric position 0 indexed of the url Ex. an url /list/user/all you can return all by [{session.url.2}]