JVCL Help:TJvCustomCsvDataSet.CsvFieldDef

From Project JEDI Wiki
Jump to navigationJump to search
JEDI Visual Component Library Help

Search in JVCL Help

 
Search in all projects
 

Summary

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) #
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)


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