Postgres and Calc

users
#1

Hi Duncan,

I am attempting to connect a query such as
    select quantity from item_table where location_id = 1 and item_id = 1
and owner_id = 1
to a Libreoffice Calc cell for instance sheet1.d7

I don't see how you can do this absent the use of a macro or some other
script to parse the data in your cells that are not part of the query,
then compose the query and send that to your pg backend.

As a more complex version I would like to do something like
    select quantity from item_table where location_id = Sheet2.E16 and
item_id = Sheet2.H16 and owner_id = Sheet2.C1
(Drop down box's at those locations would give back full points although
not needed to make things work)

I would assume that the same would be required here, i.e. macros /
scripting.

You might try asking your question on the OpenOffice.org forum, I'm
pretty certain something similar has been asked already.

Alex