Recent

Author Topic: [solve] TDBDynamicGrid - Unicode headers?  (Read 949 times)

Nicole

  • Hero Member
  • *****
  • Posts: 1095
[solve] TDBDynamicGrid - Unicode headers?
« on: February 08, 2024, 07:01:19 pm »
Thank you Tony, for this component.

I found, that Firebird 4 is able to hold field names different from ASCII.
Is it possible to display them in a TDBDynamiGrid better than "_"

At the moment I read "W_hrung" where I dream to read "Währung".
« Last Edit: February 09, 2024, 09:25:00 am by Nicole »

dsiders

  • Hero Member
  • *****
  • Posts: 1403
Re: TDBDynamicGrid - Unicode headers?
« Reply #1 on: February 08, 2024, 07:34:39 pm »
Thank you Tony, for this component.

I found, that Firebird 4 is able to hold field names different from ASCII.
Is it possible to display them in a TDBDynamiGrid better than "_"

At the moment I read "W_hrung" where I dream to read "Währung".

Is the column defined with double quotes around the column name with UTF-8 characters. If not, only regular name syntax is supported.

Code: Text  [Select][+][-]
  1. <name> ::=
  2. <letter> | <name><letter> | <name><digit> | <name>_ | <name>$
  3.  
  4. <letter> ::= <upper letter> | <lower letter>
  5. <upper letter> ::= A | B | C | D | E | F | G | H | I | J | K | L | M |
  6. N | O | P | Q | R | S | T | U | V | W | X | Y | Z
  7.  
  8. <lower letter> ::= a | b | c | d | e | f | g | h | i | j | k | l | m |
  9. n | o | p | q | r | s | t | u | v | w | x | y | z
  10.  
  11. <digit> ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
Preview the next Lazarus documentation release at: https://dsiders.gitlab.io/lazdocsnext

Nicole

  • Hero Member
  • *****
  • Posts: 1095
Re: TDBDynamicGrid - Unicode headers?
« Reply #2 on: February 08, 2024, 08:27:51 pm »
Thank you for your answer.
I am not sure, how it is meant.

Yes, the SQL which generates the table did it by "double quotation terms" within Firebird / FlameRobin.

The display in Lazarus is via IBX / TIBQuery.
is there a double quotation anywhere as well or is it advised to change my table?
Luckily it is empty at the moment because new born.


tonyw

  • Sr. Member
  • ****
  • Posts: 336
    • MWA Software
Re: TDBDynamicGrid - Unicode headers?
« Reply #3 on: February 08, 2024, 11:52:10 pm »
Thank you Tony, for this component.

I found, that Firebird 4 is able to hold field names different from ASCII.
Is it possible to display them in a TDBDynamiGrid better than "_"

At the moment I read "W_hrung" where I dream to read "Währung".

I am wondering if you are confusing two different things here.

The FieldName is constrained to be a valid Pascal Identifier so that it can be used by the FIelds Editor to add a field to your form (at design time). The field's identifier is created by concatenating the component (e.g. a TIBQuery) name and the field name.

On the other hand, a DBGrid's column _caption_ is set by default to the field name but can then be changed to anything you want in the IDE. For example, select the grid which you are using to display the "Währung" field and then, in the Object Inspector, look for and select  the "columns" property and click on the button (...) on the right hand side of the property. This will open the "Columns Editor".

In the Columns Editor, select the field you are interested in "W_hrung". The Object Inspector should now change to show the field properties. Look for and select the "Title" property, and open it up to show its properties. Change the "caption" to  "Währung". Save the result. On the form, the column caption should now have changed to  "Währung".

Nicole

  • Hero Member
  • *****
  • Posts: 1095
Re: [solve] TDBDynamicGrid - Unicode headers?
« Reply #4 on: February 09, 2024, 09:26:47 am »
thank you.

 

TinyPortal © 2005-2018