REPLACE DATA.........Replacing data in database fields
READ.................Activate full-screen editing mode with Get Objects
RECALL...............Restore records marked for deletion
REDO.................Execute "dynamic-linked" procedure after re-linking the .OBJ
REINDEX..............Rebuild open indexes in the current work area
RENAME...............Change the name of a file
REPLACE..............Assign new values to field variables
REPLACE IMPORT.......Replace data in current record from import file record
REPLACE VIRTUAL......Replace the current record with the Virtual record
REPORT...............A report and label form manager
REPORT FORM..........Display a report to the console or printer
RESTORE ARRAY........Retrieve a multi-dimensional array from an array file
RESTORE FROM.........Retrieve variables from a (.MEM) file
RESTORE SCREEN.......Display a saved screen
RESTORE SET..........Restore the SET environment from a file
RESTORE TAGS.........Rebuild all tags in a .CDX file from a Tag file
RESTORE WORK.........Open data files/indexes from information in a (.DCW) file
RESUME...............Resume searching additional keys after a HUNT
RUN | !..............Run another DOS program
SAVE ALL.............Save variables to a (.MEM) file
SAVE ARRAY...........Save a multi-dimensional array to an array file
SAVE SCREEN..........Save current screen to a buffer or variable
SAVE SET.............Save the SET environment to a file
SAVE TAGS............Save info about all open indexes to a .DCT file
SAVE TO..............Save variables to a (.MEM) file
SAVE VIRTUAL.........Save the current record to the Virtual record
SAVE WORK............Save Information about all work areas to a (.DCW) file
SCREEN DELETE........Delete a Screen Group in Screen Dictionary
SCREEN EDIT..........A Screen Designer/Editor
SCREEN PAINT.........Paint a screen from a Screen Group in Screen Dictionary
SEARCH...............Scan all fields of specified databases for matching string
SEEK.................Search an index for a specified key value
SELECT...............Change the current work area
SET..................Pop-up an editing screen for all SET environment variables
SET ALTERNATE........Toggle console output to a text file
SET ALTERNATE TO.....Define the text file for routing console output
SET AUTOINDEX........Automatically open index files
SET AUTOLOCK.........Toggle Automatic Record/File Locking
SET BATCH............Create a specified command to run a batch file
SET BELL.............Toggle Bell sounding during full screen operations
SET CHRKEY...........Define the key assignment for the ASCII-table pick-list
SET CLIPOPT..........Define standards options for the Clipper compiler
SET CLIPPATH.........Set the search directory for CLIPPER.EXE compiler
SET CLOAK............Toggle hiding compiler copyright message
SET COLOR............Define screen colors
SET COMMAND..........Create a single-verb command to run a DOS program
SET CONFIRM..........Toggle required exit key to terminate GETs
SET CONSOLE..........Toggle console display to the screen
SET CUA..............Toggle CUA-Compliance mode for terminating Gets
SET CURSOR...........Toggle the screen cursor on or off
SET DATE.............Set the date format for input or display
SET DCLIP............Set the directory to use for dCLIP data-dictionary files
SET DEBUG............Toggle the enabling of the ALT-D key for debugging
SET DECIMALS.........Set the number of decimal places displayed
SET DEFAULT..........Set the default drive and directory for data files
SET DELETE...........Toggle filtering of deleted records
SET DELIM............Toggle GET delimeters
SET DELIM TO.........Define GET delimeters
SET DEVICE...........Direct @...SAYs to screen or printer
SET DOSKEY...........Set Clipper command stack operation to Dos-Key emulation
SET DOTSTACK.........Increase/Decrease the size of the Dot-prompt command stack
SET ECHO.............Toggle Display of commands to console when running .DCB file
SET EDITOR...........Define the default editor for the IDE system
SET ESCAPE...........Toggle ESCape as a READ exit key
SET EXACT............Toggle Exact matches for character strings
SET EXCLUSIVE........Establish Shared or Exclusive use of database files
SET EXPLODE..........Toggle activation of Exploding Windows
SET FILTER...........Hide records not meeting a condition
SET FIXED............Toggle fixing the number of decimals displayed
SET FLDKEY...........Define the key assignment for the field pick-list
SET FORMAT...........Activate a Format when READ is executed
SET FUNCTION.........Assign a character string to a function key
SET HELP.............Toggle the echoing of command syntax after a syntax error
SET INDEX............Open index file(s) in the current work area
SET INDEXKEY.........Define the key assignment for the index-builder
SET INTENSITY........Toggle enhanced display of GETs and PROMPTs
SET KEY..............Assign a procedure invocation to a key
SET MARGIN...........Set the page offset for all printed output
SET MESSAGE..........Set the @...PROMPT message line row
SET ODIR.............Specify the directory to place .OBJ files after compiling
SET ODPERCENT........Set numeric value for progress indicator percentage of update
SET ORDER............Set a new controlling index file
SET ORDER .. TAG.....Set a new controlling index Tag
SET PATH.............Specify the search path for opening data/index/form files
SET PDIR.............Specify the search path for opening .PRG files
SET PEXT.............Specify the default extension for source files
SET PRINTER..........Toggle echo of console output to the printer
SET PRINTER TO.......Set the destination of printed output
SET PROCEDURE........Create a specified command to run a procedure
SET PROMPT...........Establish the information displayed before the dot prompt
SET QUERYKEY.........Define the key assignment to pop-up the query builder
SET RDD..............Establish the Default Database Driver
SET RELATION.........Relate two work areas by a key value/record number
SET SCOREBOARD.......Toggle the message display from READ or MEMOEDIT()
SET SLASH............Define the name of the source file to edit with the / key
SET SOFTSEEK.........Toggle relative SEEKing
SET STATUS...........Toggle display of 3-bar status line at top of screen
SET STEP.............Toggle source-level debugging mode
SET STICKYBROWSE.....Set Sticky Browse Default Mode
SET SUPERRDD.........Establish the Default "Inherited" Database Driver
SET SWAP.............Specify directory to create temporary file when shell to dos
SET TAG..............Set a new controlling index Tag
SET TALK.............Toggle display of Pre-processed output
SET TRACE............Toggle trace-profiling mode
SET TRACESIZE........Set Maximum size of Trace File
SET TURBO............Define the default TURBO editor for the IDE system
SET TYPEAHEAD........Set the size of the keyboard buffer
SET UNIQUE...........Toggle inclusion of non-unique keys into an index
SET USEEXCLDATA......Force Exclusive Use of Application Databases
SET USEEXCLDICT......Force Exclusive Use of Dictionary Databases
SET WRAP.............Toggle wrapping of the highlight in MENU TO menus
SKIP.................Move the record pointer to a new position
SORT.................Copy to a data file in sorted order
STABILIZE............Stabilize a Tbrowse object
STEP.................Load an expression or procedure name into the STEP table
STEP CLEAR...........Remove STEP expressions from the STEP table
STEP ONLY............Display source code only when executing specified procedure
STEP RATE............Establish automatic stepping rate for source-level debugging
STORE................Assign a value to one or more variables
SUM..................Sum numeric expressions to variables
SYNTAX...............Display the Syntax of a command or function
TAG..................Tag or Untag records in the current work area
TAG BROWSE...........Tag or Untag records with a browse-style pick-list
TAG CLEAR ALL........Clear all record tags in the current work area
TC | TIMECUBE........Call the Time-Cube Ap,ointment Scheduler System
TOTAL................Summarize records by key value to another data file
TRACE................Enable/Disable profiling of executing procedure
TRACE CLEAR..........Remove TRACE expressions from the TRACE table
TRACE CONVERT........Merge TRACE file debug information with source code
TRACE ONLY...........Trace code execution only when executing specified procedure
TUTOR................Run Tutoring system for Clipper/dCLIP commands and functions
TYPE.................Display the contents of a text file
UNLOCK...............Release file/record locks set by the current user
UPDATE...............Update active data file from another data file
USE..................Open an existing data file and its associated files
USE ALL..............Open all data files matching a specified wildcard
USE...DBFMDX.........Open an existing data file and its associated files
USER EDIT............Maintain the DCUSER.DBF User database
USER LOGON...........Log On to system to establish user rights
UTILITIES............A menu of database utilities
VIEW.................View the contents of the selected record
VIEW LIBS............View status of dynamic-libraries and "dynamic-linked" .OBJs
WAIT.................Suspend program processing until a key is pressed
WATCH................Load an expression into the WATCH table
WATCH CLEAR..........Clear an expression from the WATCH table
WHERE................Locate the name of the .OBJ/.PRG that contains a function
WHERE EXTERNAL.......Scan all .OBJs to locate calls to a specified function
WHERE PUBLIC.........Scan all .OBJs to find a public procedure/function
WHILE................Evaluate set of expressions while an expression is true
WORK CONVERT.........Convert a dCLIP 2.5 DCDBF.DBF to .DCW file(s)
ZAP..................Remove all records from the current database
REPLACE DATA
Replacing data in database fields
Description:
This selection will replace the data in a list of specified
fields in the currently selected database.
-- Example A --
To zero out the current balance and year-to-date sales of
ALL customers in the CUSTOMER.DBF file. Enter the
information as follows:
Field Name #1 : ACCT_BAL
Replace with : 0
Field Name #2 : YTD_SALES
Replace with : 0
-- Example B --
To set a Credit Limit of $1000.00 for all customers with
an Account Balance between $500.00 and $1500.00. Enter
the information as follows:
Field Name #1 : CRED_LIMIT
Replace with : 1000
Condition : ACCT_BAL)=500 .AND. ACCT_BAL(=1500
See Also:
UTIL
dc_util()
READ
Activate full-screen editing mode with Get Objects
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_readmodal()
RECALL
Restore records marked for deletion
Syntax:
Arguments:
See Clipper 5.0 Guides
Description:
RECALL works identical to the Clipper RECALL command except a
progress odometer will display the number of records scanned
and the number of records that were actually recalled.
See Also:
DELETE
REDO
Execute "dynamic-linked" procedure after re-linking the .OBJ
Syntax:
Arguments:
(procedure) is the name of the procedure or function to
execute.
(parameter1) - (parameterN) are parameters to be passed to the
procedure.
Description:
REDO functions exactly the same as the DO (procedure) command
except that it first releases the (procedure) from memory so
the latest version will be "dynamic-linked" and run. REDO is
not necessary to if you compile changes with the CLIPPER
command from the dot prompt, because CLIPPER will also release
the old object from memory after re-compiling. Use REDO
instead of DO only if you made changes to the .OBJ file through
some other method, such as via the DOS gateway.
Examples:
. OBJ MYAPP
. DO MYAPP
. DOS
Type EXIT to return to dCLIP ) CLIPPER MYAPP
Type EXIT to return to dCLIP ) EXIT
. REDO MYAPP
See Also:
DO
OBJ
OBJ RELE
REINDEX
Rebuild open indexes in the current work area
Syntax:
Arguments:
The following optional arguments are available only when the
data file in the current work area has been opened with the
DBFFOX Replaceable Database Driver:
OPTION (expUDF) is an expression (normally a UDF) that is
evaluated for each record indexed. This allows the program to
display an Index-o-meter without having the UDF embedded in the
index expression.
The expression is first eval'd at the beginning of the index
process, with the record pointer positioned at EOF. The
following eval's take place at record 1, 2, etc. The record
number can be tested within your UDF using RECNO().
STEP (nRecs) is used to specify how often the OPTION expression
will be eval'd. (nRecs) is a numeric value representing the
number of records that will be processed before the OPTION
expression is evaluated. For example:
REINDEX OPTION MyFunc() STEP 10
In this example MyFunc() would be called every 10 records. The
default step value is 1.
Description:
REINDEX will re-build all open indexes in the current work area
including tags in .CDX combined indexes.
Examples:
. USE MAILLIST FOX INDEX MAILLIST, ZIPS
. REINDEX OPTION ODDOMETER() STEP 100
RENAME
Change the name of a file
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_rename()
REPLACE
Assign new values to field variables
Syntax:
Arguments:
See Clipper 5.0 Guides
Description:
REPLACE works identical to the Clipper REPLACE command except
a progress odometer will display the number of records scanned
and the number of records that were actually replaced.
See Also:
dc_replace()
REPLACE IMPORT
Replace data in current record from import file record
Syntax:
Arguments:
None
Description:
REPLACE WITH IMPORT is used to replace data in the fields which
are defined in a Field Map (.DCF) file that was previously
loaded with the IMPORT LOAD (file) command.
Examples:
. use dcusers // registered users database
. use customer new // customer database
// map customer.dbf fields to dcuser.dbf fields
. import create dcusers from customer to dcusers
. import load dcusers // load dcusers.dcf map file
. select customer
. browse // select a record to import to dcusers.dbf
. select dcusers
. append blank
. REPLACE WITH IMPORT
REPLACE VIRTUAL
Replace the current record with the Virtual record
Syntax:
Description:
REPLACE WITH VIRTUAL is used to replace the current record with
the contents of the virtual record. A virtual record is
created by capturing the contents of any record to a .DCV file
with the SAVE TO VIRTUAL command.
Examples:
. USE MAILLIST
. GO 2345
. SAVE TO VIRTUAL
. APPEND BLANK
. REPLACE WITH VIRTUAL
See Also:
SAVE VIRTUAL
dc_virtreplace()
REPORT
A report and label form manager
Syntax:
Arguments:
NONE
Description:
REPORT will invoke a report form manager that uses a database
to integrate report (*.FRM) and label (*.LBL) files with work
(*.DCW) files to edit and run columnar reports and
continuous labels.
A database named DCRLFRM.DBF is used for the integration. If
this database does not exist it will be created.
See Also:
dc_report()
REPORT FORM
Display a report to the console or printer
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
MODIFY REPORT
dc_frmout()
REPORT
RESTORE ARRAY
Retrieve a multi-dimensional array from an array file
Syntax:
Arguments:
(aArray) is the name of the multi-dimensional array to create.
(cArrayFile) is the name of the array text file to use to
create the multi-dimensional array. If no extension is given,
then .DCA is assumed.
Description:
RESTORE ARRAY is used to create a multi-dimensional array from
the contents of an array file created with the SAVE ARRAY
command.
Notes:
The structure of the array file will look like this:
,A,3
[1],N,1
[2],A,3
[2][1],C,This is a string
[2][2],L,Y
[2][3],N,12345.67
[3],A,4
[3][1],C,{||qout(time())}
[3][2],C,This is another string
[3][3],C,This is still another string
[3][4],D,12/12/91
Examples:
. DIR := DIRECTORY('*.OBJ')
. SAVE ARRAY DIR TO OBJLIST
. RESTORE ARRAY DIR2 FROM OBJLIST
. DISPLAY ARRAY DIR2
See Also:
SAVE ARRAY
dc_array_read()
dc_arestore()
RESTORE FROM
Retrieve variables from a (.MEM) file
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
SAVE TO
RESTORE SCREEN
Display a saved screen
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
SAVE SCREEN
RESTORE SET
Restore the SET environment from a file
Syntax:
Arguments:
(xcSetFile) is the name of the file containing the contents of
the environment saved by the SAVE SET TO command. If no
extension is given, then .DCA is assumed.
Description:
RESTORE SET is used to restore the SET environment from a file
previously created with the SAVE SET command. The SET
environment is the 38 standard Clipper SETs such as SET CURSOR,
SET DEFAULT, etc. and the additional dCLIP SETs such as SET
ODIR, SET PROMPT, etc.
Examples:
. SAVE SET TO MYENVIR
. DO SOMETHING
. RESTORE SET FROM MYENVIR
See Also:
SAVE SET
dc_setrestore()
dc_setsave()
RESTORE TAGS
Rebuild all tags in a .CDX file from a Tag file
Syntax:
Arguments:
FROM (xcTagFile) is the name of a file which contains the
structure of all the tags in a .IDX or .CDX index previously
created by the SAVE TAGS command or SAVE WORK command. If no
extension is given then .DCT is assumed.
Description:
RESTORE TAGS is used to rebuild all the tags in a .CDX file
from a structure file created with the SAVE TAGS command. Use
RESTORE TAGS if you encounter a corrupted index.
Examples:
. USE MAILLIST FOX
. INDEX ON ZIP TAG ZIP
. INDEX ON PHONE TAG PHONE
. INDEX ON SOURCE TAG SOURCE
. SAVE TAGS
. CLOSE
. DOS
) DELETE FILE MAILLIST.CDX
) EXIT
. USE MAILLIST FOX
. RESTORE TAGS
See Also:
SAVE TAGS
dc_tagrestore()
RESTORE WORK
Open data files/indexes from information in a (.DCW) file
Syntax:
Arguments:
(xcWorkFile) is the name of a work file which was previously
created by the SAVE WORK command. If no extension is given
then .DCW is assumed.
ADDITIVE is an optional clause which will insure that currently
used work areas are not affected. If a database is already
opened in a work area, it will not be reopened in a new work
area. If the ADDITIVE clause is not used, then all work areas
will be closed before restoring the old work.
QUIET is an optional parameter that suppresses the display of
work area information on the screen as it is being saved.
If the QUIET option is not used, then the names of the data-
bases restored will be displayed and scrolled in a window as
they are being opened, followed by "press any key...". Use
this option to open databases with no visual affects or
prompting required from the user.
EXCLUSIVE will override the default settings and open all files
in Exclusive (not shared) mode.
Description:
RESTORE WORK is used to restore a complete work area
environment from a .DCW work file created with the SAVE WORK
command. RESTORE WORK will accomplish the following:
* Re-open all databases, using the required RDD (Replaceable
Data Driver).
* Open all indexes or rebuild indexes that don't exist or have
not been properly updated.
* Set parent-child relations.
* Restore record, index and tag pointers.
* Restore browse windows.
* Restore filters.
* Restore Database environment such as PATH, DEFAULT, UNIQUE,
etc.
Examples:
. USE MAILLIST FOX
. INDEX ON ZIP TAG ZIP
. INDEX ON PHONE TAG PHONES
. USE CUSTOMER FOX NEW INDEX CUSTNMBR
. USE INVOICE FOX NEW INDEX INVOICE
. SET RELATION TO CUST_NMBR INTO CUSTOMER
. BROWSE TILE WINDOW 3
. SAVE WORK TO MYWORK
. CLOSE ALL
. RESTORE WORK FROM MYWORK
See Also:
SAVE WORK
dc_workrestore()
dc_fileedit()
FILE EDIT
RESUME
Resume searching additional keys after a HUNT
Syntax:
Arguments:
None
Description:
RESUME is used to continue searching keys for the value entered
at the last HUNT operation. Use RESUME if you have the
following scenario:
You have three indexes on the fields LAST_NAME, COMPANY and
SOURCE. If you enter the command HUNT SCOTT, then the LAST_NAME
index will be seeked to find the first occurrence of the name
SCOTT. If SCOTT is found in the last name, but what you were
really looking for is a company starting with SCOTT, enter the
command RESUME to continue the seek starting at the next index.
Examples:
. USE MAILLIST FOX INDEX MAILLIST
. HUNT SCOTT
. BROWSE
. RESUME
. BROWSE
. RESUME
. BROWSE
Source/Library:
_DCTRAN3
See Also:
HUNT
dc_hunt()
RUN | !
Run another DOS program
Syntax:
Arguments:
MEMO
Description:
RUN is similar to the Clipper RUN command except it is not
necessary to reserve sufficient memory to call other programs.
The RUN command utilizes the DOS gateway system in dCLIP to
save the memory image of the dCLIP environment to a temporary
file, release all memory, run the executable program or dos
command, then restore memory.
Notes:
RUN requires that a temporary memory image file be created. It
is recommended that you use the SET SWAP command or use the
DCLIP.SYS SWAP=(drive) command to establish the path for
creating the file.
Examples:
. SET SWAP TO G:;F:\PUBLIC
. RUN PCTOOLS
See Also:
SET SWAP
dc_gateway()
GATE
SAVE ALL
Save variables to a (.MEM) file
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
RESTORE FROM
SAVE ARRAY
Save a multi-dimensional array to an array file
Syntax:
Arguments:
(aArray) is the name of the public/private multi-dimensional
array to save.
(cArrayFile) is the name of the array text file to create from
the contents of the array. If no extension is given, then .DCA
is assumed.
Description:
SAVE ARRAY is used to save a multi-dimensional array to a text
file which can be later restored with the RESTORE ARRAY
command.
Notes:
The structure of the array file will look like this:
,A,3
[1],N,1
[2],A,3
[2][1],C,This is a string
[2][2],L,Y
[2][3],N,12345.67
[3],A,4
[3][1],C,{||qout(time())}
[3][2],C,This is another string
[3][3],C,This is still another string
[3][4],D,12/12/91
Examples:
// Save the Browse array for work area 1
. aBROWSE := DC_BROWASAVE(1)
. SAVE ARRAY aBROWSE TO MYBROWSE
. RESTORE ARRAY MYBROWSE TO aBROWSE2
// Create a Browse array for work area 2
// that is a clone of work area 1
. DC_BROWAREST(2,aBROWSE2)
See Also:
RESTORE ARRAY
dc_array_write()
dc_asave()
SAVE SCREEN
Save current screen to a buffer or variable
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
RESTORE SCREEN
SAVE SET
Save the SET environment to a file
Syntax:
Arguments:
(xcSetFile) is the name of the file to create. If no extension
is given, then .DCA is assumed.
Description:
SAVE SET is used to save the SET environment to a file. The SET
environment is the 38 standard Clipper SETs such as SET CURSOR,
SET DEFAULT, etc. and the additional dCLIP SETs such as SET
ODIR, SET PROMPT, etc.
Examples:
. SAVE SET TO MYENVIR
. DO SOMETHING
. RESTORE SET FROM MYENVIR
See Also:
RESTORE SET
dc_setsave()
SAVE TAGS
Save info about all open indexes to a .DCT file
Syntax:
Arguments:
TO (xcTagFile) is the name of the file to create. If no
extension is given then .DCT is assumed.
Description:
SAVE TAGS is used to save the structure of all the tags in an
open "combined" index file or in a set of open individual
index files to a .DCT file.
A .DCT file contains all the information needed to recreate
the combined indexes or individual indexes by using the
RESTORE TAGS command or DC_TAGRESTORE() function.
Use SAVE/RESTORE TAGS to convert one type of index to another.
For example, let's say you have a database named CUSTOMER.DBF
that uses indexes named NAME.NTX, COMPANY.NTX, ZIP.NTX and
PHONE.NTX. To create a new "combined" index named CUSTOMER.CDX
from the .NTX files simply do the following:
. USE CUSTOMER VIA DBFNTX INDEX NAME,COMPANY,ZIP,PHONE
. SAVE TAGS
. USE CUSTOMER VIA DBFSIX
. RESTORE TAGS
Use SAVE/RESTORE TAGS to save information about a combined
index so you may rebuild the index in the event that it becomes
deleted or corrupted.
Examples:
. USE MAILLIST FOX
. INDEX ON ZIP TAG ZIP
. INDEX ON PHONE TAG PHONE
. INDEX ON SOURCE TAG SOURCE
. SAVE TAGS
. CLOSE
. DOS
) DELETE FILE MAILLIST.CDX
) EXIT
. USE MAILLIST FOX
. RESTORE TAGS
See Also:
RESTORE TAGS
dc_tagrestore()
SAVE TO
Save variables to a (.MEM) file
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
RESTORE FROM
SAVE VIRTUAL
Save the current record to the Virtual record
Syntax:
Description:
SAVE VIRTUAL is used to save the contents of the current record
to a virtual record. A virtual record is a file with the same
prefix as the database alias and with the extension .DCV.
The virtual record can then be used at any time to replace the
contents of specified records in the same database by using the
REPLACE WITH VIRTUAL or INSERT VIRTUAL commands.
Examples:
. USE MAILLIST
. GO 2345
. SAVE VIRTUAL
. APPEND BLANK
. REPLACE WITH VIRTUAL
. GO 1000
. INSERT VIRTUAL 10
See Also:
dc_virtsave()
SAVE WORK
Save Information about all work areas to a (.DCW) file
Syntax:
Arguments:
(xcWorkFile) is the name of a work file to create. If no
extension is given then .DCW is assumed. The work file created
will have the same structure as a .DBF database file and can be
edited or browsed at any time with standard database commands.
(cDescription) is the description to write to the .DCW file.
If none is given, then the user will be prompted to enter a
description.
QUIET is an optional parameter that suppresses the display of
work area information on the screen as it is being saved.
Description:
SAVE WORK is used to save a complete work area environment.
SAVE WORK will accomplish the following:
* Save the names and paths of all databases, including the RDD
(Replaceable Data Driver).
* Save information about all tags and index so they can be re-
built if they become corrupted or deleted.
* Save parent-child relations.
* Save record, index and tag pointers.
* Save browse window arrays.
* Save filters.
* Save Database environment such as PATH, DEFAULT, UNIQUE, etc.
Examples:
. SET DEFAULT TO \MYFILES
. USE MAILLIST FOX
. INDEX ON ZIP TAG ZIP
. INDEX ON PHONE TAG PHONES
. USE CUSTOMER FOX NEW INDEX CUSTNMBR
. USE INVOICE FOX NEW INDEX INVOICE
. SET RELATION TO CUST_NMBR INTO CUSTOMER
. BROWSE TILE WINDOW 3
. SAVE WORK TO MYWORK AS 'My Customer and Maillist Files'
. CLOSE ALL
. RESTORE WORK FROM MYWORK
See Also:
RESTORE WORK
dc_worksave()
SCREEN DELETE
Delete a Screen Group in Screen Dictionary
Syntax:
Arguments:
(cGroup) is the name of the screen group in DCSCRN.DBF
to delete (up to 8 characters). If no parameter is passed
then a pick-list of available screen groups will be
displayed.
Description:
SCREEN PAINT will retreive a screen array from the DCSCRN.DBF
screen dictionary and paint the screen with the contents of
the screen objects in the array.
Examples:
// Load a screen group from the dictionary and paint scrn //
SCREEN PAINT MAIN
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_scrnedit()
SCREEN EDIT
A Screen Designer/Editor
Syntax:
Arguments:
(cGroup) is the name of the screen group in DCSCRN.DBF
to edit (up to 8 characters). If no parameter is passed
then a pick-list of available screen groups will be
displayed.
Description:
SCREEN EDIT is a screen designer/editor that facilitates
the drawing and locating of screen "objects". The objects
are stored to an array and/or the DCSCRN.DBF data-dictionary
file.
Screen objects can be text, fill-areas, boxes, regular
input GETS, radio-buttons or check-boxes.
Notes:
The DCSCRN.DBF database and its associated indexes will
be created by DC_ScrnOpen() if they do not already exist.
Examples:
-- Example 1 --
// Load a screen group from the dictionary and edit it //
SCREEN EDIT
-- Example 2 --
// Edit screen group "MAIN"
SCREEN EDIT GROUP MAIN
-- Example 3 --
// Edit a screen group array and paint the screen //
SCREEN EDIT GROUP MAIN
screen paint group main
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_scrnedit()
SCREEN PAINT
dc_scrnpaint()
SCREEN PAINT
Paint a screen from a Screen Group in Screen Dictionary
Syntax:
Arguments:
(cGroup) is the name of the screen group in DCSCRN.DBF
to paint (up to 8 characters). If no parameter is passed
then a pick-list of available screen groups will be
displayed.
Description:
SCREEN PAINT will retreive a screen array from the DCSCRN.DBF
screen dictionary and paint the screen with the contents of
the screen objects in the array.
Examples:
// Load a screen group from the dictionary and paint scrn //
SCREEN PAINT MAIN
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_scrnedit()
SCREEN EDIT
dc_scrnpaint()
SEARCH
Scan all fields of specified databases for matching string
Syntax:
Arguments:
(cAlias) is the alias name of the database to search.
ALL will search all databases in all open work areas.
FOR (cValue) is the value to compare for a match. All fields
which contain the value will be listed in the display or
output.
TO PRINT will output the results of the search to the printer.
TO FILE (xcOutFile) will output the results of the search to an
ASCII text file.
Description:
SEARCH is used to search all fields of specified work areas for
matching text and list all occurences of found text.
The output can be sent to the screen, printer or a file and all
occurrences where the text is found will be listed as follows:
File Record Field Text
----------- ------ ------------ ---------------------------
CUSTOMER 123 PHONE 714-555-1212
MAILLIST 23567 PHONE_NUM (619)555-1212
Notes:
The operation of the SEARCH command has been changed from
previous versions of dCLIP to be more compatible with
replaceable database drivers.
Examples:
. USE CUSTOMER VIA 'PDX'
. USE MAILLIST VIA 'DBFFOX'
. SET RDD TO DBFNTX
. USE ALL LIKE DC*
. SEARCH ALL FOR 555-1212 TO SRCHFILE.TXT
See Also:
dc_search()
ASSIST
SEEK
Search an index for a specified key value
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_find()
SELECT
Change the current work area
Syntax:
Arguments:
(cAlias) is the alias name of the work area to select.
(nArea) is the work area number to select.
No arguments will pop up a pick-list of open database aliases.
See Also:
dc_select()
dc_dbsel()
SET
Pop-up an editing screen for all SET environment variables
Syntax:
Arguments:
(set identifier) is a mnemonic which identifies the specific
SET value to observe or modify.
For example, SET DEFAULT will pop-up the SET environment editor
and highlight DEFAULT.
No argument will place the high-light on the first SET item.
Description:
SET is used to invoke an editor for observing or modifying the
value of any SET value in the environment.
The SET environment is the 38 standard Clipper SETs such as SET
CURSOR, SET DEFAULT, etc. and the additional dCLIP SETs such as
SET ODIR, SET PROMPT, etc.
Examples:
. SET
. SET PATH
See Also:
dc_setedit()
SET ALTERNATE
Toggle console output to a text file
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
DCLIP.SYS
SET ALTERNATE TO
Define the text file for routing console output
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
DCLIP.SYS
SET AUTOINDEX
Automatically open index files
Syntax:
Arguments:
ON will automatically open indexes.
OFF will disable the automatic index-open feature.
Description:
SET AUTOINDEX is used to automatically open index files when using
the DBFNTX driver in the same way that a production index in
automatically opened when using the COMIX, DBFCDX or SIXCDX driver.
A new system setup variable name AUTOINDEX has been added. The
default is OFF. When set to ON then index files with the same
prefix as the Alias() and containing an index key that matches the
alias will automatically be opened with the USE command.
Examples:
Let's say the following files exist in the Default directory:
DM004.DBF
DM0041.NTX
DM0042.NTX
DM0043.NTX
They will all be opened with the following commands:
SET AUTOINDEX ON
USE DM004
or
USE DM004 AUTOINDEX
See Also:
AUTOINDEX
dc_useaindex()
SET AUTOLOCK
Toggle Automatic Record/File Locking
Syntax:
Arguments:
ON will automatically lock and unlock the current record or
file whenever a dot-prompt command is issued that requires a
lock. (DEFAULT).
OFF will disable the automatic record-locking feature.
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET AUTOLOCK is used to enable or disable the automatic
record-locking feature of dCLIP when using certain dot prompt
commands. Many Clipper commands will require a record lock
whenever the command modifies data in the current work area.
If AUTOLOCK is ON, then the record lock is issued
automatically. If AUTOLOCK is OFF, then the RLOCK() function
or LOCK command must be issued at the dot-prompt otherwise a
"lock required" error may be displayed.
SET AUTOLOCK will not affect any application code or any dCLIP
menus, only commands issued at the dot prompt.
Examples:
. USE SALES SHARED
. SET AUTOLOCK OFF
. DELETE
Lock Required DBFNTX[1022]
. SET AUTOLOCK ON
. DELETE
. RECALL
See Also:
AUTOLOCK
dc_reclock()
SET BATCH
Create a specified command to run a batch file
Syntax:
Arguments:
(cCommandVerb) is the name of the command you wish to use at
the dot prompt execute the batch file.
(xcBatchFile) is the name of the batch file to run when the
(cCommand Verb) is entered at the dot prompt. If no extension
is given, then .DCB is assumed.
Description:
SET BATCH adds command verbs to a table of commands for
processing batch (.DCB) files from a single verb command. This
is a handy method of creating quick commands to run batch
files.
Examples:
// Batch file MYMOVE.DCB contains the following commands:
// COPY FILE %1 %2
// ERASE %1
. SET BATCH TO MOVE, MYMOVE.DCB
. MOVE \DCLIP\MYFILE.TXT \JUNK
See Also:
BATCH =
dc_batch()
SET BELL
Toggle Bell sounding during full screen operations
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET CHRKEY
Define the key assignment for the ASCII-table pick-list
Syntax:
Arguments:
(nInkey) is the same as the INKEY() value for the desired key
to press to invoke the field pick-list.
Description:
The ALT-G key is the default key to invoke the Ascii-Table
pick-list for selecting an ascii character to insert into
the command line editor at the current cursor location.
If you wish to reassign this key to prevent conflict with
other hot-keys, then use this command.
Examples:
// Define ALT-P as the field list key
FLDKEY = 281
See Also:
CHRKEY =
CHR
dc_chrsel()
SET CLIPOPT
Define standards options for the Clipper compiler
Syntax:
Arguments:
(compiler options) is a list of options you want to pass to the
Clipper.exe compiler.
Description:
SET CLIPOPT TO is used to establish a set of default options to
be used by the Clipper.exe compiler when the CLIPPER command is
used at the dot-prompt to compile programs.
Examples:
. SET CLIPOPT TO /i\CLIPPER5\INCLUDE/n/w/b
. CLIP MYAPP
See Also:
CLIPOPT =
CLIPPER
dc_turbedit()
/
SET CLIPPATH
Set the search directory for CLIPPER.EXE compiler
Syntax:
Arguments:
(directory) is the name of the directory in which the
CLIPPER.EXE compiler exists. If CLIPPER.EXE is in your dos
path, then SET CLIPPATH is not necessary.
Description:
SET CLIPPATH is used to define the directory in which the
CLIPPER.EXE compiler resides for dCLIP compiler operations.
Examples:
. SET CLIPPATH TO \CLIPPER5\BIN
. CLIP MYAPP
See Also:
CLIPPATH =
CLIPPER
/
dc_turbedit()
SET CLOAK
Toggle hiding compiler copyright message
Syntax:
Arguments:
ON will prevent the Clipper.exe compiler from displaying it's
copyright message.
OFF will allow the Clipper.exe compiler to display it's
copyright message.
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET CLOAK is used to hide or unhide the copyright message of
the Clipper.exe compiler when the CLIPPER command is used at
the dot prompt or when executing Compile and run operations
from the Turbo- editor or TUTOR system. SET CLOAK OFF is
intended to provide a more seamless interface with less
corruption of the display. SET CLOAK OFF requires that a file
named CLOAK.EXE (distributed with dCLIP) be installed in the
same directory as the CLIPPER.EXE compiler.
Examples:
. SET CLOAK ON
. CLIP MYAPP
See Also:
dc_sett()
CLOAK =
SET COLOR
Define screen colors
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET COMMAND
Create a single-verb command to run a DOS program
Syntax:
Arguments:
(cVerb) is the name of the command to assign to the operation.
(cDosProgram) is the name of the DOS command or .BAT, .EXE,
.COM file to execute when the (cVerb) is entered at the
dot-prompt.
(nMemory) is the amount of memory to release from dCLIP and
give to the (cDosProgram). Enter 0 to release all available
memory.
(cSwapPath) is the directory to create a temporary file for
saving the memory image. To improve speed it is recommended
that you swap to a Ram disk.
(cAltPath) is the directory to write the remains of the
temporary file in the event that (cSwapPath) fills up when
creating the memory image.
Description:
SET COMMAND is used to create a pseudo-command verb for running
other DOS programs via the dCLIP gateway system. Commonly used
programs can be brought into the dCLIP environment by creating
commands to invoke them from the dot-prompt in the same way
they would be used at the dos prompt.
Notes:
To use the dos command simply enter the (cVerb) at the
dot-prompt followed by any parameters you wish to send to the
program you are running.
Examples:
. SET COMMAND TO TAP, TAPCIS, 500, D:;F:\PUBLIC
. SET COMMAND TO DW, DIR/W, 50, D:
. SET COMMAND TO Q, QEDIT, 256, D:;C:
. TAP // Run TAPCIS.EXE
. DW *.PRG // Run DIR/W *.PRG
. Q MYAPP.PRG 45 // Run QEDIT MYAPP.PRG 45
See Also:
COMMAND =
SET CONFIRM
Toggle required exit key to terminate GETs
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET CONSOLE
Toggle console display to the screen
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET CUA
Toggle CUA-Compliance mode for terminating Gets
Syntax:
Arguments:
ON will set the CUA-compliant mode ON.
OFF will set the CUA-compliant mode OFF.
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Returns:
A logical value equivalent to the previous setting.
Description:
SET CUA is used to set the CUA-Compliant mode for
terminating a table of GETS. The normal termination method
is CTRL-W or CTRL-END, whereas the CUA-Compliant method of
terminating a table of GETS is the ENTER key. In both modes
the TAB key will move to the next get and the SHIFT-TAB key
will move to the previous get.
CUA-Compliant mode is consistent with IBM and Windows software
systems.
Examples:
/* -- Set CUA-compliance ON -- */
SET CUA ON
Source/Library:
_DCGETSY.PRG/.OBJ, DCLIP.LIB
See Also:
dc_readcua()
SET CURSOR
Toggle the screen cursor on or off
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET DATE
Set the date format for input or display
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET DCLIP
Set the directory to use for dCLIP data-dictionary files
Syntax:
Arguments:
(pathspec) is any valid directory which may also include a
drive letter.
Description:
SET DCLIP is used to establish the directory which will be
searched for creating dCLIP DC*.DBF databases and indexes.
If the files do not exist in this directory then they will be
created. dCLIP establishes the default for this value in the
following order:
1. Uses the value in any SET DCLIP=(directory) statement in
the DOS environment.
2. Uses the directory in which the .EXEcutable program
resides.
See Also:
SET DCLIP
dc_setdclip()
SET DEBUG
Toggle the enabling of the ALT-D key for debugging
Syntax:
Arguments:
ON will enable the ALT-D key to invoke a debug dot-prompt.
OFF will disable the ALT-D key.
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Examples:
. SET DEBUG ON
. DO MYAPP
. SET DEBUG OFF
. DO MYAPP2
See Also:
dc_sett()
SET =
SET DECIMALS
Set the number of decimal places displayed
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET DEFAULT
Set the default drive and directory for data files
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_setdefault()
SET DELETE
Toggle filtering of deleted records
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET DELIM
Toggle GET delimeters
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET DELIM TO
Define GET delimeters
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET DEVICE
Direct @...SAYs to screen or printer
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET DOSKEY
Set Clipper command stack operation to Dos-Key emulation
Syntax:
Description:
SET DOSKEY is used to set the behavior of the dot-prompt
command stack navigator to emulate that of DOS command
stack navigators like Dos-Key or OS/2.
The normal behavior allows commands to be reissued in
sequence and expedite processes that are used again and
again. Dos-Key emulation automatically copies the selected
command to the bottom of the stack after execution and
creates a blank command line for input.
Examples:
SET DOSKEY ON
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_dotdoskey()
SET DOTSTACK
Increase/Decrease the size of the Dot-prompt command stack
Syntax:
Arguments:
(nSize) is a number from 100 to 4000.
Description:
SET DOTSTACK is used to increase the length of the Dot-Prompt
command stack array to a value greater than the default value
of 100 commands. This is desirable in the event that it is
necessary to save and restore more than the last 100 commands
with the HISTORY=(file) command in your DCLIP.SYS.
Examples:
SET DOTSTACK TO 500
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_dotsize()
DOTSTACK
SET ECHO
Toggle Display of commands to console when running .DCB file
Syntax:
Arguments:
ON will enable the Echoing of commands to the console.
OFF will disable the Echoing of commands.
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET ECHO is used to enable or disable the echoing of commands
to the console when executing a .DCB batch file.
Examples:
. SET ECHO ON
. BATCH MYBATCH
See Also:
SET TALK
SET EDITOR
Define the default editor for the IDE system
Syntax:
Arguments:
(cFileName) is the name of the editor .COM, .BAT or .EXE
file to run when using the EDIT command.
(nMemorySwap) is the amount of memory to release and save to
disk to run the program. The default is (K). Enter 0 to
release all memory except shell.
(cPathSpec) is the name of primary and secondary Disk
Drive/Directory (separated by a semicolon) to save the memory
image.
A temporary file is created on the first drive if space is
available. If no space is left on the first drive/directory
then the remainder of the memory image is created on the second
specified drive/directory. The temporary file is erased
returning from your editor.
Optional: [H] - Set High Resolution mode (43/50 lines)
[L] - Set Low Resolution mode (25 lines)
Description:
SET EDITOR is used to define the name and path of the default
editor you wish to use when using the IDE
(integrated-development-environment) features of dCLIP, such as
the EDIT command and re-editing after compiler errors.
Examples:
EDITOR = QEDIT,256,D:;F:\PUBLIC,H
See Also:
EDITOR =
EDIT PRG
dc_editprg()
SET ESCAPE
Toggle ESCape as a READ exit key
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET EXACT
Toggle Exact matches for character strings
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET EXCLUSIVE
Establish Shared or Exclusive use of database files
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET EXPLODE
Toggle activation of Exploding Windows
Syntax:
Arguments:
ON will enable Exploding windows - DEFAULT
OFF will disable Exploding windows.
Description:
SET EXPLODE is used to enable or disable the "exploding"
feature of dCLIP windows. SET EXPLODE OFF to improve the speed
of painting windows on slower computers.
See Also:
dc_explmode()
EXPLODE =
dc_explode()
SET FILTER
Hide records not meeting a condition
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET FIXED
Toggle fixing the number of decimals displayed
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET FLDKEY
Define the key assignment for the field pick-list
Syntax:
Arguments:
(nInkey) is the same as the INKEY() value for the desired key
to press to invoke the field pick-list.
Description:
The ALT-F key is the default key to invoke the Field List
window for selecting a field from the currently selected
database and/or relational databases. If you wish to reassign
this key to prevent conflict with other hot-keys, then use this
command.
Examples:
// Define ALT-P as the field list key
FLDKEY = 281
See Also:
FLDKEY =
dc_fields()
SET FORMAT
Activate a Format when READ is executed
Syntax:
Arguments:
See Clipper 5.0 Guides
SET FUNCTION
Assign a character string to a function key
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET HELP
Toggle the echoing of command syntax after a syntax error
Syntax:
Arguments:
ON will enable the Echoing of syntax to the console.
OFF will disable the Echoing of syntax.
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET HELP is used to echo the proper syntax for a command in the
event that the command is improperly entered at the dot prompt.
SET INDEX
Open index file(s) in the current work area
Syntax:
Arguments:
(xcIndex list) is a list of up to 15 index (.ntx, .ndx, .cdx,
.mdx, etc.) filenames, separated by commas. Any reference to
an index filename that results in either a null string ("") or
spaces is ignored. Each index file can be specified as a
literal filename or as a character expression enclosed in
parentheses. If an extension is not specified, a default
extension is supplied by the current database driver. (.ntx)
is the extension supplied by the Clipper driver and (.ndx) the
extension supplied by the dBASE III PLUS driver.
SET INDEX TO without an argument closes all indexes open in the
current work area.
The ADDITIVE clause will cause existing index files to remain
open an additional indexes will be added to the list of open
indexes, otherwise all currently open indexes will be closed
first.
The ? clause will pop-up a pick-list of index files that exist
in the current DEFAULT directory.
ORDER (nTag) will establish the order of the controlling index.
ORDER TAG (cTag) will establish the controlling index tag.
This option is available only with drivers supporting combined
indexes, i.e, DBFSIX and DBFMDX. OF (xcCombinedIndex)
specifies the combined index file from which to choose the
controlling index tag.
Description:
SET INDEX opens the specified index files in the current work
area. When more than one index file is opened, the first index
becomes the controlling index. The record pointer is initially
positioned at the first logical record in the index. During
database file processing, all open indexes are updated whenever
a key value is appended or changed. To change the controlling
index without issuing another SET INDEX command, use SET ORDER
or SET TAG.
SET INDEX is used primarily to open index files in a network
environment in place of the INDEX clause of the USE command.
Generally, you USE the (xcDatabase) and then test to determine
if the USE succeeded. If it did, you then open the associated
indexes with SET INDEX.
Examples:
. USE MAILLIST
. SET INDEX TO NAME, ZIP, PHONE
See Also:
dc_setindex()
USE
SET INDEXKEY
Define the key assignment for the index-builder
Syntax:
Arguments:
(nInkey) is the same as the INKEY() value for the desired key
to press to invoke the field pick-list.
Description:
The ALT-I key is the default key to invoke the Index Builder
for creating index expressions from field pick-lists when
entering INDEX ON commands at the command line.
If you wish to reassign this key to prevent conflict with
other hot-keys, then use this command.
Examples:
// Define ALT-P as the field list key
FLDKEY = 281
See Also:
INDEXKEY =
SET INTENSITY
Toggle enhanced display of GETs and PROMPTs
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET KEY
Assign a procedure invocation to a key
Syntax:
Arguments:
See Clipper 5.0 Guides
SET MARGIN
Set the page offset for all printed output
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET MESSAGE
Set the @...PROMPT message line row
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_menu_to()
MENU TO
dc_at_prompt()
SET ODIR
Specify the directory to place .OBJ files after compiling
Syntax:
Arguments:
(cObjDirectory) is the directory name to place .OBJ files.
Description:
SET ODIR is used to define the drive and directory to place
.OBJ files when compiling .PRGs with the CLIPPER command.
Examples:
. SET ODIR TO \MYAPPS\OBJ
. CLIP MYMENU
. CLIP MYPROCS
See Also:
OBJ LOAD
dc_objload()
CLIPPER
SET ODPERCENT
Set numeric value for progress indicator percentage of update
Syntax:
Arguments:
(nPercent) is a numeric value for the percentage of update
you want on the progress odometer. If you have very large
files and want to see progress more often, then it is
recommended you lower this number from the default of 5
percent.
Description:
SET ODPERCENT sets how often to update the progress
indicator odometer when using DC_ODOMETER() or
DC_ODBLOCK().
Examples:
SET ODPERCENT TO 1 // 1 percent
index on cust_nmbr to custnmbr
See Also:
dc_odpercent()
dc_odometer()
dc_odblock()
SET ORDER
Set a new controlling index file
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
SET TAG
dc_tagsel()
SET ORDER .. TAG
Set a new controlling index Tag
Syntax:
Arguments:
TAG (cTagName) specifies the name of the tag to set the order
to. If a combined index file is not specified, then the open
combined indexes are searched for the tag in the order that
they were opened. Once the tag is found, the order is set to
its index file, and control is given to the tag specified.
OF (cCombinedIndex) specifies which .CDX (DBFSIX) file or .MDX
(DBFMDX) file contains the specified tag. This is used to
eliminate any conflicts between two .CDX/.MDX's that may each
have a tag of the same name. Order is set to the specified
.CDX/.MDX and specified tag is given control.
If no tagname is specified, then order is set to 0 (record #
order).
Description:
SET ORDER TO TAG is used to establish the controlling index in
a set of tags when using a .CDX (DBFSIX) or .MDX (DBFMDX) style
combined-index.
Notes:
This command is only available when using a database that has
been opened with the DBFFOX or DBFSIX driver and a .CDX
combined index.
Examples:
. USE MAILLIST FOX INDEX MAILLIST.CDX
. SET ORDER TO TAG ZIP
. BROWSE
. SET ORDER TO TAG PHONE
. BROWSE
See Also:
SET TAG
dc_tagsel()
SET PATH
Specify the search path for opening data/index/form files
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
SET DEFAULT
dc_ispath()
dc_pathfound()
SET PDIR
Specify the search path for opening .PRG files
Syntax:
Arguments:
(cPrgDirectory) is the directory name to search for .PRG files.
Description:
SET PDIR is used to define the drive and directory to place
search for .PRG files when compiling .PRGs with the CLIPPER
command, editing with the EDIT PRG command, or
source-level-debugging a program in STEP mode.
Examples:
. SET PDIR TO \MYAPPS\PRG
. EDIT MYMENU
. CLIP MYMENU
See Also:
PDIR =
EDIT PRG
/
dc_turbedit()
SET STEP
dc_setstep()
SET PEXT
Specify the default extension for source files
Syntax:
Arguments:
(cExtension) is the default extension to append to the source
file name when using the source-level debugger or editing a
file with the EDIT PRG command.
Description:
SET PEXT TO is used to define the default extension to append
to the source file name when using the source-level debugger
or editing a file with the EDIT PRG command. Use this
command if your source-code files do not have the .PRG
extension.
Examples:
. SET PEXT TO .PP
. EDIT MYAPP // Edit MYAPP.PP
. CLIP MYAPP
See Also:
PEXT =
PDIR =
SET PDIR
SET STEP
dc_setstep()
SET PRINTER
Toggle echo of console output to the printer
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET PRINTER TO
Set the destination of printed output
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET PROCEDURE
Create a specified command to run a procedure
Syntax:
Arguments:
(cCommandVerb) is the name of the command you wish to use at
the dot prompt execute the procedure.
(idProcedure) is the name of the procedure or function to
execute when the (cCommandVerb) is entered at the dot prompt.
Examples:
. SET PROCEDURE TO CALLHOME, DIALOUT("714-555-1212")
. CALLHOME
See Also:
PROC =
SET PROMPT
Establish the information displayed before the dot prompt
Syntax:
Arguments:
DEFAULT will display the current setting of the SET DEFAULT
directory. This is the directory selected by the
SET DEFAULT command or DC_SETT('DEFA') function. Use this
option if you wish to see the default directory in which
databases, indexes, form files, etc. will be opened and
created. If SET DEFAULT is empty, i.e, SET DEFAULT TO, then
databases will be created in the current DOS directory.
DOS will display the current selected DOS directory. This
is the directory selected by the CD command or DC_CHDIR()
function. Low-level file functions such as FOPEN(),
DC_TXTOPEN() etc. will look in the DOS directory for files
if no path is included in the file name.
(expression) is any expression that returns any value.
Description:
SET PROMPT is used to enable or disable the display of the
directory prompt that is displayed before the dot on the
command line.
Examples:
. SET PROMPT TO DOS
. SET PROMPT TO DEFAULT
. SET PROMPT TO "My Prompt"
. SET PROMPT TO TIME()
See Also:
PROMPT =
SET QUERYKEY
Define the key assignment to pop-up the query builder
Syntax:
Arguments:
(nInkey) is the same as the INKEY() value for the desired key
to press to invoke the field pick-list.
Description:
The ALT-Q key is the default key to invoke the Query Builder
for creating or choosing FOR/WHILE expressions to insert at
the current cursor location in the command line editor.
If you wish to reassign this key to prevent conflict with
other hot-keys, then use this command.
Examples:
// Define ALT-P as the field list key
FLDKEY = 281
See Also:
QUERYKEY
QUERY
dc_query()
SET RDD
Establish the Default Database Driver
Syntax:
Arguments:
(rdd) is the name of the database driver to use as the
default.
Description:
SET RDD is used to establish a default data driver (RDD)
to be used when opening database files. If the RDD
specified has been linked in to your application or the
dCLIP engine then it will be used as the default driver
otherwise an "Invalid Data Driver" error will be
displayed.
Examples:
. SET RDD TO DBFSIX
. use sales
. set tag to month
. SET RDD TO DBFNTX
. use customer index custname, custnmbr
. set order to 2
See Also:
SET SUPERRDD
dc_setrdd()
dc_rddsel()
SET RELATION
Relate two work areas by a key value/record number
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
BROWSE RELATION
dc_browrela()
SET SCOREBOARD
Toggle the message display from READ or MEMOEDIT()
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET SLASH
Define the name of the source file to edit with the / key
Syntax:
Arguments:
(cFileName) is the name of the file to edit when using the /
key. Do not include an extension. The source file will require
the .PRG extension which will be compiled to a file with an
.OBJ extension.
Description:
SLASH is used to establish the name of the file to edit when
using turbo editor via the / (slash) command. The default
value is DC_CLIP, ie. the / command will edit a file named
DC_CLIP.PRG and compile it to a file named DC_CLIP.OBJ.
Examples:
. SET SLASH TO TEST
. /
See Also:
SLASH =
dc_turbedit()
/
SET SOFTSEEK
Toggle relative SEEKing
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET STATUS
Toggle display of 3-bar status line at top of screen
Syntax:
Arguments:
ON will enable display of the status line.
OFF will disable the status line.
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET STATUS is used to enable or disable the display of a 3-bar
status line a the top of the display. The status bar provides
important information about the current work area.
Examples:
. SET STATUS ON
. SET STATUS OFF
See Also:
dc_statline()
dc_dot()
SET STEP
Toggle source-level debugging mode
Syntax:
Arguments:
ON will enable the source-level debugger.
OFF will disable the source-level debugger (default).
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET STEP is used to enable or disable the source-level
debugger. Application programs compiled with the /b compiler
switch can be debugged by single-stepping through the
source-code while the application is running. SET STEP enables
an interrupt that calls the source-level debugger routine after
each line of Clipper-compiled code is executed. Source code
will be displayed in a box that overlays an area of the screen
unless the SPLIT=ON option is added to your DCLIP.SYS. This
option will enable 50-line mode on VGA systems and split the
screen in half with the application screen visible on the top
half of the display and the source code on the bottom half of
the display.
Examples:
. SET STEP ON
. DO MYAPP
See Also:
dc_setstep()
SET STICKYBROWSE
Set Sticky Browse Default Mode
Syntax:
Arguments:
ON will enable Sticky Browse Mode.
OFF will disable Sticky Browse Mode. - ( Default )
Description:
SET STICKYBROWSE is used to toggle the Default mode for
database browsing to maintain the configuration of browse
windows after they are created with the BROWSE commands. If
Sticky Browse mode is ON, if the user exits browse mode and
then enters the BROWSE command again, the previous browse
window will be re-displayed.
Examples:
. SET STICKYBROWSE ON
. USE CUSTOMER
. BROWSE
. DO SOMETHING
. BROWSE // Browse window is redisplayed
See Also:
STICKYBROW
BROWSE
dc_browsedb()
SET SUPERRDD
Establish the Default "Inherited" Database Driver
Syntax:
Arguments:
(rdd) is the name of the database driver to use as the
Super RDD driver.
Description:
SET SUPERRDD is used to establish a default data driver
(RDD) to be used when using a database driver that allows
database inheritance, such as the FlexFile-II driver.
When using FlexFile, the SUPERRDD is the data driver that
is used for index operations whereas the FlexFile RDD
will be used for database field storage.
Examples:
. SET SUPERRDD TO DBFSIX
. use sales via flexfile
. set tag to month
See Also:
dc_superrdd()
dc_setrdd()
SET RDD
SET SWAP
Specify directory to create temporary file when shell to dos
Syntax:
Arguments:
(cPathspec) is the drive and directory to specify for creating
temporary memory image files.
(cAltPathspec) is the drive/directory for placing overflow in
the event that (cPathspec) fills up when writing the memory
image file.
Description:
SET SWAP is used to define the drive and directory to create
temporary memory image files when using dCLIP operations and
commands that call other dos programs via the gateway system,
i.e. DOS, CLIPPER, etc.
Examples:
. SET SWAP TO D: ; F:\DCLIP
. DOS
See Also:
SWAP =
DOS
RUN
SET TAG
Set a new controlling index Tag
Syntax:
Arguments:
TAG (cTagName) specifies the name of the tag to set the order
to. If a combined index file is not specified, then the open
combined indexes are searched for the tag in the order that
they were opened. Once the tag is found, the order is set to
its index file, and control is given to the tag specified.
OF (cCombinedIndex) specifies which .CDX (DBFSIX) file or .MDX
(DBFMDX) file contains the specified tag. This is used to
eliminate any conflicts between two .CDX/.MDX's that may each
have a tag of the same name. Order is set to the specified
.CDX/.MDX and specified tag is given control.
If no tagname is specified, then order is set to 0 (record #
order).
Description:
SET TAG is used to establish the controlling index in a set of
tags when using a .CDX (DBFSIX) style or .MDX (DBFMDX) style
combined- index.
Examples:
. USE MAILLIST FOX INDEX MAILLIST.CDX
. SET TAG TO ZIP
. BROWSE
. SET TAG TO PHONE
. BROWSE
See Also:
dc_tagsel()
SET TALK
Toggle display of Pre-processed output
Syntax:
Arguments:
ON will enable the echoing of preprocessed output to the
console.
OFF will disable echoing of preprocessed output (default).
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET TALK is used to enable or disable the echoing of the pre-
processed output to the console. All commands entered at the
dot- prompt are passed through the pre-processor and converted
to a function or set of functions to be evaluated in sequence.
When debugging #translate/#define statements in .CH files
previously loaded with the INCLUDE command, SET TALK ON will
show the results of the translation.
Examples:
. #TRANSLATE PHONE (number) =) DIALOUT(((number)))
. #DEFINE HOME 714-555-1212
. SET TALK ON
. PHONE HOME
DIALOUT("714-555-1212")
See Also:
SET ECHO
SET TRACE
Toggle trace-profiling mode
Syntax:
Arguments:
ON will enabled the tracing of loading of libraries an object
files as they are being loaded into memory during the running
of an application. The following messages will be displayed on
the screen:
Loading Dynamic Library: DCLIP.DLB ...
Loading Object Module: MAINMENU ...
OFF will disable display of information (default)
(lToggle) if .T. is equivalent to ON, if .F. is equivalent to
OFF.
Description:
SET TRACE toggles the display of the names of libraries and
object modules which are being loaded during runtime of an
application for debugging purposes. When SET TRACE is ON,
messages are also saved to a file for later viewing.
Examples:
. SET TRACE ON
. LIB LOAD MYAPP1
Loading dynamic library: MYAPP1.DLB ...
. MAP LOAD MYAPP2
. DO MYAPP1
Loading object module: MYAPP1.OBJ ...
Loading object module: MAINMENU.OBJ ...
Loading object module: MYFUNCS.OBJ ...
See Also:
TRACE
dc_trace()
SET TRACESIZE
Set Maximum size of Trace File
Syntax:
Arguments:
(nSize) is the maximum size of the Trace File (in Bytes).
The default is 100000.
Description:
SET TRACESIZE is used to establish the maximum size of the
DCTRACE file that gets created in TRACE MODE. This setting
prevents the disk from being filled up in the event that the
TRACE MODE is inadvertenly left on.
Examples:
SET TRACESIZE TO 500000
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_tracesize()
TRACESIZE
SET TURBO
Define the default TURBO editor for the IDE system
Syntax:
Arguments:
(cFileName) is the name of the editor .COM, .BAT or .EXE file
to run when using the / command.
(nMemorySwap) is the amount of memory to release and save to
disk to run the program. The default is (K). Enter 0 to
release all memory except shell.
(cPathSpec) is the name of primary and secondary Disk
Drive/Directory (separated by a semicolon) to save the memory
image.
A temporary file is created on the first drive if space is
available. If no space is left on the first drive/directory
then the remainder of the memory image is created on the second
specified drive/directory. The temporary file is erased
returning from your editor.
Optional: [H] - Set High Resolution mode (43/50 lines)
[L] - Set Low Resolution mode (25 lines)
Description:
SET TURBO is used to define the name and path of the default
editor you wish to use when using the
turbo-edit-compile-execute features of dCLIP, such as the /
command or DC_TURBEDIT() function.
Examples:
EDITOR = QEDIT,256,D:;F:\PUBLIC,/H
See Also:
dc_turbedit()
/
TURBO =
SET TYPEAHEAD
Set the size of the keyboard buffer
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_putkey()
SET UNIQUE
Toggle inclusion of non-unique keys into an index
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
SET USEEXCLDATA
Force Exclusive Use of Application Databases
Syntax:
Arguments:
ON will force databases that are opened by the dCLIP USE
command, DC_UseArea() function, DC_WorkRestore(), DC_Dbfile(),
or any other dCLIP function or command that opens databases
to be opened EXCLUSIVE regardless of how parameters are
passed to these functions or the setting of the SET EXCLUSIVE
system flag.
OFF will insure that databases are opened by the default
method for each function.
Description:
SET USEEXCLDATA is used to override any default settings for
opening databases and insure that they are always opened in
EXCLUSIVE mode only. This flag should be used when using
dCLIP in "design" mode. Design mode means that the user or
programmer is designing Browse and Data-Entry screens and/or
Field Definitions. When adding or changing database fields
or packing files, they must be opened in "Exclusive" mode.
Notes:
When designing a system it is recommended that you place the
following commands in your DCLIP.SYS file:
USEEXCLDATA=ON
USEEXCLDICT=OFF
or type the following commands at the dot prompt:
SET USEEXCLDATA ON
SET USEEXCLDICT OFF
See Also:
USEEXCLDATA
USEEXCLDICT
SET USEEXCLDICT
SET USEEXCLDICT
Force Exclusive Use of Dictionary Databases
Syntax:
Arguments:
ON will force the dCLIP DC* databases that are opened by the
dCLIP USE command, DC_UseArea() function, DC_WorkRestore(),
DC_Dbfile(), or any other dCLIP function or command that opens
dictionary databases to be opened EXCLUSIVE regardless of how
parameters are passed to these functions or the setting of the
SET EXCLUSIVE system flag.
OFF will insure that dictionary databases are opened by the
default method, i.e., EXCLUSIVE when the SET EXCLUSIVE ON
flag is set or SHARED when the SET EXCLUSIVE OFF flag is set.
Description:
SET USEEXCLDICT is used to override any default settings for
opening dCLIP dictionary databases and insure that they are
always opened in EXCLUSIVE mode only. This flag should be
used only in the rare occurrence that the structure of a
dCLIP DC* database file must be modified or the database
must be reindexed or packed.
Notes:
When designing a system it is recommended that you place the
following commands in your DCLIP.SYS file:
USEEXCLDATA=ON
USEEXCLDICT=OFF
or type the following commands at the dot prompt:
SET USEEXCLDATA ON
SET USEEXCLDICT OFF
See Also:
USEEXCLDATA
USEEXCLDICT
SET USEEXCLDATA
SET WRAP
Toggle wrapping of the highlight in MENU TO menus
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_sett()
SET =
MENU TO
dc_menu_to()
SKIP
Move the record pointer to a new position
Syntax:
Arguments:
See Clipper 5.0 Guides
SORT
Copy to a data file in sorted order
Syntax:
Arguments:
See Clipper 5.0 Guides
Description:
SORT works identical to the Clipper SORT command except a
progress odometer will display the number of records scanned
and the number of records that were actually sorted.
See Also:
dc_sort()
STABILIZE
Stabilize a Tbrowse object
Syntax:
Arguments:
(oTbrowse) is a PUBLIC or PRIVATE object created by the
Tbrowsedb() or Tbrowse() function.
Description:
STABILIZE is used to run an (obj):Stabilize() loop on an
existing Tbrowse() object. This command is handy when
debugging Tbrowse objects interactively.
Notes:
Another method of stabilizing Tbrowse objects is ASTABILIZE.
This accomplishes an automatic stabilization after each
command.
Examples:
. USE CUSTOMER
. OBJ := TBROWSEDB()
. A := TBCOLUMNNEW('NAME',{||NAME})
. B := TBCOLUMNNEW('BALANCE',{||BALANCE})
. OBJ:ADDCOLUMN(A)
. OBJ:ADDCOLUMN(B)
. STABILIZE OBJ
. OBJ:DOWN()
. STABILIZE OBJ
. OBJ:RIGHT()
. STABILIZE OBJ
. OBJ:GOBOTTOM()
See Also:
ASTABILIZE
STEP
Load an expression or procedure name into the STEP table
Syntax:
Arguments:
(lExpression) is any expression.
PROCEDURE (idProcedure) is the name of the procedure to start
animation.
[(nLineNmbr)] is the specific line number in the code in the
above procedure to start the animation. If no line number is
given then the animation will start at the first line of
executable code.
.AND. - When the STEP AND command is invoked, the STEP mode
will be inititated when ALL the expressions in the step table
evaluate .TRUE.
.OR. (default) - When the STEP OR command is invoked, the STEP
mode will be initiated when any ONE of the expressions in
the step table evaluate .TRUE.
NONE - When the STEP command is used with no options, a
complete listing of all the expressions in the STEP array
will be displayed by number.
Description:
STEP is used to establish a set of conditions for determining
which procedures you wish to animate when source-level
debugging. STEP allows animation to occur based on evaluation
of expressions, procedure names, line numbers, etc.
STEP will load an expression or a procedure name into the STEP
table
Examples:
. STEP ALIAS()='INVOICE' .AND. EOF()
. DO MYAPP
See Also:
dc_step()
STEP
dc_setstep()
SET STEP
STEP CLEAR
Remove STEP expressions from the STEP table
Syntax:
Arguments:
(nTableEntry) is the number of the STEP table entry to clear.
The table entry number for the expression(s) you wish to clear
from the table can be determined by using the command STEP with
no parameters.
ALL will clear all entries from the step table.
Description:
STEP CLEAR is used to remove expressions or procedure names
from the STEP table.
Examples:
. STEP !EMPTY(ALIAS())
. STEP PROC MAINMENU
. STEP CLEAR 1
See Also:
STEP
dc_step()
dc_setstep()
STEP ONLY
Display source code only when executing specified procedure
Syntax:
Arguments:
(idProcedure) is the name of the procedure you wish to animate
with the source-level debugger.
Description:
STEP ONLY is used to reduce animation of an application with
the source-level debugger to a single procedure and bypass all
other procedures.
Examples:
. SET STEP ON
. STEP ONLY MAINMENU
. DO MYAPP
See Also:
STEP
SET STEP
dc_setstep()
STEP RATE
Establish automatic stepping rate for source-level debugging
Syntax:
See Also:
STEP
SET STEP
dc_setstep()
STORE
Assign a value to one or more variables
Syntax:
Arguments:
See Clipper 5.0 Guides
SUM
Sum numeric expressions to variables
Syntax:
Arguments:
See Clipper 5.0 Guides
Description:
SUM works identical to the Clipper SUM command except a
progress odometer will display the number of records scanned
and the number of records actually summed.
See Also:
dc_sum()
UTIL
SYNTAX
Display the Syntax of a command or function
Syntax:
Arguments:
(command) is a command "verb" or (function) is the function
"name".
Description:
SYNTAX is used to display the SYNTAX of any command supported
in the dCLIP internal command set or any command loaded by
the #INCLUDE command or DC_PREINCLUDE() function or any
command/function that has been documented in the DCHELP.DBF
database.
SYNTAX scans the pre-processor command array first to see if
there are any commands loaded that match the "command verb"
or the "function name". If none can be found, then the
DCHELP.DBF database is searched for a match.
All items found will be scrolled up on the screen and remain
there as a handy reference.
Examples:
-- Example 1 --
. SYNTAX USE
USE ALL [LIKE (wildcard)] [VIA (rdd)] [EXCLUSIVE] [SHARED]
[READONLY]
USE ?
USE (db) [FOX] [VIA (rdd)] [ALIAS (a)] [NEW] [EXCLUSIVE]
[SHARED] [READONLY] [INDEX (list,...)]
USE IN (alias)
USE
-- Example 2 --
. SYNTAX DC_EXPL
dc_expl( nStartRow, nStartCol, nEndRow, nEndCol, [cTitle], ;
[lNoShadow], [lPaintOnly] ) -) cSaveScreen
dc_explmode ( lExplode ) -) lMode
dc_explode( nSrow, nScol, nErow, nEcol, cColor1, cColor2, ;
[lTone], [cTitle], [nSlideRate], [lShadow], [lPaintOnly], ;
[lDouble] ) -) cSaveScreen
TAG
Tag or Untag records in the current work area
Syntax:
Arguments:
(array) is a single-dimensional array that contains the record
numbers of the tagged records. If the [TO (array)] clause is
not used then the tags are added or cleared from a public array
named DCTAGS which contains a sub-array for each work area.
The CLEAR clause will remove record numbers from the tag array
that meet the specified conditions.
See the Clipper guides for information on how to use the
FOR, WHILE, NEXT, ALL, REST, and RECORD clauses.
Description:
TAG is used to add or remove record numbers from an array of
record numbers that can be used with all database commands
for performing database operations on records that have been
previously "tagged".
A manifest symbol named TAGGED may be used in any expression
at the dot-prompt. This symbol is automatically translated
to DC_TAGGED() which is the function used to test whether or
not a record has been tagged. This allows for simple use of
the tagging system by easy-to-enter commands.
Notes:
CAUTION: The dCLIP tagging system is designed for ad-hoc
tagging of records using simple menu selection and database
commands. Each work area is limited to a total of 4000
tagged records. Any attempt to tag more than 4000 records
will display an error. You will notice a gradual speed
detioration as you add more records to the tag array when
browsing. This is because the DC_TAGGED() function must
scan more records in the array. It is recommend that you
refrain from tagging more than 1000 records or you may
experience unacceptable slowness during browsing.
If you need a tagging system that will support a much
larger number of records, it is recommended that you
add a TAG (logical) field to your database.
Examples:
. select customer
. TAG CLEAR ALL
. go 113
. ? TAGGED
.F.
. TAG
. ? TAGGED
.T.
. TAG CLEAR
. ? TAGGED
.F.
. TAG FOR balance)0
. TAG FOR zip='92001'
. TAG CLEAR FOR balance(1000
. count for TAGGED
. label form customer for TAGGED to print
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_tagged()
dc_rectag()
TAG BROWSE
Tag or Untag records with a browse-style pick-list
Syntax:
Arguments:
(array) is a single-dimensional array that contains the record
numbers of the tagged records. If the [TO (array)] clause is
not used then the tags are added or cleared from a public array
named DCTAGS which contains a sub-array for each work area.
The CLEAR clause will remove record numbers from the tag array
that meet the specified conditions.
See the Clipper guides for information on how to use the
FOR, WHILE, NEXT, ALL, REST, and RECORD clauses.
Description:
TAG BROWSE is used to add or remove record numbers from an
array of record numbers that can be used with all database
commands for performing database operations on records that
have been previously "tagged". A pick-list of fields and
records based on the current work area is displayed for
the user to tag or untag records using either the SPACE
bar key or the mouse. Use the LEFT mouse button to TAG the
record and the RIGHT mouse button to UNTAG the record after
placing the mouse cursor in the Tag Column.
TAG BROWSE uses the DC_DBCHOICE() pick-list function. For
a more robust BROWSE system that also supports tagging
features, use the standard BROWSE command or DC_BROWSEDB()
function and select option (A) from the Search Options menu.
Examples:
. select customer
. TAG CLEAR ALL
. TAG BROWSE
. count for TAGGED
. label form customer for TAGGED to print
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_rectagbrowse()
dc_tagged()
TAG
TAG CLEAR ALL
Clear all record tags in the current work area
Syntax:
Arguments:
None.
Description:
This command clears all tags from the DCTAGS tag array for
the currently selected work area.
Examples:
. select customer
. TAG CLEAR ALL
. TAG FOR balance)0
. label form customer for TAGGED to print
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
See Also:
dc_rectagclear()
dc_tagged()
TAG
TC | TIMECUBE
Call the Time-Cube Ap,ointment Scheduler System
Syntax:
Arguments:
The DIALER option will go directly to the Address-Book-Dialer
menu and by-pass the Main Menu system.
The ONEUSER option will "exclude" any features from the main
menu system that support multi-user features, such as
Net-Mail, User Logon, etc. Use this parameter if you are
using the system as a personal appointment scheduler rather
than a multi-user system.
The USER (user) option is used to pass a USER ID to the
system for logging on.
The NODE (node) option is used to pass a NODE ID to the
system for logging on and using a specified node record.
The EVENT (event) option is used to pass an EVENT ID to
the system for displaying appointments for a specified event.
The GROUP (group) option is used to pass an Appointment
GROUP ID to the system for displaying appointments for a
specified appointment group.
The CLIENT (client) option is used to pass a CLIENT ID and
optional CLIENT ALIAS to the system for displaying appointments
for a specified client file and Client ID.
The SERVER (server) option is used to pass the directory
in which all the shared files are located. If this parameter
is not passed then the directory established during Time-Cube
setup will be used.
The LOCAL (local) option is used to pass the directory
in which all the personal files are located. If this parameter
is not passed then the directory established during Time-Cube
setup will be used.
Description:
TC is used to call the main TC() function to start-up the
Time-Cube Appointment Scheduler, Address-Book-Dialer, Network
E-Mail system.
See the TC.NG file or the TCHELP.DBF/.DBT database for more
information on how to use the Time-Cube system.
Examples:
/* Call up the Address Book - Dialer */
TC DIALER
/* Log on to the system to check Network E-mail and
appointments */
TC USER ROGER NODE DEFAULT
Source/Library:
_DCTRAN1.PRG/.OBJ, DCLIP.LIB
TOTAL
Summarize records by key value to another data file
Syntax:
Arguments:
See Clipper 5.0 Guides
Description:
TOTAL works identical to the Clipper TOTAL command except a
progress odometer will display the number of records scanned
and the number of records that were actually totalled.
TRACE
Enable/Disable profiling of executing procedure
Syntax:
Arguments:
(lExpression) is any expression.
ON identifies that evaluation of (lExpression) or (idProcedure)
as .true. will start the tracing.
OFF identifies that the evaluation of (lExpression) or
(idProcedure) a .true. will stop the tracing.
PROCEDURE (idProcedure) is the name of the procedure to start
tracing.
[(nLineNmbr)] is the specific line number in the code in the
above procedure to start the trace. If no line number is given
then the animation will start at the first line of executable
code.
Description:
TRACE is used to establish a set of conditions for determining
which procedures you wish to profile with the Trace debugger.
TRACE allows tracing to occur based on evaluation of
expressions, procedure names, line numbers, etc.
TRACE ON|OFF will establish an expression or a procedure name
to evaluate for starting or stopping the tracing operation.
TRACE mode will write the PROCEDURE name, LINE number, and
WATCH values into a file named DCTRACE for each line of
application code that executes. Only code which has been
compiled with line numbers will be traced and only code which
has been actually "executed" during the running of the program
will be traced.
Use your editor to view the contents of the DCTRACE file or use
the TRACE CONVERT command to convert the trace file to a text
file which is a merging of your source code and the trace file
data.
Examples:
. TRACE ON PROCEDURE MAINMENU 45
. TRACE OFF LASTKEY()=27
. DO MYAPP
See Also:
dc_trace()
TRACE CLEAR
Remove TRACE expressions from the TRACE table
Syntax:
Arguments:
(nTableEntry) is the number of the TRACE table entry to clear.
The table entry number for the expression(s) you wish to clear
from the table can be determined by using the command TRACE
with no parameters.
ALL will clear all entries from the TRACE table.
Description:
TRACE CLEAR is used to clear any expression or procedure
value(s) established by the TRACE ON|OFF command.
Examples:
. TRACE ON !EMPTY(ALIAS())
. TRACE OFF PROC MAINMENU
. TRACE CLEAR 1
See Also:
TRACE
dc_trace()
TRACE CONVERT
Merge TRACE file debug information with source code
Syntax:
Arguments:
(xcOutFile) is the name of the file to create. If no file name
is given then the name DCTRACE.TXT will be assigned to the new
file.
Description:
TRACE CONVERT is used to merge the debugging information in the
DCTRACE file with your source code to provide a "histogram"
that can be viewed with your text editor. The new file
created will contain both information from your source code
files and information about the running application in a
columnar-style report to help you analyze an application.
Examples:
. TRACE ON PROC PRINTOUT
. TRACE OFF INKEY() = 27
. DO MYAPP
. TRACE CONVERT MYAPP.TRC
See Also:
TRACE
dc_trace()
TRACE ONLY
Trace code execution only when executing specified procedure
Syntax:
Arguments:
(idProcedure) is the name of the procedure you wish to trace
with the trace debugger.
Description:
TRACE ONLY is used to reduce tracing of an application with the
trace-debugger (profiler) to a single procedure and bypass all
other procedures.
Examples:
. TRACE ON
. TRACE ONLY MAINMENU
. DO MYAPP
. TRACE OFF
. TRACE CONVERT
See Also:
TRACE
dc_trace()
TUTOR
Run Tutoring system for Clipper/dCLIP commands and functions
Syntax:
Arguments:
(idCommand) | (idFunction) is the name of the command or
function to jump to in the DCTUTOR database.
If no argument is given, then the TUTOR will return to the
screen that was last accessed during the previous tutoring
session.
Description:
TUTOR is a data-driven tutoring system designed to teach how to
use all Clipper commands and functions and dCLIP commands and
functions.
This learn-by-example tutoring system utilizes both the
dot-prompt interpreter and the turbo-compiler/linker features
of dCLIP to run code samples for demonstrating how to use each
command or function.
Description text and code samples are saved in memo fields in
the DCTUTOR.DBF database and can be easily modified by the
operator.
Examples:
. TUTOR
. TUTOR SET TAG
. TUTOR DC_WORKSAVE
. TUTOR TBROWSE
See Also:
dc_tutor()
TYPE
Display the contents of a text file
Syntax:
Arguments:
See Clipper 5.0 Guides
UNLOCK
Release file/record locks set by the current user
Syntax:
Arguments:
See Clipper 5.0 Guides
See Also:
dc_reclock()
dc_addrec()
UPDATE
Update active data file from another data file
Syntax:
Arguments:
See Clipper 5.0 Guides
USE
Open an existing data file and its associated files
Syntax:
Arguments:
? will pop-up a pick-list of databases in the current DEFAULT
directory that match the default file extension for the
currently selected replaceable data driver (RDD).
(xcDatabase) is the name of the database file to open and may
be specified either as a literal filename or as a character
expression enclosed in parentheses.
INDEX (xcIndex list) specifies the name(s) of up to 15 index
files to open in the current work area. Each index may be
specified either as a literal filename or as a character
expression enclosed in parentheses with the first index in the
list becoming the controlling index. If an (xcIndex) is
specified as an expression and the value returned is spaces or
NIL, it is ignored.
ALIAS (xcAlias) is the name to associate with the work area
when the database file is opened. The alias name may be
specified either as a literal name or as a character expression
enclosed in parentheses. If this clause is not specified, the
alias defaults to the database filename.
EXCLUSIVE opens the database file for non-shared use in a
network environment. All other users are denied access until
the database file is CLOSEd.
SHARED opens the database file for shared use in a network
environment. Specifying this clause overrides the current
EXCLUSIVE setting.
NEW opens (xcDatabase) in the next available work area making
it the current work area. If this clause is not specified,
(xcDatabase) is opened in the current work area.
READONLY opens (xcDatabase) with a read-only attribute. This
allows you to open database files marked read-only. If the
(xcDatabase) can not be opened in this way, a runtime error is
generated. If this clause is not specified, (xcDatabase) is
opened read-write.
VIA (cDriver) defines the replaceable database driver (RDD) to
use to process the current work area. (cDriver) is name of the
RDD specified as a character expression. If (cDriver) is
specified as a literal value, it must be enclosed in quotes.
FOX defines that the replaceable database driver (RDD) to use
to process the current work area will be the DBFFOX driver.
PDX defines that the replaceable database driver (RDD) to use
to process the current work area will be the PDX (Paradox)
driver.
If the VIA or FOX clause are not specified, the driver
previously established as the default driver via the SET RDD TO
(cDriver) command will be used. Note that if the specified
driver is not linked, an unrecoverable error occurs.
In no arguments are specified, the database file open in the
current work area is closed.
Description:
USE opens an existing database (.dbf) file, its associated memo
(.dbt) file, and optionally associated index (.ntx or .ndx)
file(s) in the current or the next available work area. There
are 250 work areas with a maximum of 255 total files open in
DOS 3.3 and above. Before USE opens a database file and its
associated files, it closes any active files already open in
the work area. When a database file is first opened, the
record pointer is positioned at the first logical record in the
file (record one if there is no index file specified).
In a network environment, database files can be opened
EXCLUSIVE or SHARED. EXCLUSIVE precludes the USE of the
database file by other users until the file is closed. SHARED
allows other users to USE the database file for concurrent
access. If the database file is SHARED, then commands which
make large changes to the database or structure cannot be used
and will return an "exclusive required" error.
Index files can be opened either with USE or SET INDEX. The
first index in the list of indexes defines the current ordering
of records when they are accessed. This index is referred to
as the controlling index. The current controlling index can be
changed without closing any files using the SET ORDER command.
To close a database and its associated files in the current
work area, specify USE or CLOSE with no arguments. To close
database files in all work areas, use CLOSE DATABASEs. To
close index files in the current work area without closing the
database file, use CLOSE INDEX or SET INDEX TO with no
arguments.
Examples:
// dBASE-III/IV compatability
. SET RDD TO DBFNDX
// FoxPro compatability
. USE CUSTOMER INDEX CUSTNAME, CUSTNMBR
. USE MAILLIST FOX NEW
// Paradox compatability
. SELE 0
. USE NEWLEADS VIA 'PDX' EXCLUSIVE
See Also:
dc_use()
dc_usearea()
USE ALL
dc_useall()
USE ALL
Open all data files matching a specified wildcard
Syntax:
Arguments:
LIKE (cWildcard) is a wild-card argument to establish the set
of database files to open. If this argument is not used, then
all databases will be opened.
VIA (cRDD) is the name of the Replaceable Database Driver to
use for each workarea. If this argument is not used, then the
current data driver (selected by the SET RDD command) will be
used. Only data files with an extension that match the default
extension for each driver type will be opened.
EXCLUSIVE will open all the files in exclusive mode for
non-shared use regardless of the setting of SET EXCLUSIVE.
SHARED will open all the files in shared mode for use on a
network regardless of the setting of SET EXCLUSIVE.
Description:
USE ALL is a command that allows a set of databases to be
opened in unused work areas based on a wildcard. If any of the
files matching the wildcard are already in use, they will not
be reopened. Current work areas will not be affected by USE
ALL.
Examples:
. USE ALL
. CLOSE ALL
. USE ALL LIKE DC*
. USE ALL LIKE MAIL* VIA 'DBFFOX' EXCLUSIVE
See Also:
dc_useall()
USE
dc_usearea()
USE...DBFMDX
Open an existing data file and its associated files
Syntax:
Arguments:
(xcDatabase) is the name of the database file to open and may
be specified either as a literal filename or as a character
expression enclosed in parentheses.
INDEX (xcIndex list) specifies the name(s) of up to 15 index
files to open in the current work area. Each index may be
specified either as a literal filename or as a character
expression enclosed in parentheses with the first index in the
list becoming the controlling index. If an (xcIndex) is
specified as an expression and the value returned is spaces or
NIL, it is ignored.
ORDER TAG (cTag) OF (xcMdx) specifies a tag name in a .MDX
index to select.
DBMEMO3 specifies that the memo type is dBASE-III .DBT style.
ALIAS (xcAlias) is the name to associate with the work area
when the database file is opened. The alias name may be
specified either as a literal name or as a character expression
enclosed in parentheses. If this clause is not specified, the
alias defaults to the database filename.
EXCLUSIVE opens the database file for non-shared use in a
network environment. All other users are denied access until
the database file is CLOSEd.
SHARED opens the database file for shared use in a network
environment. Specifying this clause overrides the current
EXCLUSIVE setting.
NEW opens (xcDatabase) in the next available work area making
it the current work area. If this clause is not specified,
(xcDatabase) is opened in the current work area.
READONLY opens (xcDatabase) with a read-only attribute. This
allows you to open database files marked read-only. If the
(xcDatabase) can not be opened in this way, a runtime error is
generated. If this clause is not specified, (xcDatabase) is
opened read-write.
VIA (cDriver) defines the replaceable database driver (RDD) to
use to process the current work area. (cDriver) is name of the
RDD specified as a character expression. If (cDriver) is
specified as a literal value, it must be enclosed in quotes.
In no arguments are specified, the database file open in the
current work area is closed.
Description:
USE...DBFMDX opens an existing database (.dbf) file, its
associated memo (.dbt) file, and optionally associated index
(.mdx) file(s) in the current or the next available work area.
There are 250 work areas with a maximum of 255 total files open
in DOS 3.3 and above. Before USE opens a database file and its
associated files, it closes any active files already open in
the work area. When a database file is first opened, the
record pointer is positioned at the first logical record in the
file (record one if there is no index file specified).
In a network environment, database files can be opened
EXCLUSIVE or SHARED. EXCLUSIVE precludes the USE of the
database file by other users until the file is closed. SHARED
allows other users to USE the database file for concurrent
access. If the database file is SHARED, then commands which
make large changes to the database or structure cannot be used
and will return an "exclusive required" error.
Index files can be opened either with USE or SET INDEX. The
first index in the list of indexes defines the current ordering
of records when they are accessed. This index is referred to
as the controlling index. The current controlling index can be
changed without closing any files using the SET ORDER command.
To close a database and its associated files in the current
work area, specify USE or CLOSE with no arguments. To close
database files in all work areas, use CLOSE DATABASEs. To
close index files in the current work area without closing the
database file, use CLOSE INDEX or SET INDEX TO with no
arguments.
Notes:
USE...DBFMDX is activated only if the currently selected data
driver is DBFMDX or the VIA "DBFMDX" clause is specified.
Examples:
// dBASE-IV compatability
. SET RDD TO DBFMDX
. USE CUSTOMER INDEX CUSTNAME, CUSTNMBR
USER EDIT
Maintain the DCUSER.DBF User database
Syntax:
Arguments:
If the (cUserID) argument is passed, then the record that
contains the USR_ID matching (cUserID) will be edited,
otherwise all records will be available for browsing and
editing.
Description:
USER EDIT is used to maintain the DCUSER.DBF database
for establishing User ID's, Names, Passwords, Access Keys,
etc.
Examples:
USER EDIT LARRY
USER EDIT
Source/Library:
_DCUSER.PRG/.OBJ, DCLIP.LIB
See Also:
dc_usermaint()
USER LOGON
Log On to system to establish user rights
Syntax:
Arguments:
(cUserID) is the User ID of the logging on user. If this
parameter IS NOT passed and the (cPassword) parameter IS
passed, then the DCUSER.DBF will be searched only for a
match to the (cPassword). If (cUserID) is passed and
(cPassword) is not passed, then the user will be prompted to
enter a password. If neither (cUserID) or (cPassword) is
passed, then the user will be prompted for both a User ID
and a password.
Description:
USER LOGON is used to log a user onto the system in the
event that it is necessary to establish rights to menus,
files, or specified fields.
The dCLIP menu system, data-entry (editing) system, browsing
system, and file system provide for establishing locks on
menu items, fields and/or files. If these systems are used
without first using USER LOGON, then the user will be
given full rights. If however, USER LOGON is called
first, then the user will be given access to only those
items in which the user has the exact key or a master key
for each specified lock.
If the user logs on with the MASTER PASSWORD, then he/she is
automatically established as a "programmer" and is given full
access. The MASTER PASSWORD is hard-coded by a definition in
DCUSER.CH. To change the MASTER PASSWORD you must redefine it
in DCUSER.CH and then recompile _DCUSER.DBF and include the
new _DCUSER.OBJ in your link-script.
User PASSWORDS are stored in the DCUSER.DBF database in
encrypted form. Passwords may be assigned or changed only
with the DC_USERMAINT() function or the USER EDIT command.
User KEYS are stored in the DCUSER.DBF database and may be
assigned or changed only with the DC_USERMAINT() function or
the USER EDIT command. Locks are placed on menu items or
fields by entering a 3-character "lock" sequence when using
the menu-designer and/or data-entry designer. A database of
standard locks and their definitions may be maintained by
DC_LOCKMAINT() or LOCK EDIT. When assigning a user a set of
"keys" they may be specific keys or "master" keys. A Master
key is assigned by using wild-cards. For example, the Master
Key "5**" will allow access to any lock starting with the number
"5", whereas the Master Key "67*" will allow access to any
lock with the number "67". Keys are stored in the USR_KEYS
field and are separated by commas.
Example:
"1**,2**,3**,41*,42*,522,6**"
Examples:
USER LOGON LARRY STOOGE
Source/Library:
_DCUSER.PRG/.OBJ, DCLIP.LIB
UTILITIES
A menu of database utilities
Syntax:
Description:
UTILITIES is a menu-driven set of database utilities which
provides support for the following database operations:
DISPLAY STRUCTURE MODIFY STRUCURE CREATE DATABASES
CREATE INDEXES REINDEX SORT DATABASE
JOIN DATABASES COPY RECORDS APPEND RECORDS
COUNT RECORDS SUM FIELDS AVERAGE FIELDS
REPLACE FIELDS DELETE RECORDS RECALL RECORDS
PACK FILES ZAP DATABASES
RENAME FILES DISPLAY DIRECTORIES
See Also:
dc_util()
ASSIST
VIEW
View the contents of the selected record
Syntax:
Description:
To provide a full-screen view of the information in data
records of the current database, starting at the current
record pointer.
VIEW is similar to EDIT, except that VIEW prevents accidental
modification of the data.
PgDn : Display next page of current record.
PgUp : Display previous page of current record.
CTRL-PgDn : Go to same field of next record.
CTRL-PgUp : Go to same field of previous record.
Any other : Quit
key
VIEW LIBS
View status of dynamic-libraries and "dynamic-linked" .OBJs
Syntax:
Description:
VIEW LIBS will display a browse-style menu for viewing the
contents of dynamic libraries and loaded object modules.
I Numbers below this header are index numbers into the total
dynamic library space. You can think of this as an object
record number.
L An "L" will appear in this column if the object is currently
loaded into memory.
C A "C" will appear in this column if the object is changed.
When C displays, the version of the object loaded from disk
is more current that the one in the dynamic library.
U This shows the USAGE of the object. 0 indicates the object
is not linked. 1 indicates that the object is linked, but
not in use. 2 or a higher number shows that the object is
being used and is not available for release.
TYPE This shows the type of the object. Object types are:
OBJ - compiled programs
LST - function and procedure locations
NAM - library header
NAME This contains the name of the object.
DATE This shows the creation or last change date for the
selected object in month/day/year format.
TIME This shows the time of creation or last change for the
selected object.
F The number in this column tells which dynamic library the
object currently resides in. You can think of this as a
"file" number.
LEN The length of the object displays in LEN field. The
number in this field shows the total number of bytes
contained in the object.
E Some objects contain multiple object records which form
parts of screens, reports, etc. E shows how many
different object records or elements the object contains.
Examples:
. LIB LOAD MYAPP
. OBJ DEMO
. VIEW LIBS
See Also:
dc_viewlib()
WAIT
Suspend program processing until a key is pressed
Syntax:
Arguments:
See Clipper 5.0 Guides
WATCH
Load an expression into the WATCH table
Syntax:
Arguments:
(exp) is any expression that includes any value, including
user-defined functions.
? will pop-up a menu with a list of active PRIVATE and PUBLIC
memvars to choose. Select the memvars to watch with the arrow
keys, then press (enter) to mark the memvars.
No arguments will display a list of the watch expressions
currently loaded into the watch table preceded by a reference
number.
Description:
WATCH is used to load an expression into the WATCH table to be
evaluated and displayed in the Watch Window when debugging an
application with the source-level debugger or to be written to
the DCTRACE file when profiling with the trace debugger.
When program execution is stopped by the source-level debugger,
the list of WATCH expressions are displayed in a window on the
screen. The current value returned by all expressions loaded
into the watch table will be displayed.
When tracing an application with the trace debugger, the
current value returned by each expression will be written into
the trace output file so an application can be analyzed.
Examples:
. WATCH RECNO()
. WATCH ALIAS()
. WATCH CUST_NMBR
. WATCH ABROWSE[3,4]
. WATCH MYUDF()
. SET STEP ON
. DO MYAPP
See Also:
dc_watch()
WATCH CLEAR
Clear an expression from the WATCH table
Syntax:
Arguments:
(nTableEntry) is the number order of the watch expression in
the watch table to remove from the table. If you don't know
the entry number for the desired expression to remove, enter
the command WATCH with no parameters for a listing.
The ALL argument will remove all entries from the table.
Description:
WATCH CLEAR will clear watch expressions previously loaded into
the watch table with the WATCH (expression) command.
Examples:
. WATCH RECNO()
. WATCH TIME()
. WATCH EOF()
. WATCH CLEAR 2
. WATCH
Watch 1 = RECNO()
Watch 2 = EOF()
See Also:
dc_watch()
WHERE
Locate the name of the .OBJ/.PRG that contains a function
Syntax:
Arguments:
(idProcedure) is the name of the procedure or function to find.
Description:
WHERE is used to find the location of a function or a procedure
by searching map tables and dynamic-library tables which have
been loaded with the MAP LOAD command or LIB LOAD command.
WHERE will display the name of the .OBJ/.PRG file that contains
the function you are trying to locate.
Notes:
WHERE will only find the location of a procedure if it was
listed in a .LST map file or a dynamic library.
If map or dynamic library files are not loaded, you can search
for the function by scanning all .OBJs with the MAP PUBLIC
command.
Examples:
. MAP LOAD DEMO
. WHERE CALC
DEMO1
. LIB LOAD MYAPP
. WHERE MAINMENU
MAIN
See Also:
dc_objfind()
WHERE PUBLIC
WHERE EXTERNAL
WHERE EXTERNAL
Scan all .OBJs to locate calls to a specified function
Syntax:
Arguments:
(idProcedure) is the name of the procedure or function to
locate.
(xcListFile) is the name of an output file to write the list of
.OBJs in which a call to the (idProcedure) is found. If no
list file argument is given then the file name(s) in which the
external references are found will be displayed on the screen.
Description:
WHERE EXTERNAL is used to scan a set of .OBJ files and list all
files that contain at least one call to a specified function.
This command is handy when it is necessary to find all program
files that call a function or procedure because of a need to
change the procedure name, remove it from a library, change it
to a STATIC, etc.
Examples:
. SET ODIR TO \MYAPPS\OBJS
. WHERE EXTERNAL DC_COLOR TO DCCOLOR.EXT
See Also:
dc_objexternal()
WHERE PUBLIC
WHERE PUBLIC
Scan all .OBJs to find a public procedure/function
Syntax:
Arguments:
(idProcedure) is the name of the procedure or function to
locate.
WHERE PUBLIC is used to scan a set of .OBJ files for the source
of the public definition of a function or procedure.
Description:
WHERE PUBLIC is used to scan a set of .OBJ files for the source
of the public definition of a function or procedure.
Examples:
. SET ODIR TO \MYAPPS\OBJS
. WHERE PUBLIC MAINMENU
See Also:
dc_objpublic()
WHERE EXTERNAL
WHILE
Evaluate set of expressions while an expression is true
Syntax:
Arguments:
(lCondition) is an expression to evaluate in a loop. The list
of expressions defined by (exp1) - (expN) will be evaluated
continuously as long as (lCondition) evaluates .true. otherwise
the loop will be terminated.
Description:
WHILE is used to evaluate a series of expressions in a loop
while a condition evaluates .true.
Examples:
. USE BASEBALL
. WHILE !EOF() DO DBSKIP(), QOUT(PLAYER,TEAM)
WORK CONVERT
Convert a dCLIP 2.5 DCDBF.DBF to .DCW file(s)
Syntax:
Arguments:
(cFile) is the name of the old database file. If no file name
is given then DCDBF.DBF is assumed.
Description:
WORK CONVERT is used to convert an old DCDBF.DBF file (used
by dCLIP versions 2.0 and 2.5) to separate .DCW (work) files
used by dCLIP 3.0. A DCDBF.DBF file in previous versions of
dCLIP was used to store information about which database
and index files to open when using the old DC_ASSIST()
function or ASSIST command. The new database assistant has
many more options and requires a much more versatile system,
therefore a single DCDBF.DBF file cannot store the required
information.
Each record in the old DCDBF.DBF file will be copied to a
separate .DCW file. After creating the .DCW files, use the
RESTORE WORK command to open your databases.
Examples:
. set default to \myfiles
. WORK CONVERT DCDBF
ZAP
Remove all records from the current database
Syntax:
Arguments:
See Clipper 5.0 Guides
Description:
See Clipper 5.0 Guides
See Also:
dc_zap()
UTIL