Re: External Data from Stored Procedure with parameters
- From: "Jamie Collins" <jamiecollins@xxxxxxxxxx>
- Date: 12 Apr 2005 08:23:07 -0700
Ben Rum wrote:
> when the user selects "Refresh Data!" I
> would like the user to be prompted to enter the values as per the
stored
> procedure parameters..
>
> e.g. exec sp_MySpName @StartDate = [prompt user], @EndDate = [prompt
user]
>
> Is this possible?
It is not possible to get MSQuery to automatically prompt for the
parameters.
To be able to use MSQuery parameters, the SQL must be a simple SELECT
written in MSQuery's own SQL dialect, rather than that odbc syntax or
the dialect of the database server. Using odbc's CALL syntax, ANSI's
EXECUTE syntax or anything proprietary will result in the 'cannot
display graphically' (whatever that means) message, after which
built-in support for parameters is lost.
You can, of course, write VBA to dynamically change the querytable's
SQL
text, then everything will be up for grabs, including throwing up
userforms with calendar controls on them, but you will have to write it
yourself <g>.
Jamie.
--
.
- References:
- External Data from Stored Procedure with parameters
- From: Ben Rum
- External Data from Stored Procedure with parameters
- Prev by Date: Re: Automatic Downloading of files (PDF or HTML) using Excel
- Next by Date: RE: Deleting certain string within the string
- Previous by thread: Re: External Data from Stored Procedure with parameters
- Next by thread: EXCEL AND VBA
- Index(es):
Relevant Pages
|
