-
- 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
Action names
BASE BASE_PLUS NO_ACTION SEPARATOR POPUP POPUP_FILE POPUP_FILE_NEW NEW_FORM NEW_REPORT NEW_MENU NEW_SCRIPT NEW_DBRFILE OPEN CLOSE DELETE PREVIEW PRINT PRINTERSETUP IMPORT EXPORT TEST_DESIGN CLOSEAPP EXIT POPUP_EDIT UNDO CUT COPY COPY_RECORD COPY_SPECIAL PASTE CLEARFIELD NEWRECORD SAVERECORD SAVEASNEWRECORD DELETERECORD RESTORERECORD LINKS POPUP_EDIT_OBJECT POPUP_MULTIUSER ALL_RECORDS READ_RECORDS NO_RECORDS REFRESH REFRESH_AUTO REFRESH_TIME REFRESH_FORM RETRIEVE_DEF_FIELD RETRIEVE_DEF_RECORD SAVE_DEF_RECORD DELETE_DEF_RECORD TABLE_GRID_DISPLAY POPUP_VIEW FORMVIEW LISTVIEW NOFILTERING FILTERING POPUP_VIEW_ZOOM ZOOM_NORMAL ZOOM_IN ZOOM_OUT ZOOM_FILL ZOOM_CUSTOM TOOLBAR TABBAR MENUBAR STATUSBAR CATALOG SQL POPUP_GOTO FIRSTRECORD PREV_PG PREVIOUSRECORD NEXTRECORD NEXT_PG LASTRECORD RELATEDFORM RETURNTOPARENT LOOKUP RETURNDATA DONE POPUP_QUERY SETFILTERS SETORDER ASCENDING DESCENDING DATAFILTER DATAMODEL CLEARFILTERS CLEARORDER POPUP_APPLICATION USERS RELATIONSHIPS CUSTOM_FUNCTIONS DATABASE_LINKS RELATIONDIAG POPUP_APP_UTILITIES REORG BACKUP RESTORE INSTALL_APP LOCKAPP UNLOCKAPP INSTALL RENAMEAPP POPUP_APP_STATUS APPSTAT_RECINFO APPSTAT_SERVINFO APPSTAT_DOCINFO APPSTAT_IMPORTINFO APPSTAT_TABLEINFO APPSTAT_ACTINFO APPSTAT_DQLINFO APPSTAT_OMLINFO APPSTAT_OBJINFO APPSTAT_BRLINFO APPSTAT_RNGINFO APPSTAT_REFRESHINFO APPSTAT_DELETEINFO PREDEFINED_PRINTERS PREFERENCES POPUP_WINDOW TILEHORIZ TILEVERT CASCADE ARRANGE CLOSEALL POPUP_HELP HELP_INDEX HELP_DESKTOP HELP_MENUS HELP_TOOLBAR HELP_HOWTO HELP_GLOSSARY HELP_ONLINE USER_HELP ABOUTDATAEASE CHANGE_KEY SAVE SAVEAS STYLE_SAVEAS TEST_RUN REDO PASTELINK PASTE_SPECIAL CLEAR POPUP_EDIT_ALIGN RIGHTEDGES LEFTEDGES HORIZCENTER TOPEDGES BOTTOMEDGES VERTCENTER GRIDSNAP POPUP_EDIT_SIZE HORIZONTAL VERTICAL BOTH SELECTALL FIND REPLACE FIND_NEXT FIND_PREV COLOR LAYOUT ACTION FONT DEFINE TEXT DOCUMENT PROCEDURE HEADER FOOTER DATAENTRY OUTLINES LABELING RULERS GRIDS GRIDOPTIONS POPUP_OBJECTS TEXT_OBJ FIELD_OBJ SUBFORM_OBJ BUTTON_OBJ PICTURE_OBJ LINE_OBJ RECTANGLE_OBJ ELLIPSE_OBJ VARIABLE_OBJ SUMMARY_OBJ GRAPH_OBJ OLE_OBJ CUSTOM_OBJ IMAGE_FLD_OBJ CHECK_FLD_OBJ LIST_FLD_OBJ RADIO_FLD_OBJ SPIN_FLD_OBJ POPUP_STYLE TABOBJ_OBJ WEB_FLD_OBJ AWEB_FLD_OBJ HTMLED_FLD_OBJ MULTIBOX_FLD_OBJ STYLE_CREATE STYLE_UPDATE STYLE_DELETE STYLE_APPLY POPUP_DOCUMENT FORMUSAGE PRTSPEC SECURITY P_DATAMODEL SET_TABS CLEAR_TABS PERFORMANCE CUSTMENU CUSTTOOLBAR HELP_SEARCH HELP_DQL POPUP_SCRIPT COMPILE POPUP_PICK_LISTS PICKLISTS COMMANDS SQL_COMMANDS FUNCTIONS OPERATORS DOCUMENTS TABLES COLUMNS S_RELATIONSHIPS KEYPAD ALPHABETIC OPEN_TEXTFILE SAVE_TEXTFILE S_NEW_SCRIPT S_PREFERENCES HISTORY_NEXT HISTORY_PREV POPUP_FILE_FRAME NEWAPP OPENAPP DELETEAPP INST_OPTIONS STYLES_LISTBOX SCRIPT SCRIPT_METHOD_NEXT SCRIPT_METHOD_PREVIOUS SCRIPT_METHOD_OPTIONS BROWSER OBJECTS PROPS CLASSES PROCS METHODS EVENTS TEMPLATES RENAME_OBJECT START_FIELD_DEFN SE_ADD_REFRESH SE_DELETE_REFRESH RD_CREATE RD_BROWSE EXECUTE EXPRESSION ADDFILTER_AND ADDFILTER_OR FIRSTRECORD_P PREVIOUSRECORD_P NEXTRECORD_P LASTRECORD_P PREV_PG_P NEXT_PG_P CLEARDATAFILTER ZOOM_TO ZOOM_BY ZOOM_PREVIOUS ZOOM_FILL_HEIGHT ZOOM_FILL_WIDTH OPEN_MENU OPEN_FORM OPEN_REPORT OPEN_PROCEDURE BANDHEADER BANDFOOTER OBJECTPALETTE ACTIVEDOCSTATE ACTIVEDOCTYPE DESELECT_OBJ ALLBAR GETBARSTATUS A2 String: TABBAR,STATUSBAR,TOOLBAR,MENUBAR,ALLBARS SORTASCENDING SortAscebding/SortDescending (sortCommand) are implemented for call from Service Window. Usage: jsActionExt("30011", sortString)/ jsActionExt("30012", sortString) SORTDESCEDING SortAscebding/SortDescending (sortCommand) are implemented for call from Service Window. Usage: jsActionExt("30011", sortString)/ jsActionExt("30012", sortString) OPENTABLE OPTENTABLELIST QUERYSELECTFIELDS Switch To Field Select Mode SETSTYLE DT GETALLWINDOWTITLES GETSTYLESFROMSELECTED SWITCHWINDOW A2 WindowID ref CLOSEWINDOW A2 WindowID ref Close Window indicated by WindowHandle (A2) GETPOSFROMSELECTED Return JSON for Postion of Active/Selected object GETLICENSE used to get and register a license when no license exists CHECKLICENSE used to check for roaming conflicts, will popover the LoginRoaming.html when conflict is detected TAKELICENSE used to take back the licenses for roaming user and is called from LoginRoaming.html OPENAPPDIALOG for opening a app dialog implemented. Takes no parmeters or 1 paremeter with start folder. GETSTYLENAMES return a json array with all styles that can be set in the application NOTIFYSERVICEWINDOW REGISTERNEWUSER The first uses https://license.dataease.com/licensecheck/newuser/?& with input json sting with username : email and password : password. It will set a retruned trial key as the license on return if email not used before and json Result : "ok". If not Result : "fail" RESETPASSWORD The second asks for reset password https://license.dataease.com/licensecheck/resetpassword/?& with string parameter for the email address to send the reset link to. If email found Result : "ok" else Result : "fail" GETOBJECTINFO Not to be used directly, use via GetCurrent() GETCURRENTOBJECTSTRING Not to be used directly, use via GetCurrent() GETCURRENTFILTER get the current filter of Active Document.