Re: Access97 passthrough Oracle 7.3

From: Barney Gumble <duff.drinker_at_cornerpub.FUDD-SUX>
Date: Tue, 09 Mar 1999 08:08:05 +0100
Message-ID: <36E4C8D5.6241F4C8@cornerpub.FUDD-SUX>

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 - 01:08:05 CST