jujiboutils

From Free Pascal wiki
Revision as of 11:50, 14 October 2011 by Jujibo (talk | contribs) (Add DBGridControl screenshot)
Jump to navigationJump to search

Set of components to input and validate different kinds of data, floats, dates, etc. while working with db and non db controls.


Locate the components

Non-DB aware: Additional-light.png

TJLabeledIntegerEdit: input of integer numbers. Main properties: DisplayFormat, EditLabel.Caption, LabelPosition and Value. DisplayFormat example value: '0 ºC'

TJLabeledFloatEdit: input of float numbers. Main properties: Decimals, DisplayFormat, EditLabel.Caption, LabelPosition and Value. DisplayFormat example value: '#,0.00'

TJLabeledCurrencyEdit: input of currency numbers. Main properties: Decimals, DisplayFormat, EditLabel.Caption, LabelPosition and Value. DisplayFormat default value is '#,0.00' and Decimals=2

TJLabeledDateEdit: input of dates values. Main properties: Decimals, DisplayFormat, EditLabel.Caption, LabelPosition and Value.

TJLabeledTimeEdit: input of time values. Main properties: Decimals, DisplayFormat, EditLabel.Caption, LabelPosition and Value.

TJLabeledDateTimeEdit: input of date-time values. Main properties: Decimals, DisplayFormat, EditLabel.Caption, LabelPosition and Value. The date and time must be separated by a space


Example-nondb.png

Notes about Date and time input:

In example, date: '01/02/2011' if you input .3, the result date will be '01/03/2011'. So for a system date format 'dd/mm/yyyy' 2. will set the day to two .5 will set the month to May and ..2012 will set the year to 2012. Of course you can supply none, one, two or three values


DB-aware: DataControls-light.png

These components work in the same way that Non-DB aware, except TJDBGridControl.

TJDBGridControl: input of db values in a grid. Auto detects type of data. Specialized cell editors for types: ftString, ftFloat, ftCurrency, ftBCD, ftDate, ftTime and ftDateTime. Special properties in columns like: Decimals (for ftFloat and ftCurrency), MaxLength (for ftString). Automatic decimals/scale detection for ftBCD. Allows null dates, times and date-times (empty values)


Example-db.png


Example-grid.png