[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openoffice-users
Subject:    Re: [users] Calc ODBC query paramaters from worksheet
From:       CPH <cphennessy () openoffice ! org>
Date:       2005-03-14 22:42:58
Message-ID: 200503142242.58779.cphennessy () openoffice ! org
[Download RAW message or body]

On Wednesday 09 February 2005 10:31, Hamish wrote:
> Sorry to push my question. I guess this is not possible? Or have I not
> explained properly? Does anyone get spreadsheet data from a database?
>
> > Hello everyone
> > I would like to convert some ms spreadsheets to OOo, but I am having
> > problems with one point: The spreadsheets get their information from an
> > ODBC query, and can be updated for the latest data. Paramaters for the
> > queries (like from_date etc) can be prompted for, but I want the
> > parameters to come from the spreadsheet. ie Query is {SELECT * FROM foo
> > WHERE bar = ?} then I want it to get the value of ? from a cell on the
> > spreadsheet. It prompts for parameters at the moment, but i want to be
> > able to fetch them from a spreadsheet cell instead.
> > Hope I have explained clearly!
> > Thanks,
> > H

Hi Hamish,
  Not sure if you still have this problem, but you may want to ask on 
dev@dba.openoffice.org for more help.


-- 
CPH : openoffice.org contributor

Maybe your question has been answered already?
				http://user-faq.openoffice.org/#FAQ

[prev in list] [next in list] [prev in thread] [next in thread]