Navicat Frontend: Possible to accept keyboard input to set user variable?

Hi All,

We use the Navicat GUI tool for end-user report generation, data
exports, etc, from MySQL databases. In this capacity, it works
admirably. Unfortunately, one downside is the lack of detailed
documentation.

We would like to be able to prompt the user to enter a value and have
that value stored in a SQL user variable. Given the existance of such
a function (call it 'PROMPT_USER'), we'd like to do something like:

@var = PROMPT_USER('Enter a customer name:');
select * from customer where name = @var;

Does anyone know if Navicat provides such functionality?

Thanks!

-Dave H.

Re: Navicat Frontend: Possible to accept keyboard input to set user variable?

select * from customer where name = [$var]

>oes anyone know if Navicat provides such functionality?

Re: Navicat Frontend: Possible to accept keyboard input to set user variable?

>>@var = PROMPT_USER('Enter a customer name:');
>>select * from customer where name = @var;
>>Does anyone know if Navicat provides such functionality?

>select * from customer where name = [$var]

Extremely cool, thanks!