name fields with special characters
lazarus / 16-Databases

----------------------------------------------------------------------
Kenobi · 2015-07-26 20:06

I 'm connecting with a bd in access continenen whose tables field
names with special characters , I need to get the fields to use in
dbaware components or even table.fieldByName ( ' field_with_Ñ " )
Thank you ....

----------------------------------------------------------------------
howardpc · 2015-07-27 06:51

Pascal identifiers such as fieldnames have to be composed of legal
Pascal characters (alphabetic, underline, or 0..9 as second or later
character). The compiler, naturally, enforces this.
So to deal with illegal fieldnames in Pascal you would have to write a
two-way mapper function that internally renamed and reassigned a legal
identifier to the illegal one every time it was encountered.

----------------------------------------------------------------------
taazz · 2015-07-27 11:59

1) what is the error message you are getting.
2) any chance of naming the database or providing a small sample
application that demonstrates your problem?

In some cases it is required that field name that have names that in
one way or an other conflict with the database/library is to enclose
those names in various characters eg in mysql you can enclose them in
`` in access you can use []. We need more info.

----------------------------------------------------------------------
Kenobi · 2015-07-29 15:57

Attached is a small example of the problem for the tests as requested

Thanks a lot

----------------------------------------------------------------------
taazz · 2015-07-29 16:28

For me the table opens and show the data there is a problem with
unicode characters in the field name as expected from fpc 2.6.4 which
I expect to be solved on the next release ee fpc 3.0 but other than
that I can't see a problem in the attached demo. See attached screen
shot.

----------------------------------------------------------------------
Kenobi · 2015-07-29 20:06

the problem is to enter the field in capturing appoints as firstâ ? or
who can not access it by its real name table.fieldByName ( ' FirstAño
' ) and I can not for that field this table in different positions (
in different tables ) with table.fields [ N ]
expected to be a solvable problem , hurts .....