TCL PickBASIC / FlashBASIC Definitions C Functions ACCESS / AQL Tools

Recently viewed

Pinned

ACCESS / AQL 108

A

Access Query Language Access Query Language overview after operator and clause any modifier AQL command categories AQL commands AQL modifiers AQL relational operators and logical clauses AQL sentence form AQL user exits

B

before operator break-on modifier by modifier by-dsnd modifier by-exp modifier by-exp-dsnd modifier

C

check-sum command col-hdr-supp modifier conv modifier converting-nulls modifier count command

D

dbl-spc modifier Default attribute items (Access Query Language)Default output specifications det-supp modifier dict modifier

E

equal operator eval modifier every modifier

F

File reference (Access Query Language)fill modifier fmt modifier footing modifier

G

ge operator grand-total modifier gt operator

H

hash-test command hdr-supp modifier heading modifier

I

id-supp modifier ifno modifier Index utilization in selection criteria istat command Item list

L

le operator legend-supp modifier list command list-item command (Access Query Language)list-label command locking modifier lptr modifier lt operator

M

N

ne operator ni-supp modifier no operator nopage modifier not operator nselect command

O

oconvs() function only modifier Options (Access Query Language)or clause Output specifications

P

Phrases Print limiters

Q

Quotation marks

R

reformat command Relational operators and logical clauses require.select command Retrieval of items from files roll-on modifier

S

sampling modifier select command Selection criteria show-nulls modifier sort command Sort criteria sort-item command sort-label command sreformat command ss modifier sselect command stat command String searching sum command

T

tape modifier tcl-supp modifier Temporary attribute items Throwaway connectives total modifier trans() function

U

u1070 user exit u201e user exit u2070 user exit u3070 user exit u5070 user exit u508e user exit u6070 user exit u7070 user exit u9070 user exit ua070 user exit uc070 user exit using modifier

W

with modifier within modifier without modifier

Home/ACCESS / AQL/Access Query Language/AQL modifiers

ACCESS / AQL

show-nulls modifier

The show-nulls modifier allows the display of empty multivalues.

Syntax

show-nulls

Example(s)

list entity name contact show-nulls

Selection criteria

© 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.