Robert Rodgers
|
| Posted: 06/03/2002, 5:05 PM |
|
Hi,
I have a SP that returns result sets for common lookup values. The SP
accepts an Argument and looks something like this.
CREATE PROCEDURE usp_ReturnLookups
@ShowType VarChar(49)
AS
Select LKSysid, Description From Lookup Where xType = @ShowType
I thought under parameter source I could just type in "A" or what ever type
I was looking for, however this does not seem to work. If the value for the
argument does not come from a URL or Form or any of the other choices how
does one enter it in?
Thanks.
--
Robert Rodgers
Robert@SylvanComputing.com
Ph: 509.531.4351
Fax: 503.961.0317
Text Message: mailto:5095314351@mobile.att.net
--
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 06/04/2002, 2:45 AM |
|
If you want to supply an argument that does not come from URL or Form
you could use "Default Value" field for that parameter.
--
Alex
CodeCharge Developer
"Robert Rodgers" <Robert@SylvanComputing.com> wrote in message
news:adh07g$i42$1@news.codecharge.com...
> Hi,
>
> I have a SP that returns result sets for common lookup values. The SP
> accepts an Argument and looks something like this.
>
> CREATE PROCEDURE usp_ReturnLookups
> @ShowType VarChar(49)
> AS
> Select LKSysid, Description From Lookup Where xType = @ShowType
>
>
> I thought under parameter source I could just type in "A" or what ever
type
> I was looking for, however this does not seem to work. If the value for
the
> argument does not come from a URL or Form or any of the other choices how
> does one enter it in?
>
> Thanks.
>
> --
> Robert Rodgers
>Robert@SylvanComputing.com
> Ph: 509.531.4351
> Fax: 503.961.0317
> Text Message: mailto:5095314351@mobile.att.net
> --
>
>
>
|
|
|
|
Robert Rodgers
|
| Posted: 06/04/2002, 5:43 AM |
|
Alexey,
Thanks for the quick response. I will try that
Thanks.
Rob
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:adi270$euc$2@news.codecharge.com...
>
>
> If you want to supply an argument that does not come from URL or Form
> you could use "Default Value" field for that parameter.
>
> --
> Alex
> CodeCharge Developer
>
>
> "Robert Rodgers" <Robert@SylvanComputing.com> wrote in message
>news:adh07g$i42$1@news.codecharge.com...
> > Hi,
> >
> > I have a SP that returns result sets for common lookup values. The SP
> > accepts an Argument and looks something like this.
> >
> > CREATE PROCEDURE usp_ReturnLookups
> > @ShowType VarChar(49)
> > AS
> > Select LKSysid, Description From Lookup Where xType = @ShowType
> >
> >
> > I thought under parameter source I could just type in "A" or what ever
> type
> > I was looking for, however this does not seem to work. If the value for
> the
> > argument does not come from a URL or Form or any of the other choices
how
> > does one enter it in?
> >
> > Thanks.
> >
> > --
> > Robert Rodgers
> >Robert@SylvanComputing.com
> > Ph: 509.531.4351
> > Fax: 503.961.0317
> > Text Message: mailto:5095314351@mobile.att.net
> > --
> >
> >
> >
>
>
|
|
|
|
|
