Re: [Squirrel-sql-users] In Squirrel is there any way to write asql query to prompt you for a parameter?

[Kreig, V. <Viv...@St...>]

HI Rob,

Thanks very much.  Can you tell me where I can specifically find this
sqlparam plugin and how to install?  Sorry,   I have looked around and
don't see it.

I have Squirrel version 2.5 and I looked at the plug in summary...it
doesn't look like I have it.

 

I tried the following and get an error ( there is a colon before the
parameter label):

            SELECT * FROM tablename

             WHERE columnA =:<test>

 

Thanks very much for your help,

Vivian

 

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
Robert Manning
Sent: Tuesday, September 02, 2008 6:04 PM
To: Kreig, Vivian
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] In Squirrel is there any way to write
asql query to prompt you for a parameter?

 

If you install the sqlparam plugin, then you can specify parameters as 

:<label>

And, when you execute the query you will be prompted with a dialog
containing the label to enter a value.
You can specify multiple parameters with different labels in the same
query.  To install the plugin (if you 
have not already), you can get the installer that you used originally,
and install on top of your existing 
installation - must be the same version.  You can choose the optional
plugin "sql parameterisation"
 to install.

Rob

On Tue, Sep 2, 2008 at 4:04 PM, Kreig, Vivian <Viv...@st...>
wrote:

Hello,

 

In Squirrel is there any way to write a sql query so it will prompt you
to enter a parameter?

I am connecting to a DB2 UDB database.

 

p.s. Some of my associates use AQT and they are able to enter a question
mark (?) as a parameter.  Before the query is run they get an "Enter
Query Parameters" dialog box which asks for the parameter data types.

 

Thank you in advance,

Vivian

 

 


------------------------------------------------------------------------
-
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users