lobase and postgresql views

classic Classic list List threaded Threaded
3 messages Options
Lou Lou
Reply | Threaded
Open this post in threaded view
|

lobase and postgresql views

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: [hidden email]
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
drew-gmail drew-gmail
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]> 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: [hidden email]
> 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: [hidden email]
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
Lou Lou
Reply | Threaded
Open this post in threaded view
|

Re: lobase and postgresql views

Drew,
Thanks. You have saved me from more hopeless effort.
Lou

On 12/4/18 5:02 AM, Drew Jensen wrote:

> 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 <[hidden email]> 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: [hidden email]
>> 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: [hidden email]
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