Re: Access97 passthrough Oracle 7.3

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