Skip site navigation (1) Skip section navigation (2)

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

From: Webb Sprague <wsprague100(at)yahoo(dot)com>
To: Cedar Cox <cedarc(at)visionforisrael(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Pass through query help (please ...:)
Date: 2002-07-01 20:09:22
Message-ID: 20020701200922.83761.qmail@web14203.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
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



In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-07-02 02:17:34
Subject: Re: "Field is too small"
Previous:From: Cedar CoxDate: 2002-06-29 11:19:03
Subject: Re: Pass through query help (please ...:)

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-07-02 14:39:52
Subject: Re: psql 7.2.1: \d (alone) missing from \?
Previous:From: AlfredoDate: 2002-07-01 19:06:04
Subject: How can I unsuscribe me from the list?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group