Re: Access97 passthrough Oracle 7.3

From: Barney Gumble <duff.drinker_at_cornerpub.FUDD-SUX>
Date: 1999/03/09
Message-ID: <36E4C8D5.6241F4C8_at_cornerpub.FUDD-SUX>#1/1


Thanks for reply. I found another way to do this.

    BG :o)

Matthias Gresz wrote:

> Barney Gumble schrieb:
> >
> > How can I defined variables in PassThrogh Query in Access97?
> > When I make an Access query I can put field's name as variable:
> >
> > SELECT * FROM xxxxx WHERE yyyy=[Forms]![MyForm]![MyField];
> >
> > It works for local/attached tables. No good for client/server.
> > Is there any way I can do this in Access PassThrogh Query? (to
> > Oracle7.3)
> > AFAIK Access sends the whole thing to Oracle instead of substituting
> > "[Forms]![MyForm]![MyField]" with value of that field. Anyone can help
> > me?
>
> won't a temporarely var do?
>
> szSQL="SELECT * FROM xxxxx WHERE yyyy=" & Forms!MyForm!MyField & ";"
>
> HTH
> Matthias
> --
> grema_at_t-online.de
>
> Protect privacy, boycott Intel: http://www.bigbrotherinside.org

--
"Your infatuation is based on a physical attraction.
Talk to the woman and you'll realize you have nothing
in common. >>>BURP!!!<<<"
-----------------------------------------------------
Replace ".FUDD-SUX" with ".com" to reply.
Received on Tue Mar 09 1999 - 00:00:00 CET

Original text of this message