Re: [libreoffice-users] lobase and postgresql views

Howdy Lou,

OK, so first thing. Base does not support updating data in Views (postgres
or any other database backend).

Second thing, the order of your columns in a table definition in a
relational database is meaningless for the most part. I know that the Base
Table viewer doesn't allow you to rearrange them, but it should.

Third, what the table viewer doesn't do, the grid control in forms does, so
If you want to see your table in a column (grid) view and with the columns
in a different order than what is in the table definition and you want to
update that data you can use a form.
Start with just a single table. Use the form wizard to create a form based
on the table and select the default grid control for the data. (easiest way
is to just start the wizard, select a table and click Done) With the
physical form opened in edit mode click on the 'Design mode' button on the
form toolbar, you will see the data in the grid control, now you can use
the mouse to move columns around by dragging them, you can expand or
condense the width of columns and change the display formatting for
columns. When you have the columns arranged as you like you save the form
and that will be the default view of the table layout when you open the
form normally going forward.

Fourth - if you need to update data in two tables Base does have limited
support, but again not using Views, with queries. You join the tables
there, include all the keys from both tables in the result set along with
other columns you want to edit and be sure the query runs with the designer
mode enabled in query builder. In those case the resultset should capable
of updates. Otherwise the use of a form-subform using the two tables
certainly will be.

Hope that helps,

Drew

On Tue, Dec 4, 2018 at 2:04 AM Lou <lou@dayspringpublisher.com> wrote:

> Hi everyone,
>
> This is my first post here.
>
> I have a postgresql database with two tables with an inner join. There
> are about 25 columns in each table, and about 9,500 rows. Since columns
> were added to the table in an order I don't like, I use a view to put
> them in a more logical order.
>
> Problem: when I use lobase to create a form based on the view, it will
> not allow updating.  I can view the data, but not save edited data. Am I
> doing something wrong, or is updating not allowed on views?
>
> Thanks in advance for any help.
>
> Lou
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy