DISPLAY FORMAT LAZARUS CODE

The float field can be formatted as '#,#0.00' so when this float field have a value of 10 it will be displayed in the StringGrid as 10,00 (and not 10 as it will be displayed if I not have a DisplayFormat property set to the format string I wrote above ('#,#0.00')). The integer field will not have a format. The other string field will have a format (for example a phone number (1234-5678) the – character of the phone number is not stored in the database it will only be shown in the StringGrid). One of these string fields will not have a format (for example a name).

There is no property of the TZquery I can use for that ?įor example, my query can return 4 columns (Two string field type, one integer field type and one float field type ). I would like to try to not pass the field format (for each field of the query) as a parameter to this generic form to make the “function call” as simple as possible, without to many parameters. I would like to format this TstringField this way 1-0 only for display.

DISPLAY FORMAT LAZARUS CODE

The Product code field is a varchar(10) with a string of 10 numbers (for example 1234567890). (It is displayed correctly – formated – on the StringGrid) On the numeric fields of this TzQuery (for example Quantity) I can use the property DisplayFormat with the format desired for that field. (This generic form is used in various situations, not only to choose products. The objective is to allow the user choose for example one product among a list of products that fits on a determined context.

I am using a dynamically created TzQuery (to query a Firebird/Interbase Database), so, no components dropped on a Data Module or Form, passed as a parameter to a generic form with a StringGrid (read only) that have it's columns dynamically created according to the Query that is passed as a parameter to this generic form.

Display format lazarus