https://bugs.documentfoundation.org/show_bug.cgi?id=156355

--- Comment #5 from Robert Großkopf <[email protected]> ---
(In reply to jcsanz from comment #4)
> (In reply to Robert Großkopf from comment #3)
> 
> > Don't know where to find the view definition in Firebird, but execute...
> 
> The definitions and attributes of all tables and views are stored in
> RDB$RELATIONS, so you can obtain by SELECT * FROM RDB$RELATIONS, may be you
> want to add WHERE RDB$RELATION_NAME = 'viw_person'

Thanks!
And there is saved the same as it is opened by the editor.
The editor executes 
SELECT * FROM "tbl_person"
but Firebird doesn't execute this. It will only execute a query for the fields
shown in 
SELECT * FROM RDB$DEPENDENCIES

It is nice Firebird will save the view without changing the code to all
existing field names as other databases would do (internal HSQLDB, MariaDB …),
but we need the information for the user: Please safe again, not all fields
will be shown.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to