__dbDelim()

Copies the contents of a database to a delimited text file or

Syntax

__dbDelim( <lExport>, <xcFile>, [<xcDelim>], [<aFields>],
[<bFor>], [<bWhile>], [<nNext>], [<nRecord>], <lRest> ) --> NIL

Arguments

<lExport> If set to .T., copies records to a delimited file. If set to .F., append records from a delimited 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. <xcDelim> Either the character to use as the character field delimiter (only the first character is used). or "BLANK" (not case sensitive), which eliminates the character field delimiters and sets the field separator to a single space instead of a comma. <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

__dbDelim() 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 a delimited text file.
      USE ACCOUNTS NEW
      COPY TO overdue DELIMITED FOR !EMPTY( accounts->duedate ) ;
      .AND. DATE() - accounts->duedate > 30
      // Import new customer records.
      USE CUSTOMER NEW
      APPEND FROM customer DELIMITED
Tests

Status

Started

Compliance

__dbDelim() is intended to be fully compliant with CA-Clipper's function of the same name and is the underlying implementation of the APPEND FROM DELIMITED and COPY TO DELIMITED commands.

Platforms

All

Files



See Also