|
From: Gerd W. <ger...@t-...> - 2018-11-14 21:45:02
|
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://sourceforge.net/p/squirrel-sql/bugs/ 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 > > www.essentra.com > > > > > > *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://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
