Query parameters

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 Mon Dec 13 1999 - 12:05:03 CST