Предыдущая страница реферата | 1  2  3  4  5  6  7  8  9 | Следующая страница реферата

The comma is not truly a delimiter.  However, the DELIMITED WITH BLANK or DELIMITED WITH TAB clauses allow you to replace the comma field separator with either a space or a tab.  The data should not contain embedded spaces or tabs.

You cannot combine the WITH clause with either the WITH BLANK or WITH TAB clauses.

Unless you specify otherwise, a .TXT extension is assigned to all newly created DELIMITED files.

The format of APPEND is:

APPEND FROM | ?

   [FIELDS ]

   [FOR ]

   [[TYPE]           [DELIMITED [WITH TAB | WITH | WITH BLANK] |

DIF | FW2 | MOD | PDOX | RPD | SDF | SYLK | WK1 | WK3 | WKS |

WR1 | WRK | XLS]]

Remarks

The file you are appending from is assumed to be a FoxPro table with a .DBF extension.  If the file you want to append from is a FoxPro table and doesn't have a .DBF extension, you must specify its extension.  If the file is a not a FoxPro table, you must specify the type of file you append from. 

Before you can append from a table created in dBASE IV that contains a memo field, you must first open the table in FoxPro with USE.  You are prompted with "Convert MEMO file to FoxPro Format?"  Choose Yes.

If you append from a FoxPro table, the table you append from can be open in another work area.  You can also append from a table that isn't open but is available on disk and a shared table opened when SET EXCLUSIVE is OFF.  When the table you append from contains records marked for deletion, the records are not marked for deletion after they are appended.

If you include the ? clause instead of including a table name, the Open dialog appears so you can choose a table to append from.

Clauses

Specify the name of the file to append from with .  If you don't include a file name extension, the default extension .DBF is assumed.

FIELDS

APPEND FROM supports an optional .  Data is only appended to the fields specified in the field list.

FOR

The entire source file is appended to the table unless you include the FOR clause.  If the FOR clause is included, a new record is appended for each record in the file source for which evaluates to a logical true (.T.).  Records are appended until the end of the file is reached. 

TYPE

If the file you are appending from isn't a FoxPro table, you must specify the file TYPE.  Although you must specify the file type, you need not include the key word TYPE.  You can append from a wide variety of different file types including DELIMITED ASCII text files in which you can specify a field delimiter.

If the file you are appending from doesn't have the usual default file extension for that type of file, the source file name must include the file's extension.  For example, Microsoft Excel spreadsheets normally have an .XLS file name extension.  If the spreadsheet you are appending from has an extension other than the expected .XLS, be sure to specify the extension.

Рекомендуем скачать другие рефераты по теме: контрольная работа 2, банк дипломов, вопросы и ответы.



Предыдущая страница реферата | 1  2  3  4  5  6  7  8  9 | Следующая страница реферата

Поделитесь этой записью или добавьте в закладки