LO Base not handling computed/generted/calculated column properly

[jpage]

Scenario: SQLite back end database accessed by Base via ODBC connection. Works well except when there is a generated column defined on the back-end table.

Symptoms:

1. Examining the table, the column content is displayed. When entering data in a column following the generated column, the input data shows up in the column after the modified column (when no trigger on the underlying table), or an error if the modified column is the last one in the row.
2. Accessing the table through a form, the generated column is not available.

I suspect that Base does not recognize the column type and that this causes the errors I have observed.

[Wanderer]

@jpage

Works well except when there is a generated column defined on the back-end table.

Never had problems, neither for queries nor in joins or views.
.
Can you share the SQL you use to generate your column?
.
If you problem happened to me (especially in a form) I’d guess my form is wired to the wrong source, but I’m sure you ruled this out before posting here.