JVCL Help:TJvCsvDataSet.CsvFieldDef
JVCL Help: TJvCsvDataSet.CsvFieldDef Property
Search in JVCL Help
Search in all projectsSummary
Comma separated list of field names.
Pascal
propertyCsvFieldDef: string;
Description
The CsvFieldDef property is the most important property in the CSVDataSet. You MUST set it up (using the property editor or by typing a valid CsvFieldDef string) before you can use the CSV Data Set.
A CsvFieldDef string is a comma separated list of field names. After each field name, an optional colon may be used to separate the field name from field options, which are described below.
- Fieldname must start with a Letter (A-Z) and can contain Letters, Numbers and Underscores.
- Field Types are described below. $ is a string. Other punctuation indicates other types.
- Length ONLY applies to string fields.
| Field Types Meaning ----------- |
| $ string (ftString) - also used if no character is given. May be followed by the length, a length of 80 is assumed if "$" is used without a specific length (For example, ABC:$100 is a field named ABC, type string, string length 100). |
| % whole integer value (ftInteger) |
| & floating point value (ftFloat) |
| @ Ascii datetime value (ftDateTime) as YYYY/MM/DD HH:MM:SS (Component Specific) |
| / Ascii date value (ftDate) as YYYY/MM/DD (Component Specific) |
| * Ascii time value (ftTime) as HH:MM:SS (Component Specific) |
| # Hex-Ascii Timestamp (A93F38C9) seconds since Jan 1, 1970 GMT (Component Specific) |
| ^ Hex-Ascii Timestamp (A93F38CP) corrected to local timezone (Component Specific) |
| ! Boolean Field (0 in csv file=false, not 0 = true, blank = NUll) |
| ~ Widestring (no length parameter) |
CsvFieldDef string Example: NAME:$80,ADDRESS:$140,AGE:%,BIRTHDAY:@
About
Notes
You can use the built-in property editor (Click ...) Instead of manually typing the CsvFieldDef.
Contribute to this help topic
This documentation wiki is based on the collaborative effort of Project JEDI users. Your edits are welcome in order to improve documentation quality: edit this page
