Pass through query help (please ...:) - Mailing list pgsql-odbc

From Webb Sprague
Subject Pass through query help (please ...:)
Date
Msg-id 20020628213851.27785.qmail@web14203.mail.yahoo.com
Whole thread Raw
In response to Re: "Field is too small"  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Responses Re: Pass through query help (please ...:)
List pgsql-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



pgsql-odbc by date:

Previous
From: Oskar Berggren
Date:
Subject: Re: Bugs: fill value with cursor
Next
From: Cedar Cox
Date:
Subject: Re: Pass through query help (please ...:)