RECCOUNT() Counts the number of records in a database. Syntax RECCOUNT()* | LASTREC() –> nRecords Arguments (This function has no arguments) Returns <nRecords> The number of records Descriptions This function returns the number of records present in the database in the selected or designated work area. If no records are present the value of this … Continue reading
RECCOUNT()* Determine the number of records in the current database (.dbf) file —————————————————————————— Syntax RECCOUNT()* | LASTREC() –> nRecords Returns RECCOUNT() returns the number of physical records in the current database file as an integer numeric value. Filtering commands such as SET FILTER or SET DELETED have no affect on the return value. RECCOUNT() returns … Continue reading
RangeRem RangeRepl RAt Rate RD / RMDIR / DirRemove ReadKey ReadVar() RecCount RecNo RecSize RemAll RemLeft RemRight ReplAll Replicate ReplLeft ReplRight RestToken Right RLock Round Row RToD RTrim
Database Functions AFields Fills referenced arrays with database field information Alias Returns the alias name of a work area BOF Test for the beggining-of-file condition dbAppend Appends a new record to a database file dbClearFilter Clears the current filter condiction in a work area dbCloseAll Close all open files in all work areas. dbCloseArea Close … Continue reading
LASTREC() Returns the number of records in an active work area or database. Syntax LASTREC() | RECCOUNT()* –> nRecords Returns <nRecords > The number of records Description This function returns the number of records present in the database in the selected or designated work area. If no records are present the value of this function … Continue reading
DBRLOCK() This function locks the record based on identity Syntax DBRLOCK([<xIdentity>]) –> lSuccess Arguments <xIdentity> Record identifier Returns DBRLOCK() returns a logical true (.T.) if lock was successful Description This function attempts to lock a record which is identified by <xIdentity> in the active data set. If the lock is successful the function will return … Continue reading
Coding Guidelines ( by Greg Holmes ) Language Syntax The general rule of thumb is: built-in features in lowercase, and custom-written functions in mixed case. When specifying the complete syntax of a language element in documentation, the input items, parameters, and so on are referred to using the following symbols: Symbol Description < > Indicates … Continue reading
Obsolete Language Items —————————————————————————— In the Reference guide, the asterisk symbol is used to indicate items in the language that are obsolete or that exist for compatibility with previous releases of Clipper. As you begin to incorporate new product features into your existing applications, it would be advisable to review your code to determine any … Continue reading
Reserved Word and Function Names ——————————————————————————— ——————————————————————————– IF | AADD CTOD EXP INT MONTH ROW TIME ELSE | ABS DATE FCOUNT LASTREC PCOL RTRIM TRANSFORM ELSEIF | ASC DAY FIELDNAME LEN PCOUNT SECONDS TRIM ENDIF | AT DELETED FILE LOCK PROW SELECT TYPE WHILE | BREAK DEVPOS FLOCK LOG RECCOUNT SETPOS UPPER ENDCASE | BOF … Continue reading
ORDKEYDEL() Delete a key from a custom built order —————————————————————————— Syntax ORDKEYDEL([<cOrder> | <nPosition>], [<cIndexFile>], [<expKeyValue>]) –> lSuccess Arguments <cOrder> | <nPosition> is the name of the order or a number representing its position in the order list. Using the order name is the preferred method since the position may be difficult to determine using … Continue reading
Viva Clipper ! 