Re: executing a procedure withing a procedure?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: ben sewell <mosherben(at)gmail(dot)com>
Cc: Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org>
Subject: Re: executing a procedure withing a procedure?
Date: 2006-08-14 11:07:36
Message-ID: 20060814110736.26553.qmail@web31810.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> What do I add on the front end in order to bid the form to a view when
> updating data?

Don't forget to copy the list when you have a question so that other can reply also.

I am not sure I understand your first question. But if you want to bind a view to a form in
ms-access, look at:
http://www.postgresql.org/download/
under application interfaces -- odbc

> Also, the procedure I need to write are for a report in access. How would I
> link the procedure to the report? I do have several parameters for the
> procedure, so any advice is welcome.

hmm.. I never tried binding a report to a pl-pgsql function before. I imagine that you could do
it through a pass-through query where you:
select * from <your_function>;

Alternitivly, you could create a view in postgresql that is a "select * from <your_function>" and
then bind your report to that view.

Regards,

Richard Broersma Jr.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike Ellsworth 2006-08-14 12:00:59 Alter column
Previous Message Richard Broersma Jr 2006-08-14 04:09:54 Re: password authentication failed for user "postgres"