List Default Column Types (When Defined With Names Only)
Data1, Data2, Data3 etc are pre-declared within a Map, but must be explicitly declared within a Custom Script.
Data1, Data2, Data3 etc are pre-initialised within a Map, but must be explicitly initialised within a Custom Script.
Data1, Data2, Data3 etc are cleaned up automatically by a Map, but must be explicitly removed for Custom Script.
procedure ScriptEvent (var Value : variant);var Data1: TFloClientDataSet; f: integer; vField: TField; vInfoStr: string;begin Data1 := TFloClientDataSet.Create(nil);{ DEFINE the column structure of the dataset - specify Names and accept default Type(Size) of string(255)} // create the dataset, with columns named 'ID' and 'Name' GetCustomDataSet(Data1,['ID','Name']); for f := 0 to (Data1.Fields.Count - 1) do begin vField := Data1.Fields.Fields[f]; vInfoStr := 'Field/column ' + IntToStr(f) + ': '; vInfoStr := vInfoStr + 'Name=' + vField.FieldName + ';'; vInfoStr := vInfoStr + 'Type=' + IntToStr(Ord(vField.DataType)) + ';'; vInfoStr := vInfoStr + 'Size=' + IntToStr(vField.Size) + ';'; vInfoStr := vInfoStr + IfThen(vField.Required, 'Reqd=Yes', 'Reqd=No') + '.'; LogInfo(vInfoStr); end; if (Assigned(Data1)) then Data1.Free;end;The list of column Type index values and codes is set out in TFieldType .