__dbSDF()
Copies the contents of a database to an SDF text file or
- Syntax
-
- __dbSDF( <lExport>, <xcFile>, [<aFields>],
- [<bFor>], [<bWhile>], [<nNext>], [<nRecord>], <lRest> ) --> NIL
- Arguments
-
- <lExport> If set to .T., copies records to an SDF file. If set to .F., append records from an SDF file. <xcFile> The name of the text file to copy to or append from. If a file extension is not specified, ".txt" is used by default. <aFields> An aray of field names to limit the processint to. If not specified, or if empty, then all fields are processed. <bFor> An optional code block containing a FOR expression that will reduce the number of records to be processed. <bWhile> An optional code block containing a WHILE expression that will reduce the number of records to be processed. <nNext> If present, but nRecord is not present, specifies to process this number of records, starting with the current record. A value of 0 means to process no records. <nRecord> If present, specifies the only record to process. A value of 0 means to process no records. Overrides nNext and lRest. <lRest> If lExport is .T., then if set to .T. and there are no nRecord, nNext, or bWhile arguments, processes all records from current to last.
- Returns
-
- NIL
- Description
-
- __dbSDF() copies all or selected contents of a database table to an SDF text file or appends all or selected contents of an SDF text file to a database table.
Examples
// Copy delinquent accounts into an SDF text file.
USE ACCOUNTS NEW
COPY TO overdue SDF FOR !EMPTY( accounts->duedate ) ;
.AND. DATE() - accounts->duedate > 30
// Import new customer records.
USE CUSTOMER NEW
APPEND FROM customer SDF
Tests
- Status
- Started
- Compliance
-
- __dbSDF() is intended to be fully compliant with CA-Clipper's function of the same name and is the underlying implementation of the APPEND FROM SDF and COPY TO SDF commands.
- Platforms
-
- All
- Files
-
- See Also