Hour

It is the tool that allows us to see the hour in the form.

Hour tool icon at Toolbox

How it looks like on the Canvas

Remarks

It is a tool used to enter data into the fields that indicate the hour you use in your table. It has the datetime () data type. However, a field created by selecting the hour tool is registered to the database in the format DD.MM.YYYY HH: MM: SS (01.01.2019 10:56:14) as in the date-hour tool. If only the hour information is required in the field where the data will be used, a convert is required.

CONVERT (VARCHAR, Data to be converted (Field Name), 108)

The SQL query written above converts the data to be retrieved from the hour field to the format where the only hour is displayed. This is indicated by the 108 formats in the query

Properties

• Name: The name of the tool will be written here.

• Default Value: The value entered here comes into the tool l by default. If you want to enter data as the default value, you can write in the Default Value part. It fills the date area on the client screen.

• Text Size: Sets the size of the tool.

• Help Text: It is the text that is entered for comment when the mouse is placed on the tool.

• Icon: Select the icon, color, and position to be added to the tool.

• Text Fonts: Allows you to change the font.

• Text Type: Adjust the type of text like bold, italic, underlined, and replaces the text as right-aligned, left-aligned, or centered.

• Color: Edits the color of inside the tool and/or the text inside the tool.

• Height/Width: Adjusts the height and width of the tool.

• From Left/Top: Adjusts the distance of the tool from the left and top.

• Linked Object: Links to an object element created by action. When the object element runs, the information is filled in according to the object area.

• Linked Object Area: Selects the fields within the linked object area.

• Tab Order: Specifies the order of the tool within the form.

• Time Interval (Min.): Sets the minute interval of the time zone.

• Fit horizontal: Fits the tool to the full screen on the user’s screen.

• Pin Right: Pins the tool to the right.

• Display: Makes the tool not appear on the screen.

• Form Only: The information entered in the tool is not saved to SQL, but only in form.

Actions

• On Focus: Assign an “Action” as on focus handler. For more information please click here.

• On Blur: Assign an “Action” as on blur handler. For more information please click here.

• When the value changes: Assign an “Action” as on value changes handler. For more information please click here.

• Keyboard Input: Assign an “Action” as on keyboard input handler. For more information please click here.

• Validation: Assign an “Action” as on value tool handler. For more information please click here.

• Calculate: Assign an “Action” as a calculate handler for the grid tool. For more information please click here.

• Icon Clicked: Assign an “Action” as click handler for the icon. For more information please click here.

Examples Used

When the form is opened you want to specify the first value, you can change the Default value area. For example; to make “00:00”  an hour, it is written in this area.

Client view on screen