D3Codex
TCLPickBASIC / FlashBASICDefinitionsC FunctionsACCESS / AQL Tools
Recently viewed
Pinned
ACCESS / AQL 108
A
Access Query LanguageAccess Query Language overviewafter operatorand clauseany modifierAQL command categoriesAQL commandsAQL modifiersAQL relational operators and logical clausesAQL sentence formAQL user exits
B
before operatorbreak-on modifierby modifierby-dsnd modifierby-exp modifierby-exp-dsnd modifier
C
check-sum commandcol-hdr-supp modifierconv modifierconverting-nulls modifiercount command
D
dbl-spc modifierDefault attribute items (Access Query Language)Default output specificationsdet-supp modifierdict modifier
E
equal operatoreval modifierevery modifier
F
File reference (Access Query Language)fill modifierfmt modifierfooting modifier
G
ge operatorgrand-total modifiergt operator
H
hash-test commandhdr-supp modifierheading modifier
I
id-supp modifierifno modifierIndex utilization in selection criteriaistat commandItem list
L
le operatorlegend-supp modifierlist commandlist-item command (Access Query Language)list-label commandlocking modifierlptr modifierlt operator
M
Modifiers
N
ne operatorni-supp modifierno operatornopage modifiernot operatornselect command
O
oconvs() functiononly modifierOptions (Access Query Language)or clauseOutput specifications
P
PhrasesPrint limiters
Q
Quotation marks
R
reformat commandRelational operators and logical clausesrequire.select commandRetrieval of items from filesroll-on modifier
S
sampling modifierselect commandSelection criteriashow-nulls modifiersort commandSort criteriasort-item commandsort-label commandsreformat commandss modifiersselect commandstat commandString searchingsum command
T
tape modifiertcl-supp modifierTemporary attribute itemsThrowaway connectivestotal modifiertrans() function
U
u1070 user exitu201e user exitu2070 user exitu3070 user exitu5070 user exitu508e user exitu6070 user exitu7070 user exitu9070 user exitua070 user exituc070 user exitusing modifier
W
with modifierwithin modifierwithout modifier
Home/ACCESS / AQL/Access Query Language/Access Query Language overview
ACCESS / AQL

AQL command categories

.md

AQL commands essentially break down into these categories:

Category Commands
Output-producing sort command

list command

List-producing nselect command

sselect command

nselect command
Statistical count command

check-sum command

istat command

check-sum command
Tape-handling t-dump command

s-dump command

t-load command
File-analysis hash-test command

istat command

Internal (or copy) format list-item command (Access Query Language)

sort-item command

Label-like-producing list-label command

sort-label command

File-updating reformat command

sreformat command

See also

Access Query Language→Conversion→Dictionaries→File reference (Access Query Language)→Item list→Modifiers→only modifier→Options (Access Query Language)→sampling modifier→Selection criteria→Selection processor→
[ ← Previous
any modifier
Next → ]
AQL commands
© 2026 Kaskamko, LLC. All rights reserved.
API Privacy Policy Disclaimer Kaskamko

D3Codex is an independent, unofficial reference for the Rocket D3 MultiValue database. It is not affiliated with, authorized, or endorsed by Rocket Software, Inc. “D3”, “Pick”, and related marks are the property of their respective owners. Read the full disclaimer.

Keyboard shortcuts
Search
CmdK or / Open search
Tab Toggle section scope
UpDown Move through results
Enter Open the highlighted result
Esc or ` Close search
On a topic page
[ Previous topic in category
] Next topic in category
f Open pinned topics
r Open recently viewed
Press ? any time to toggle this panel.