SelectSQL Fields |
[This is preliminary documentation and is subject to change.]
The SelectSQL type exposes the following members.
Name | Description | |
---|---|---|
Caption |
Field label etc. displayed in data entry form
(Inherited from CaptionBase.) | |
ClassNameControl |
Stylesheet classname for control
(Inherited from TmplItem.) | |
ClassNameControlCell |
Stylesheet classname for table cell containing control
(Inherited from TmplItem.) | |
ClassNameLabel |
Stylesheet classname for label
(Inherited from TmplItem.) | |
ClassNameLabelCell |
Stylesheet classname for table cell containing label
(Inherited from TmplItem.) | |
ClearOnCopy |
This TmplItem will be cleared when copying
(Inherited from TmplItem.) | |
Comment |
Internal comment for use by designer
(Inherited from TmplItem.) | |
Computation |
Expression that computes default value for field
(Inherited from DataNameBase.) | |
ConnectString |
The database to connect to (leave blank to use default)
| |
ConvertInfo |
Misc. conversion info.
(Inherited from TmplItem.) | |
DataName |
Name of table / field in data base
(Inherited from DataNameBase.) | |
DefaultLastPrevious |
True => field default value is set to last previous value
(Inherited from DataNameBase.) | |
Deleted |
TmplItem (and anything below it) is skipped when generating DataDictionary,
so fields will not be generated in database.
(Inherited from TmplItem.) | |
Description |
Textual description of field definition, use, etc.
(Inherited from DataNameBase.) | |
ExcludeFromPrint |
The TmplItem is excluded from the printed version of the form
(Inherited from TmplItem.) | |
FillInStatusComputation |
Specifies how empty field is treated
(Inherited from DataNameBase.) | |
FillInStatusSelect |
Specifies how empty field is treated
(Inherited from DataNameBase.) | |
Hidden |
Hidden fields generate fields in DataDictionary (and hence database),
but are not visible in input form.
(Inherited from TmplItem.) | |
HistoryCaption |
Field label displayed in history tree (
(Inherited from CaptionBase.) | |
HTMLName |
Field name in generated HTML form (blank: use DataName)
(Inherited from CaptionBase.) | |
InputFieldTooltip |
Show auto-generateed tooltip containing all enum values and corresponding captions
| |
InputFieldWidth |
Width of input field (in characters) - if not speecified (or =0) do not show input field.
| |
KeySize | ||
KeyType |
The type of the first row returned from the SQLQuery (currently only Text and Integer are supported)
| |
Link |
Reference (e.g. URL) to field definition
(Inherited from DataNameBase.) | |
ListColumn |
Columns in automatically generated list views are sorted by this value.
(Inherited from DataNameBase.) | |
MapToExternalField |
Corresponding field name in som external system - used for mapping during import/export
(Inherited from DataNameBase.) | |
MarkSingleRowSelected |
If only one row is returned from SQL and MarkSingleRowSelected = true, then that row
will be marked selected
| |
Number |
Should this field be numbered
(Inherited from CaptionBase.) | |
OnBlur |
Custom script for onblur-event
(Inherited from TmplItem.) | |
OnChange |
Custom script for onchange-event
(Inherited from TmplItem.) | |
OnClick |
Custom script for onclick-event
(Inherited from TmplItem.) | |
OnFocus |
Custom script for onfocus-event
(Inherited from TmplItem.) | |
OnKeyDown |
Custom script for onkeydown-event
(Inherited from TmplItem.) | |
OnKeyPress |
Custom script for onkeypress-event
(Inherited from TmplItem.) | |
OnKeyUp |
Custom script for onkeyup-event
(Inherited from TmplItem.) | |
PostProcess |
Code (e.g. .aspx) to execute on save
(Inherited from TmplItem.) | |
PreProcess |
Code (e.g. .aspx) to execute on load
(Inherited from TmplItem.) | |
PreProcessInstruction |
XPath expression to find values in preprocessed xml (MUST address an attribute)
(Inherited from DataNameBase.) | |
PublishChanges |
If true, the control is registered as a publisher, which means other controls can subscribe to changes on this control
(Inherited from DataNameBase.) | |
ReadFromFile |
The disk file this TmplItem was read from
(Inherited from TmplItem.) | |
ReadOnly |
Read only expression - if expression evaluates true, field may not be edited
(Inherited from DataNameBase.) | |
RunPreProcessInstructionOnEdit |
Normally the PreProcessInstruction is only run on when creating a new form, set this attribute
to also run the instruction when editing the form
(Inherited from DataNameBase.) | |
SetValueOnCopy |
Expression to set value on new recod in copy operation.
If not set, dfeautl beavior is to copy the value from the source record.
If set, evaluet expression, and set evaluated value on copy.
(Inherited from DataNameBase.) | |
ShowEnumValues |
Automatically display enum values in list
| |
SQLQuery |
The SQL query that generates data for the drop down. The SQL statement MUST return two columns, the first column
being the key for the row. The key is what is stored in the database. The key MUST be unique.
| |
SQLQueryForHistory |
Ths SQL used for generating history.
| |
StyleControl |
Inline style for control
(Inherited from TmplItem.) | |
StyleControlCell |
Inline style for table cell containing control
(Inherited from TmplItem.) | |
StyleLabel |
Inline style for label
(Inherited from TmplItem.) | |
StyleLabelCell |
Inline style for table cell containng label
(Inherited from TmplItem.) | |
subTmplItems |
tmpItemcollection
(Inherited from TmplItem.) | |
Tooltip |
Tooltip
(Inherited from CaptionBase.) | |
TooltipComputation |
Expression to compute tooltip value
(Inherited from CaptionBase.) | |
URLHelp |
URL with help etc. for this field
(Inherited from CaptionBase.) | |
ViewName |
Name of table / field in autogenerated views (optional - defaults to DataName)
(Inherited from DataNameBase.) | |
VisibleComputation |
Computation (formula) controlling visibility of item - true => item is visible
(Inherited from TmplItem.) |