Re: Pass through query help (please ...:)

Hi Cedar,

I have searched google postgres.odbc for your name,
and I can't find anything that works (I just want to
cut and paste something in). Can you or anyone else
point me to an example or a tutorial?

Thx
W
--- Cedar Cox <cedarc(at)visionforisrael(dot)com> wrote:
>
> Hi. Yes, I do still lurk here. Yes, it is possible
> to do what you
> want. Have a look in the list archives at some of
> my ODBC VB
> function stuff. It has to do with using passthrough
> queries for the
> datasource of list and combo boxes (maybe you wanted
> this??).
> You'll see how I did it in there and it should help
> you out. One
> thin you'll want to change is a parameter that means
> "query does not
> return a data set". I won't tell you details here
> because I
> probably don't remember them correctly. If you want
> an answer
> right now then go search, or else maybe someone else
> will reply
> too. The 'Building Applications with MS Access'
> book is of
> value too.
>
> -Cedar
>
> On Fri, 28 Jun 2002, Webb Sprague wrote:
>
> > Hi all,
> >
> > I would like to do a pass through query in a form
> as
> > part of a button-click event. I just want to fire
> off
> > a PL/PGSQL function on the Postgres server.
> >
> > Is this possible? Is it easy? I just want to
> insert
> > it below where the comment says:
> >
> > Private Sub foobar_Click()
> > On Error GoTo Err_foobar_Click
> >
> > 'FIRE OFF SERVER FUNCTION HERE
> > 'SELECT server_func()
> >
> > DoCmd.GoToRecord , , acNewRec
> >
> > Exit_foobar_Click:
> > Exit Sub
> >
> > Err_foobar_Click:
> > MsgBox Err.Description
> > Resume Exit_foobar_Click
> >
> > End Sub
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> >
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> >
> >
>

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com