-
- 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
- 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
Form actions
Actions for web use, is a way to replicate actions that you find in a DataEase form in Windows to the web. It it used in web buttons, but are executed by the deconnect.js engine. This document tells the action name and how it works on the web. For a form user, it should feel the same as in DataEase for Windows forms.
Only the actions with description is implemented.
DocumentOpen DocName This opens a new page the have the defined name in the WebServer table. The name should be the same as the ID field or the Name field in the table. You can also use the relative url defined. DocumentClose This is the same as document.back(); PrintDocument PrintPreview PrinterSetup UndoEdit CutSelected CopySelected CopyRecord Paste FieldClear FormClear Set all fields to blank and record number to -1 to indicate new record if RecordSave is called RecordSave Save the data in from to the save record it came from or as new if -1 RecordSaveNew RecordDelete RecordRestore RefreshScreen ViewAsForm ViewAsTable FilterClear FilterSet RecordFirst Load query model /0/ RecordPrevious Load data model /xx-1/ until you are at /0/ RecordNext Load data model /xx+1/ until you are at /last/ RecordLast Load query model /last/ FormOpenRelated TableName
[DocName]ReturnToParentDoc LookupTo TableName ReturnDataToDoc RecordPreviousPage RecordNextPage SelectRecords RecordsSort SortAscending SortDescending SelectionFilter FilterLSide
FilterRSideQBM_NewReport ClearQueryFilters ClearSort AddFilterAND FilterLSide
FilterRSideAddFilterOR FilterLSide
FilterRSideClearSelectionFilter To manually use these actions in a hand coded page, you will have to add the actions in a data-action attribute and add a deconnect.forminit() in you ready document function. This will check all the settings in the form and do all default functionality based on the data-somesetting in the form.
<script> $(document).ready(function() { // When the document is finished loading, we we do default form action to fetch record and activate all the buttons deconnect.forminit(); }); </script> .... <form class="form-horizontal" data-tablename="Stock" data-formtype="singerecord"> <div class="form-group"> <label for="StockCode" class="col-sm-2 control-label">Stock Code</label> <div class="col-sm-10"> <input type="text" class="form-control" id="StockCode" placeholder="Stock Code"> </div> </div> .... <div class="form-group"> <div class="col-sm-offset-2 col-sm-4"> <a class="btn btn-primary" data-action"RecordSave">Save</a> <a class="btn btn-primary" data-action"FormClear">Clear</a> <a id="delete" class="btn btn-primary" data-action"RecordDelete"">Delete</a> <a class="btn btn-primary" data-action"DocumentClose">Close</a> </div> <div class="col-sm-offset-8 col-sm-4"> <a class="btn btn-default" data-action"RecordFirst">First</a> <a class="btn btn-default" data-action"RecordPrevious">Previous</a> <a id="delete" class="btn btn-default" data-action"RecordNext"">Next</a> <a class="btn btn-default" data-action"RecordLast">Last</a> </div> </div> </form>
Example of a default form where you load the first record and can navigate, clear, create and update data in a stock table. We as showing the buttons here, to see the full form functionality have a look at the autoform document.