Master Index

Home

Index Key

[ A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Symbols ]

Q

QRT function, sqls, 1-910

Queries. See SQL queries; Data sources.,

Query,

alias with, sqlt, 2-74

complex vs. simple, sqls, 1-718

design plan, sqls, 1-536

examples, sqlt, 2-6 to

memory for returned values, sqls, 1-416

multirow,

statements for, sqls, 1-413

optimization information (sysprocplan), sqlr, 1-48

optimization information statements, sqls, 1-18

optimizing, sqls, 1-536

ordering with UNION operator, sqls, 1-645

piping results, sqls, 1-540

See also Subquery.,

stated in terms of data model, sqlt, 1-6

UNION operator with, sqls, 1-645

variable text, sqlt, 2-36

Query blocks, vis_ug, 3-29

Query Design panel, vis_ug, 3-6, 1-11

Query Diagram view,

about, vis_ug, 3-29

introduction to, vis_ug, 1-14

modifying data sources using, vis_ug, 3-39

uses for, vis_ug, 3-6

Query diagrams,

about, vis_ug, 3-29

about query blocks for, vis_ug, 3-29

connecting blocks in, vis_ug, 3-29

constant blocks in, vis_ug, 3-31

data blocks in, vis_ug, 3-30

defining filters in, vis_ug, 3-37

defining output columns in, vis_ug, 3-38

modifying, vis_ug, 3-39

parameter blocks in, vis_ug, 3-31

ports in, vis_ug, 3-29

table blocks in, vis_ug, 3-30

viewing SQL text generated from, vis_ug, 3-38

Query Editor,

Data Sheet view, vis_ug, 3-29

description of, vis_ug, 3-29, 1-14

illustration of, vis_ug, 1-14

introduction to, vis_ug, 1-7

printing from, vis_ug, 12-5

Query Diagram view, vis_ug, 3-29

SQL Text view, vis_ug, 3-29

uses for, vis_ug, 3-6

Query parameters,

adding, vis_ug, 3-43

description of, vis_ug, 3-41, A-54

displaying properties of, vis_ug, 3-42

modifying, vis_ug, 3-44

setting data type for, vis_ug, 3-44

specifying in Advanced Query wizard, vis_ug, 3-25

Query wizards,

and the Layout wizard, vis_ug, 5-11

launching, vis_ug, 3-6

See also Advanced Query wizard; Simple Query wizard.,

using, vis_ug, 3-6

Question mark. See? (question mark).,

Quotation marks,

double,

around quoted string, sqls, 1-1015

within quoted string, sqls, 1-1017

single,

around quoted string, sqls, 1-1015

within quoted string, sqls, 1-1017

Quoted Pathname segment, sqls, 1-1012

Quoted string,

comparing, sqls, 1-841

DATE, DATETIME, sqlr, 2-14

DATETIME, INTERVAL with, sqls, 1-1017

inserting values with, sqls, 1-1018

LIKE, MATCHES condition with, sqls, 1-1017

examples, sqls, 1-623

See also", double quotes,

TRACE statement with, sqls, 2-59

Quoted String segment, sqls, 1-1015