El profesor como un profesional de la enseñanza

tions by _placing an asterisk in front of the field tag name. Should you change _your mind _about a field that has been _{selected for} outpUt9 cancel _{the last selection} by _{using the} BACK WINDOW comand _key. When _{all desired fields} have been chosem press the <RETURN> key to

move on to the next section. QUERY

_will

ask

if

totals are wanted on

the numeric _fields.

DO YOU WANT TOTALS PRINTED AT THE END OF THE QUERY? <N> The _next prompt

_will

be:

ENTER ITEM TO SELECT BY OR PRESS <RETURN> TO CONTINUE:

MAKING SELECTIONS IN QJJERY

These are the logical operators available in QUERY _{(less than, less} than _or equal _{to, etc.)c that} are used _{to define} a subset _of data from a

_file.

<: LESS THAN _{: LESS THAN OR EQUAL TO >: GREATER THAN _}; GREATER THAN OR EQUAL TO

if

the _{field selected is} numeric _you

_will

see: NUMBER:

=: EQUAL TO X: NOT EQUAL TO

if

the _{field selected is alphanumeric} you will see: STRING:

S: STRING COMPARE @: STRING INCLUDES As you respond _{to the} prompt _line

it

will

change by _{translating your} responses into the appropriate words. QIJERY

_will

_also mark _{the field} names

list

on the upper portion of the screen with the selected

symbol.

_If

a greater than and a less than are _{specified for the} same

fielch a range _{of records} between _the two _{values will} be _selected. The maximum number _{of selection criteria} allowed _fs 10.

QÍOOSING AN OUTPUT SEQJJENCE FOR QJJERY

QUERY _{will display the available} indexes _for the

_file.

_{Select the}

index that you want _to determine _the sequence or order of the QUERY

output.

_If

you press <RETURN> and do _{not enter} an index number, _the

output will be ordered _{according to the record} number _{of the data.}

————— ———————.,————-————————-—

DataF1ex 2.0 _User's Manual QUERYING THE DATABASE A-45 —— ——————————

*

l

---> <VENDOR ID> 2 _---> <VEND0R NAME>

OUTPUT OF THIS QUERY SHOULD BE LISTED BY:

QUERY _will then ask _for the TITLE OF THE REPORT. _{This information}

wiR appear at the top _of each page of a report format QUERY. ENTER THE REPORT HEADER:

Next, QUERY wi71 prompt _for the _{output destination.} At _{this point} you

also have _{the option of using} QUERY _{to create} a configuration

_file

for

a DataFlex report. The _{default for this} prompt _{is to output} a report formatted query _{to the screen.}

AT THIS POINT YOU MAY SELECT WHERE THE OUTPUT OF THIS QUERY SHOULD BE DIRECTED. YOU MAY ALSO SELECT THE FORMAT FOR A REPORT IMAGE FILE.

OUTPUT QUERY TO:

(S)creen, (P)rinter, (F)i1ey (R)eport imagep _{or (A)bort:} An _{entry of} "S" _will cause the output to go to the CRT _{screen; "P"}

will

send _{the output to the printer;} "F"

_will

direct

_it

to a disk fi7e (you _will be prompted _for a

_ffle

name); _or "R" _{will create} a "Report

Image" (see _{next paragraph).} A <RETURN>, _{or default,} response

_will

be executed as though "S" were selected. Both the _"F"

_(file)

and _"R"

(report configuration) options will trigger the _questions below.

USING QUERY TO GENERATE A REPORT CONFIGURATION

By making an "R" response _{to the output option} prompt you will start

the _{creation of} a report configuration

_file.

The next prompt

_will

ask which _{of three formats, Report,} Reach _or Quoted, you want used _for the data _output when _{the report is run:}

SELECT THE OUTPUT FORMAT TO BE USED

1)Report, 2)Reád» _or 3)Quoted _format:

I) REPORT FORMAT: A _formatted columnar _{report consisting of} a

_title

sectiom column headerm data elements arranged _in columns under _their

appropriate names, and _totals

_(if

_{selected) at the} end.

2) READ FORMAT: A _sequential ASCII _{format consisting of} each _data element on a separate line terminated with a carriage return. This is the format that the DataFlex

_utility

READ uses to "Read" data _into a DataFlex data base

_file.

__—————__——______=————

A-46 QUERYING THE DATABASE DataF1ex 2.0 _User's Manual —————————————— ===——

3) QUOTED FORMAT: A _sequential ASCII

_file

_{format compatible with} many

versions of BASIC and _the "merge"

_files

_created and used by many word

