This question is locked. New answers and comments are not allowed.
Hi!
We're using OpenAccess ORM with Firebird, and we have a problem:
We're using firebird views as entities in the ORM, and we also use firebird system tables to get field information (size, default value etc.) about the table fields which views use (to have some basic validation in our app).
A lot of our old tables use char type fileds wich contain ending spaces. We'd like to trim these.
At first we tried to trim the fields in the views' sql, it works fine, but at the same time the trimmed fields suddenly disappear from firebird system tables, so we cannot get table field information anymore, so we dropped the solution of trimming in views' code. We cannot modify the base tables either. Annoying.
So we're looking forward the best and most elegant solution in our data access layer, in application code (where a sort of other problems can appear: change of context state because of trimming, etc).
Every idea is appreciated.
Thanks in advance,
Peter
We're using OpenAccess ORM with Firebird, and we have a problem:
We're using firebird views as entities in the ORM, and we also use firebird system tables to get field information (size, default value etc.) about the table fields which views use (to have some basic validation in our app).
A lot of our old tables use char type fileds wich contain ending spaces. We'd like to trim these.
At first we tried to trim the fields in the views' sql, it works fine, but at the same time the trimmed fields suddenly disappear from firebird system tables, so we cannot get table field information anymore, so we dropped the solution of trimming in views' code. We cannot modify the base tables either. Annoying.
So we're looking forward the best and most elegant solution in our data access layer, in application code (where a sort of other problems can appear: change of context state because of trimming, etc).
Every idea is appreciated.
Thanks in advance,
Peter