[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: DataBrowser bug: Primary Key contains an ampersand


Il 20/11/24 04:57, BB ha scritto:
If the primary key of the table is a text column (string) and a record's
PK field contains an ampersand, e.g. "A&E" then the record is not saved
after editting other columns.

b

I'm no database expert, far from it, but I don't think putting an
ampersand in a primary key is a good idea.
If it is not possible to replace the ampersand through the code it is
better to add a serial key to the table.

Regards
Gianluigi


Follow-Ups:
Re: DataBrowser bug: Primary Key contains an ampersandBB <adamnt42@xxxxxxxxx>
References:
DataBrowser bug: Primary Key contains an ampersandBB <adamnt42@xxxxxxxxx>