-
- Command line
- Server Settings
- Webserver table
- Commands
- Session
- Authentication
- Custom authentication
- External authentication
- Basic authentication
- Token authentication
- Folder Security
- Data manipulation
- Read one record
- Read many records
- Write one record
- Write many records
- 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
- .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
File handling
The server reads files as an integral part of the server. Files read will then be parsed to see if they are pages or templates if they are of type .html, .htm, .dql and .page. If they are pages/templates they will be used as any other page and the resulting code generated is the page and not the source. Due to this we have another set of requests that manipulate files as they are.
File manipulation
To manipulate a file on the server, you need to be logged in as a user with High security. The handling is done using the /filehandling/url. This handler support GET for reading PUT for updating, POST for creating and DELETE for deleting files.
Read a raw file
var url = '/filehandler/editor/pageeditor.html'; var options = { 'url' : url, 'type' : 'GET', 'dataType' : 'text' }; $.ajax(options).done(function(code,status,xhr){ // the content of the file is now in code _this.myfilecontent = code; }).fail(function(code,status,xhr){ //do error handling here });This reads a file as raw data from /static/editor/pageeditor.html in the application started using jquery
Write a raw file
var thecode = 'This is a text to put into the file\nSecond line\nThird line\n'; var url = '/filehandler/editor/'; var filename = 'pageeditor.html'; var fdata = new FormData(); fdata.append('file', new File([new Blob([thecode])],filename)); var options = { 'url' : url, 'data' : fdata, 'processData' : false, 'contentType' : false, 'type' : 'POST' }; $.ajax(options).done(function(jdata,status,xhr){ // do some messaging if the write was ok if (jdata.result=='ok') $("#messages").html("The file was saved"); }).fail(function(code,status,xhr){ //do error handling here });This saves or creates a file as raw data from /static/editor/pageeditor.html in the application started using jquery
Delete the file
var url = '/filehandler/editor/pageeditor.html'; var options = { 'url' : url, 'type' : 'DELETE' }; $.ajax(options).done(function(jdata,status,xhr){ // do some messaging if the delete was ok if (jdata.result=='ok') $("#messages").html("The file was deleted"); }).fail(function(code,status,xhr){ //do error handling here });This deletes the file from /static/editor/pageeditor.html in the application started using jquery