DG3 Books
  • Book list
  • Authors
  • Need new password
  • Login
  • 01. Introduction
    • About DG3
    • Redirect directories
  • 02. Components
    • Preview browser
    • Page designer
    • DQL editor
    • Application wide settings
    • Security settings
    • Page caching module
    • Modules
    • Snippets
    • Actions
    • Context editor
    • Task editor
    • Scheduler editor
    • Search engine editor
    • Web server console
    • Site layout editor
    • Template editor
    • Robots editor
    • Style definitions
    • Database manipulation
    • Table designer
    • Transfer editor
    • Reporter
    • Deployment module
    • Deployment server settings
    • Debugger
  • 03. Command reference
    • .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
  • 04. Functions reference
    • 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
  • 05. Operators reference
    • " (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
  • 06. Queries and livetext
    • Rules for queries
    • * (asterisk)
    • ? (question mark)
    • ~ (tilde)
    • and
    • or
    • not
    • ( ) (parentheses)
    • Debug querys
    • Livetext tags
    • xdg3 query
    • Sessions
    • Pagination
    • Free text search
  • 07. Field snippets
    • Intro on fields
    • Text
    • Hidden
    • Date
    • Dropdown
    • List
    • Checkbox
    • Radio button
    • Text edit
    • Redactor (richtext)
    • CKEditor
    • TinyMCE
  • 08. Extentions
    • About extentions
    • Modules
    • PayEx payment
    • PayPal extension
  • 09. Pages, templates and CSS
    • New page
    • Delete a box from the page
    • Create editable subforms
    • New template
    • New css
  • 10. Custom code
    • Create custom transfer
    • Evaluation of transfer data values
    • Custom view code
  • 11. Custom Defined Functions
    • Intro to CDFs
    • How to create CDFs
    • Creating CDF with parameters
  • 12. DataEase Bus
    • DEBus intro
    • Bustalk
  • 13. Web connect methods
    • Intro
    • hasPrismConnection
    • doAction
    • doDerivation
    • doMenuItem
    • doPrismDerivation
    • setFormField
    • runPrismFunction
  • 22. DEOS
    • @GetDefinition
    • . document
    • . listcommands
    • . listdocuments
    • . listdrives
    • . listfiles
    • . listfunctions
    • . listinternals
    • . listoperators
    • . listrelated
    • . listtables
    • . object
    • . table
    • . testdql
    • @SetDefinition
    • . document
    • . object
  • Appendix A HTML
    • Intro to HTML
  • Appendix B CSS
    • Intro to CSS
  • Appendix C Javascript
  • Appendix D Python
    • Intro to Python
    • Debug app in PyDev
    • Right tab order in pydev
  • Appendix F internals
    • Global setting
    • deploy.conf
    • page.form
  • Appendix G External
    • Extra modules intro
    • python
    • Qt
    • wkhtmltopdf
    • PySide
    • PyXCC
    • django
    • Apache
    • LightTPD
    • nginx
    • pywin32
    • flup
    • cssutils
    • Pillow
    • psutil
    • mysqldb
    • psycopg2
    • pyodbc
    • python_dateutil
    • requests
    • suds-ews
    • setuptools
    • Whoosh
    • wmi
    • django-send
    • bootstrap
    • bootstrapmultiselect
    • jquery
    • jqueryui
    • ckedit
    • tinymce
    • redactor
    • JavaScript EU VAT Number Validation
    • feedparser
    • beautifulsoup
    • appsdir
    • six
    • pycparser
    • pyOpenSSL
    • cryptography
    • cffi
    • enum34
    • pyasn1
    • idna
    • ipaddress
    • PyYAML
    • coverage
    • coveralls
    • docopt
    • mock
    • funcsigs
    • pbr
    • nose
    • paypalrestsdk
    • paypal
    • libcurl
    • 7zipcpp
    • cef
    • cpp-jwt
  • Appendix H Web servers
    • Intro for web servers
    • Generating config params
    • lighttpd setup
    • Setting up DG3 on IIS
    • Setting up plain IIS to serve files
    • SSL certificates converting
  • Appendix I DEDS
    • Using DEDS with DG3

List