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.
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" |