home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
d3an8708.zip
/
D3AN8708.TXT
Wrap
Text File
|
1987-08-31
|
5KB
|
169 lines
@...GET...PICTURE
version: DP DP11
date: 18 Aug 1987
text:
Using Ctrl-W or Ctrl-End to exit an active @...GET...PICTURE of a numeric
field or memory variable may produce undesirable results. When @...GET is
activated, the existing number is displayed right justified. As new
numbers are entered, they are displayed left justified until the display is
exited, at which time the new number is right justified. However, exiting
the display with Ctrl-W saves the digits displayed, concatenating the old
number to the new. Any spaces between the numbers are ignored. This
occurs only when a PICTURE clause is included. For example,
SET DELIMITERS ON
mvar = 10
@ 10,10 GET mvar PICTURE "999999"
READ
displays
: 10:
entering 100 followed by Ctrl-W displays
:100 10:
^-- Enter Ctrl-W here.
This sets the value of mvar to 10010.
APPEND FROM SDF
version: DP DP11
date: 18 Aug 1987
text:
dBASE III PLUS stops parsing the APPEND command when the SDF option is
encountered. APPEND FROM <Filename> TYPE SDF FOR <Condition> appends all
records, whether or not the new records meet the FOR <condition>. However,
switching the order of the TYPE and FOR options within the command line
correctly filters out records that do not match the FOR <Condition>. For
example,
APPEND FROM Test1 TYPE SDF FOR Amount < 100
incorrectly appends all records. But,
APPEND FROM Test1 FOR Amount < 100 TYPE SDF
correctly filters out records where the value of Amount is less than 100.
APPEND FROM TYPE DELIMITED FOR <Condition> correctly filters records
regardless of the option order.
COPY TO
version: DP DP11
date: 18 Aug 1987
text:
If field names are duplicated in the FIELDS list of the COPY TO command,
each field in the list, including duplicates, becomes a field in the
resultant database file. All fields can be EDITed and BROWSEd but, only
the first field with any name can be accessed with @...SAY/GET, ?/??,
DISPLAY, and LIST.
When the new file structure is edited with MODIFY STRUCTURE, the error
message "Field name already in use." is produced and the edit must be
aborted with Ctrl-Q or Esc, unless the duplicate field names are
immediately changed.
CREATE VIEW
version: DP DP11
date: 18 Aug 1987
text:
Opening a view file that was created with CREATE VIEW does not automati-
cally SET FIELDS ON unless one of the fields was deselected from the CREATE
VIEW Set Fields list when the .VUE was created or unless SET FIELDS ON was
issued prior to CREATE VIEW. When creating a view file, all fields are
selected by default. When the .VUE file is saved, the status of SET FIELDS
is saved with it. If SET FIELDS was OFF prior to CREATE VIEW, it is not
changed unless a field is deselected from the Set Fields fields list. For
example,
SET FIELDS OFF
CREATE VIEW Test
* ---Select a database file and save the .VUE file.
SET VIEW TO Test
SET FIELDS ON
LIST
displays the record numbers only. DISPLAY STRUCTURE reveals that no fields
are selected. However, MODIFY VIEW <Test> shows that all fields are
selected.
If more than one database file is opened by SET VIEW TO and a relation is
established, fields from database files not in the current work area are
available only if SET FIELDS is ON and the fields are in the SET FIELDS TO
list.
DO CASE
version: DP DP11
date: 18 Aug 1987
text:
When executed, the word END in a DO CASE...ENDCASE structure terminates
program execution as if RETURN were encountered. When encountered outside a
DO CASE...ENDCASE construct, END produces the error message "Unrecognized
command verb." [16].
JOIN
version: DP DP11
date: 18 Aug 1987
text:
JOIN WITH <Alias> TO <Filename> creates a new file with the structure of
the database file in the current work area exclusively when the WITH file
contains illegal characters (such as +, -, or &) in the filename. When
valid filenames are used, JOIN creates a new file whose structure contains
all the fields from the two files, provided that the new structure does
not exceed the 128 field limit.
READKEY()
version: DP DP11
date: 18 Aug 1987
text:
The value returned by READKEY() is reset to 271 or 15 after executing a
RETURN, SUSPEND, or CANCEL command. The value returned by READKEY() should
remain unchanged until another full-screen command is executed. However,
RETURN, SUSPEND, and CANCEL reset the key value to 271 or 15.
REPORT FORM
version: 20 21
date: 18 Aug 1987
text:
REPORT FORM with SET ALTERNATE TO <Filename> and SET ALTERNATE ON produces
inconsistent page breaks when the NOEJECT option is included or
Options:Page eject before printing is "Yes." To work around this problem,
SET ALTERNATE OFF before running the report and send the report to a text
file by including the TO FILE <Filename> option in the REPORT FORM command
line.