DG3 Books
  • Book list
  • Authors
  • Need new password
  • Login
  • 01. Intro
    • About server
    • LegEasy Connect
    • Dev server
    • Live Server
    • DERun
  • 02. Getting started
    • Hello world
    • Call script after startup
    • Using tools
    • Your own template
  • 03. Server
    • Command line
    • Server Settings
    • Commands
    • Session
    • Authentication
    • Custom authentication
    • External authentication
    • Folder Security
  • 04. Manipulate data
    • 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
  • 05. Web pages
    • 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
  • 06. Forms
    • Form goals
    • Auto form
    • Setting up autoform
    • A single form
    • Form with subform
    • Form actions
    • About Update
  • 07. DataEase Connect
    • 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
  • 08. jsBridge
    • 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
  • 09. DataEase common
    • About decommon.js
    • The loader
    • calccaretpos
    • decodequery
    • generateid
    • insertitem
    • loadfilelist
    • loadfile
    • loadinternals
    • message
    • rundql
    • runpage
    • savefile
    • selectitem
    • testdql
    • version
  • 10. Form editor
    • Intro
    • Element types
    • Insert rules
    • insert info element
    • Sidebar automation
    • Insert new element<br>
  • 21. Commands
    • .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
  • 22. Functions
    • 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
  • 23. Operators
    • " (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
  • 32. DEOS
    • @GetDefinition<br>
    • . document
    • . listcommands
    • . listdocuments
    • . listdrives
    • . listfiles
    • . listfunctions
    • . listinternals
    • . listoperators
    • . listrelated
    • . listtables
    • . object
    • . table
    • . testdql
    • @SetDefinition
    • . document
    • . object
  • Apendix A Technical details
    • Charactes sets
    • Minimal prism
  • Apendix B. Demo app
    • About demo
    • Web server mode
    • List addressees
    • Edit address
    • Orders start
  • Apendix C Externals
    • Intro
    • LibSourcey
    • libuv
    • nlohmann
    • OpenSSL
    • win-acme

displayerrormsg