From: | "Andrew Sher" <acs974(at)hotmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | passing parameters to views (or alternative methods)? |
Date: | 2002-08-01 16:24:20 |
Message-ID: | F1095ZiZDXlubhEKvwC0002af31@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I'm new to the world of postgres and have a question which I've been
struggling with. I'm developing an application using visual basic as the
front end and I'm attempting to base a form on a query that produces one
record from two joined tables, producing 8 total fields (4 from each table).
The record is selected based on an ID number input earlier, producing a
similar query to something like (assuming the id number was 6):
select table1.ID, table1.field2, table2.ID, table2.field2 from table1,
table2 where table2.ID=table1.ID and table1.ID = 6).
Ideally, the user is then able to enter data into each field and have the
new data updated to the proper underlying fields. Because updatable joins
aren't supported, I was attempting to create a view that served the same
purpose. The problem I am running into is I don't know how to limit the view
to the one record I am trying to select via the ID number, which changes
each time the program is run. In other words, I want to use the same view
but be able to pass to it the ID number of the one record I want it to
return. I was wondering if this is possible via views, and, if not, are
there alternative ways to accomplish the task?
Thanks.
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
From | Date | Subject | |
---|---|---|---|
Next Message | Raouf | 2002-08-02 08:48:52 | please need help: alpha numeric sorting |
Previous Message | Ludwig Lim | 2002-08-01 04:14:34 | Re: pg_restore not working |