Summary: | Form Combobox Not Working With Postgres | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Alexander <alexander.n.kirilov> |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEEDINFO --- | ||
Severity: | normal | CC: | robert |
Priority: | medium | ||
Version: | 7.4.3.2 release | ||
Hardware: | All | ||
OS: | Linux (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | control properties |
Description
Alexander
2022-12-26 13:25:25 UTC
Created attachment 184354 [details]
control properties
Only had a look at the screenshot: You have connected the combo box to a field called "group_id". This group_id is an INTEGER, defined in your table. Then you try to fill it with "group_name" - defined as VARCHAR. The field itself will only show INTEGER. Seems you are looking for a list box, not a combo box. List boxes will show the group_name and save the group_id. Try a list box with this code: SELECT "group_name", "group_id" FROM "public"."user_group" Bound field in data should be default (1). So "group_id" will be saved in the table while "group_name" will be shown. No reaction since nearly a year. Could we close this one as WORKSFORME? |