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

Pass through query help (please ...:)

From: Webb Sprague <wsprague100(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Pass through query help (please ...:)
Date: 2002-06-28 21:38:51
Message-ID: 20020628213851.27785.qmail@web14203.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-odbc
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



In response to

Responses

pgsql-odbc by date

Next:From: Cedar CoxDate: 2002-06-29 11:19:03
Subject: Re: Pass through query help (please ...:)
Previous:From: Oskar BerggrenDate: 2002-06-28 13:58:14
Subject: Re: Bugs: fill value with cursor

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-06-28 23:25:37
Subject: Re: psql 7.2.1: \d (alone) missing from \?
Previous:From: Alvaro HerreraDate: 2002-06-28 20:59:19
Subject: bug in numeric locale

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