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@visionforisrael.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