SQL Procedures

Does any body have any VB (inside of Access) examples of creating SQL
produces inside a access form via vb and then executing those procedures and
returning the results to the screen?

Thank you in advance,
Mike
DFS [ Do, 13 September 2007 19:43 ] [ ID #1819383 ]

Re: SQL Procedures

"Michael Kintner" <nospam [at] nospam.com> wrote in message
news:13eitmadcg0p839 [at] corp.supernews.com...
> Does any body have any VB (inside of Access) examples of creating SQL
> produces inside a access form via vb and then executing those procedures
> and returning the results to the screen?
>
> Thank you in advance,
> Mike
>

Why would you create a procedure from a form? How about using a
parameterised procedure instead?

Lookup the CREATE PROCEDURE statement in SQL Server Books Online.

--
David Portas
David Portas [ Do, 13 September 2007 19:45 ] [ ID #1819384 ]
Datenbanken » comp.databases.ms-sqlserver » SQL Procedures

Vorheriges Thema: SQL Slow from MSDE 2000 to SQL Express
Nächstes Thema: SQL 7 & Server 2003