-
- 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
- .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
- Rules for queries
- * (asterisk)
- ? (question mark)
- ~ (tilde)
- and
- or
- not
- ( ) (parentheses)
- Debug querys
- Livetext tags
- xdg3 query
- Sessions
- Pagination
- Free text search
- Intro on fields
- Text
- Hidden
- Date
- Dropdown
- List
- Checkbox
- Radio button
- Text edit
- Redactor (richtext)
- CKEditor
- TinyMCE
- Intro
- hasPrismConnection
- doAction
- doDerivation
- doMenuItem
- doPrismDerivation
- setFormField
- runPrismFunction
- @GetDefinition
- . document
- . listcommands
- . listdocuments
- . listdrives
- . listfiles
- . listfunctions
- . listinternals
- . listoperators
- . listrelated
- . listtables
- . object
- . table
- . testdql
- @SetDefinition
- . document
- . object
- 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
. listfunctions
List all function that can be called in DataEase in both derivations and DQLs.
Return a json with a noded named functions with a array of strings with all the functions that can be called.
Ex. strres := DEOS("@GetDefinition", "listfunctions")
{ "functions": [ "if", "jointext", "month", "day", "year", "yearday", "weekday", "yearweek", "date", "concat", "addressof", "spellcurrency", "spelldate", "spellmonth", "spellweekday", "spellnumber", "julian", "ceil", "floor", "hours", "minutes", "seconds", "timeampm", "ampm", "firstc", "lastc", "midc", "firstw", "lastw", "midw", "length", "textpos", "upper", "lower", "proper", "lastfirst", "firstlast", "presentvalue", "futurevalue", "installment", "rate", "periods", "exp", "log", "log10", "power", "sqrt", "sin", "cos", "tan", "asin", "acos", "atan", "atan2", "sinh", "cosh", "tanh", "Wait", "UniqueID", "CHR", "StringTo", "StringFrom", "StringBetween", "MemoStringFrom", "MemoStringBetween", "ExecDQL", "MemoExecDQL", "FileExecDQL", "MemoStringTo", "SetMemoValue", "SetLabelText", "MemoMemoReplace", "MemoSetGlobal", "MemoGetGlobal", "DoesObjectExist", "SetFocus", "SetState", "SetColor", "SetValue", "DatePicker", "FixedWidth", "DialogOpen", "DialogOpenRelated", "RefreshStatus", "SetStyle", "GetValue", "GetStyle", "LabelExecDQL", "OpenAsDialog", "MaxWin", "MinWin", "NormalizeWin", "IfMaxNormalize", "IfNormalMax", "IfMaxMin", "IfMaxMin", "IsWinMax", "IsWinMax", "HideWin", "IfMaxHide", "IfNormalHide", "random", "abs", "mod", "NewForm", "MemoReadFromFile", "SetVar", "GetVar", "NewReport", "NewProcedure", "QBM_NewReport", "DocumentOpen", "OpenForm", "ToText", "OpenReport", "OpenProcedure", "DocumentClose", "DocumentDelete", "PrintDocument", "PrintPreview", "PrinterSetup", "DataImport", "DataExport", "DesignerView", "ApplicationClose", "ExitDataEase", "UndoEdit", "CutSelected", "CopySelected", "CopyRecord", "CopySpecial", "Paste", "FieldClear", "FormClear", "RecordSave", "RecordSaveNew", "RecordDelete", "RecordRestore", "IndexUpdate", "AccessAllRecords", "AccessReadOnly", "AccessNoRecord", "RefreshScreen", "RefreshContinuously", "RefreshSetTime", "ViewAsForm", "ViewAsTable", "FilterClear", "FilterSet", "ZoomNormal", "ZoomIn", "ZoomOut", "ZoomFillWindow", "ZoomFillAcross", "ZoomFillDown", "ZoomPrevious", "ZoomCustom", "ZoomTo", "ZoomBy", "ToggleToolbar", "ToggleStatusbar", "ToggleCatalog", "Create", "RecordFirst", "RecordPrevious", "RecordNext", "RecordLast", "FormOpenRelated", "ReturnToParentDoc", "LookupTo", "ReturnDataToDoc", "SelectRecords", "RecordsSort", "SortAscending", "SortDescending", "SelectionFilter", "AddFilterAND", "AddFilterOR", "ClearSort", "Users", "Relationships", "CustomFunctions", "DatabaseLinks", "FormReorganize", "ApplicationBackup", "ApplicationRestore", "ApplicationInstall", "ApplicationLock", "ApplicationUnlock", "RecordsInfo", "ServersInfo", "DocumentsInfo", "ImportsInfo", "AppPreferences", "WindowsTileAcross", "WindowsTileDown", "WindowsCascade", "WindowsArrangeIcons", "WindowsCloseAll", "ExecDerivation", "Alert", "ReadFromFile", "Send", "Receive", "this", "HelpDQL", "ClearQueryFilters", "ExecuteFile", "RecordPreviousPage", "RecordNextPage", "AppRename", "AppNew", "AppOpen", "AppDelete", "AppMigrate", "ClearSelectionFilter", "EndPrintToWindow", "DEOS", "SetCurrent", "int21", "AnyLookUp", "ExecJavaScript", "OpenMenu", "DocumentCloseName", "GetLabelText", "HelpOnline", "MemoCopy", "MemoFind", "MemoMemoCopy", "MemoLength", "MemoReplace", "MemoChunk", "StringReplace", "StringFind", "MemoWordCount", "MemoWriteToFile", "PrintHtml", "PrintMemo", "RefreshForm", "GetCurrent", "MemoDecodePair", "WriteToFile", "OpenRelatedAsDialog", "StringEscape", "Remote", "MoveObject" ], "result": "ok" }
The current list of functions when this document was written