-
- 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
query selection
Type
Processing CommandPurpose
The query selection command is functional only on a LAN (local area network). This command is used to override DataEase's default locking rules. It should only be used by a technical expert who is very familiar both with DataEase and the LAN environment in use. If you do not have expertise in LANs, you can rely on the default locking rules to lock your data appropriately.
Before DataEase begins processing records for a script, it must select the records to be processed. The query selection command tells DataEase how to set locks prior to the start of processing if records are being selected or sorted on an indexed field. If records are not being selected or sorted on an indexed field, the default locking rules apply.Syntax
query selection lock files|records|nothing .The three syntax options that are used in conjunction with the query selection command are explained below.
The query selection lock files command overrides the default Record Selection locking rules and locks the table(s) from which records are being selected. Other users cannot add, modify, or delete records in the table. They can view records in the table if the selected records will only be listed by the procedure (not modified or deleted). The table remains locked until the end of the procedure.
The query selection lock records command overrides the default Record Selection locking rules and locks any records that have been selected for processing. Other users cannot modify or delete these records. They can view the records if the selected records will only be listed by the procedure (not modified or deleted). Other users can view, modify, or delete records in the same table(s) that have not been selected. Once processing begins, the default locking rule applies.
The query selection lock nothing command overrides the default Record Selection locking rules and unlocks the table(s) from which records are being selected. Other users can view, modify, or delete records that have been selected for processing. Once processing begins, the default locking rule applies.
The lock nothing command can be useful in situations where you need to keep data available to many users even while running a procedure that uses that data. However, with this command in effect, it is possible for a user to change a record that has already been selected for processing.
Caution
The query selection lock records command should be used with great care. It should only be used for procedures that select very few records from very few tables. If this command is used for many records, most LANs cannot support the number of locks required. If this command is used incorrectly, the integrity of your data can be compromised.
Note: If a lock all files command occurs as the first command in a script, it overrides the default locking rules and any locking commands specified later in the script. A lock all files command locks all files used by the procedure until an unlock command is encountered or the procedure ends, regardless of subsequent commands. See the lock command earlier in this chapter for more information.Usage
The query selection command overrides the LAN default Record Selection locking rules assigned by the database administrator. A query selection command is automatically terminated at the end of a script.
When using lock records on a DOS network, we recommend that you process a small number of records. Otherwise, your network may run out of locks and cause your workstation (or the network server) to lock up and require rebooting.
Example
query selection lock nothing .
for MEMBERS with BONUS POINTS > 500 ;
modify records
TOTAL DUE := ( TOTAL DUE * data-entry DISCOUNT ) .
end
This script tells DataEase: (1) Override the default Record Selection locking rule so other users can view, add, delete, or modify the data in the MEMBERS table while records are selected to be processed by this procedure, (2) select all the MEMBERS records whose BONUS POINTS are greater than 500, and (3)modify each selected record by multiplying the TOTAL DUE amount by the value in the DISCOUNT field on the Data-entry form.
In this example many records may be selected to be processed. However, users can still access the MEMBERS table while the procedure is processing. It is unlikely that any member's BONUS POINTS will fall below 500 while the script is being processed.