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

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

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: Webb Sprague <wsprague100(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Pass through query help (please ...:)
Date: 2002-06-29 11:19:03
Message-ID: Pine.LNX.4.21.0206291358530.16234-100000@nanu.visionforisrael.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
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
> 
> 
> 




In response to

Responses

pgsql-odbc by date

Next:From: Webb SpragueDate: 2002-07-01 20:09:22
Subject: Re: Pass through query help (please ...:)
Previous:From: Webb SpragueDate: 2002-06-28 21:38:51
Subject: Pass through query help (please ...:)

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-06-29 11:22:39
Subject: Bug #700: pqReadData() -- backend closed the channel unexpectedly.
Previous:From: Amit MishraDate: 2002-06-29 11:01:05
Subject: pqReadData() -- backend closed the channel unexpectedly.

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