Re: Query parameters

Use && in front of the variable name instead of &, BUT...

I found quite by accident that some queries execute MUCH faster ( 2 minutes vs 20 minutes) if you use the dummy table solution. I know it doesn't make sense, but the proof was in the pudding.

Markus Janscha <markus_at_janscha.co.uk> wrote in message news:833dr7$k7m$1_at_gxsn.com...
> Hey there,
>
> I am trying to create three independent queries, all stored in one *.sql
> file, that do something after the user enters one parameter at run time.
> The accept command does not work because the buffer is cleared after
> completion of the first select statement.
> The only solution I can think of is to insert the user's choice into a
dummy
> table and then retrieve it for the subsequent queries.
>
> Is there a better way of doing this?
>
> Many thanks
>
> Markus
>
>
>
Received on Tue Dec 14 1999 - 08:35:44 CST