processors, in which quotes and commas ("BJ') are used _{to delimit}

fields and each _{record is terminated} by a carriage return. Leading and

_trailing

_blanks are trimmed from _{the fields of output} from QUERY,

but not from _{output of the} generated _{report configuration} (unless you

subsequently edit

_it

to do SO). Then you

_will

be prompted:

ENTER THE REPORT IMAGE NAME (8 MARACTERS MAX)?

Respond _{with the} fi7ename up to eight (8) characters in length that

you wish _{the report} source configuration

_file

to be _stored under by

the operating system. QUERY _will add _{an extension of} .RPT _{to your}

entry resulting in a final name of the

_file

of fi1ename.RPT.

Thereforep you must _{not specify} your own extension to the filename.

If

you doF QUERY _{will ignore}

_it.

If

a

_file

already exists with that name (filename.RPT), QUERY

will

issue a warning message to that effect and ask whether _or not _to

overwrite the

_file.

The _default response in this case is <N>. Next you will see a message:

REPORT IMAGE CREATED!

PRESS <RETURN> TO _CONTINUE...

QLJERY_will then again _{display the output option} prompt shown above. which _{is intended to give} you the opportunity to output the actual

data (as opposed _{to the report configuration}

_file

which you have _just

created).

_If

your only purpose for running QUERY _{at this point} was _to

create the REPORT _{configuration fí1eg choice "A" to abort} would be

your choice.,

In _{order to} use the report configuration

file

created by QUERY9 you must _compile

it

into a .FLX

_file

_{with the} comnand: A>COMP fl1ename.RPT

where _{filename is the} name you gave _the

_file

_in answer _to QUERYG prompt above. _{Prior to compiling itg} you may wish _{to modify}

_it

_in one way _or anothem _in which case you may do so as you would _with any

other DataFlex _{configuration} source

file

(see the chapter on How _to

Write a Configuration in this manual). The compiled _{configuration} would then be executed from _{the operating} system _{with the comand:}

A>FLEX _{filename {output destination}}

—————

—— ————————-—————— —— B"l ——————————————————

·

========== ==========

EEEEE===== PROGRAMMING TUTORIAL

zm:

zz="=

======"=== _______"_"

CREATING A DATAFLEX APPLICATION OF YOUR OWN

In _{this section of the tutorial,} you will experience how easy

it

is to

create an application using DataF1ex _without ever having _{to "program".} Them once you have an application functionfngg you will be introduced

to what can be done by _{putting just the slightest effort into}

"customizing" your application requirements.

To _{achieve this,} we have decided _{to appoint} you as manager in a company that has just bought their

first

microcomputer with word pro-

cessing and _DataFlex. As _the member _{of the} group who _"took a computer course in co1lege'% _you have been _{selected to} be _the one to become

familiar with the new system and _{to undertake the} development (and

perfection!) of some new management _information systems.

Being _{a creative} and _thoughtful gi"wpó you and _{your associates recog-}

nize the _{value of properly planning the information} system. The

_first

task defined is to develop a personnel _information system _for the company.

DataFlex _{provides several} methods _to implement _{your application}

requirements. The _easiest and most _{efficient at this point is the}

facility

for you to create an "image" _of a data base

_file

on your CRT screen using a word _{processor or the} DataFíex Editor program.

An "image% _{in DataFlex} termino1ogyg _{is a format into} which data can be _{inserted for output.}

_It

can be _displayed on a CRT _{screen, or} on a

printed report. The image can include prompting _{or 1abelling for}

information which _{is stored in the} data base, and "windows" where _the

stored data _will be _output. DataF1ex images _{are created with} a text editor (one _{is included with DataFlex) or} any word _{processor that} can

create and _edit a plain ASCII

_file.

_Creating an image _{with your}

editor allows you to develop a visual approach _{to designing your}

applications that combines how

it

looks with how

it

works. When an "image" _is comp1eté»

it

may be processed by a

_utility

program

supplied with DataFlex, called AUTODEF, _into a data base

_file

definition and data _{entry screen.} AUTODEF reads _{in the} "image"

_file,

asks you some questions about how you want _{things to} workg and _then

outputs another

_file

(called a "configuration source"

file)

onto your

disk that can be compiled and executed as is, or modified to meet a

particular set of requirements, and then _compiled. The _{rest of this}

section illustrates this process. There are othéi"» more flexible ways

of accomplishing these _functions (such as through FILEDEF) which _are

described elsewhere _{in this} manual.

—-——

B-2 PROGRAMMING TUTORIAL DataF1ex _{2.0 User's} Manual

—'—

'

————

Getting Started...

To speed _{the familiarization} procesSg we have made up an image

_file

and _printed

it

below _{to help} you get underway _{with the task defined} above. We _will be _using

it

as the basis of the rest of the

tutorial.

In document Arrojados en la acción : aprender a enseñar historia y ciencias sociales en la practica profesional (página 49-54)