Re: [Squirrel-sql-users] Parameters

[Jack B. <Jac...@es...>]

Can you please post/send link?  
Searched for ... 
	Download Parameters plugin
	Parameters plugin
... and found nothing relevant

TIA

Jack Brosch
Cell  (704) 622-6995
Email Jac...@Es...
    
  
 Jack Brosch
IT Report Developer
Jac...@es...
T: 
M:704-622-6995

www.essentra.com
       
 Essentra

,  

 
 

-----Original Message-----
From: Gerd Wagner <ger...@t-...> 
Sent: Wednesday, November 14, 2018 4:45 PM
To: Jack Brosch <Jac...@es...>; squ...@li...
Subject: Re: [Squirrel-sql-users] Parameters


External email - treat with caution


Jack,

guess you are asking for the 'SQL Parametrisation' Plugin. I just noticed, that the help entry for the Plugin is missing.

I attached the Plugin's readme.html.

If you like you may file a bug for the missing help entry here:
https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsourceforge.net%2Fp%2Fsquirrel-sql%2Fbugs%2F&amp;data=02%7C01%7CJackBrosch%40essentra.com%7Cb3a5f7fd943c461745a308d64a7a686d%7C1388cd9a1e8849c098beedc64ee66f8e%7C0%7C1%7C636778286929476948&amp;sdata=BwtPJCoNDnevPuqndiX7ZrWwLx6TA5EZxQkcM4ymnSo%3D&amp;reserved=0

Sorry for the inconvenience

Gerd

Am 14.11.18 um 16:14 schrieb Jack Brosch:
> Is there a posting about how to use parameters?
>
> Looking for 3 things:
>
>  1. How to prompt at run time of a SQL query for a value? and  2. How 
> to use that value / variable in a statement?
>  3. How to hardcode a prompt and use in query?
>
> Declare get(promptdate) as date
>
> Select * from table where entrydate = $promptdate
>
> TIA
>
> Jack Brosch
>
> Cell  (704) 622-6995
>
> Email Jac...@Es...
>
>
>
>
>
> *Jack Brosch*
> IT Report Developer
> Jac...@es...
> T:
> M:704-622-6995
>
> https://emea01.safelinks.protection.outlook.com/?url=www.essentra.com&
> amp;data=02%7C01%7CJackBrosch%40essentra.com%7Cb3a5f7fd943c461745a308d
> 64a7a686d%7C1388cd9a1e8849c098beedc64ee66f8e%7C0%7C1%7C636778286929476
> 948&amp;sdata=xkimbuTVaX%2FeuO8M2w2cS1wsOPxmo1T2wi%2FO%2B%2BjNEsQ%3D&a
> mp;reserved=0
>
>
>
>
>
> *Essentra*
>
> ,
>
> This e-mail may contain proprietary information and/or copyright 
> material. This e-mail is intended for the use of the addressee only. 
> Any unauthorised use may be unlawful.
> If you are not the intended recipient, you must not copy, distribute 
> or take any action in reliance on it. If you have received this email 
> in error, please delete it and notify us immediately by return email.
>
> Be aware that Essentra may monitor incoming and outgoing e-mails to 
> ensure compliance with the Essentra IT Usage policy.
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flis
> ts.sourceforge.net%2Flists%2Flistinfo%2Fsquirrel-sql-users&amp;data=02%7C01%7CJackBrosch%40essentra.com%7Cb3a5f7fd943c461745a308d64a7a686d%7C1388cd9a1e8849c098beedc64ee66f8e%7C0%7C1%7C636778286929476948&amp;sdata=UHGnj%2FJ9m7oO%2ByvXH9UYS0kr4SRM9MSek9vLUBtx5IY%3D&amp;reserved=0
>