Does access support "CREATE PROCEDURE"?

  • Thread starter Thread starter John
  • Start date Start date
J

John

I seem to get an error everything I create a query that includes CREATE PROCEDURE.

I'm using the JET4 OLE connection to my C# application.

Thanks,
John
 
On 3 Jun 2004 07:57:46 -0700, (e-mail address removed) (John) wrote:

¤ I seem to get an error everything I create a query that includes CREATE PROCEDURE.
¤
¤ I'm using the JET4 OLE connection to my C# application.
¤

Here is a simple example:

CREATE PROCEDURE TestProc AS SELECT * from Table1


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
This is a TRSACT-SQL statement supported by SQL Server. In Access you can
CreateQueryDef. It does not have stored procedures.

--

Ori Millo (MCSD)
Solutions Consultant
SEA Software Ever After
http://www.s-e-a.com.au
 
You are not correct. Paul has provided a valid example. In addition, Access Stored Procedures can also include parameters
(parameterized queries). The only problem with using CREATE PROCEDURE (if you want to call it a problem) in Access is that the
procedures are not visible when the mdb is viewed from within Access.
 
Back
Top