Home > Archive > MS Access Multiuser > September 2005 > List Stored Proceedure params in VBA ?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author List Stored Proceedure params in VBA ?
kiln

2005-09-09, 9:27 am

Probably this is hopeless, but just in case...does anyone know of a way
to list a stored proceedure's params, using either dao or ado? Code
snippet, add-in, etc?

Thanks
Sylvain Lafontaine

2005-09-09, 11:24 am

http://www.microsoft.com/mind/1199/.../storedproc.asp ; see the
Refresh command in the Figure 3 listing.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"kiln" <kiln@brick-like.com> wrote in message
news:MPG. 1d8b3ca4f3931a569899
5d@msnews.microsoft.com...
> Probably this is hopeless, but just in case...does anyone know of a way
> to list a stored proceedure's params, using either dao or ado? Code
> snippet, add-in, etc?
>
> Thanks



Sylvain Lafontaine

2005-09-09, 11:24 am

Of course, you can also use a stored procedure to take a look directly on
the SQL-Server; see the newsgroup m.p.sqlserver.programming for more info
about that.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"kiln" <kiln@brick-like.com> wrote in message
news:MPG. 1d8b3ca4f3931a569899
5d@msnews.microsoft.com...
> Probably this is hopeless, but just in case...does anyone know of a way
> to list a stored proceedure's params, using either dao or ado? Code
> snippet, add-in, etc?
>
> Thanks



kiln

2005-09-09, 11:24 am

Yes, that does look interesting, thanks!

In article <OxtXq6UtFHA.3896@TK2MSFTNGP15.phx.gbl>, "Sylvain
Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> says...
> http://www.microsoft.com/mind/1199/.../storedproc.asp ; see the
> Refresh command in the Figure 3 listing.
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com