multiple selects?

  • Thread starter Thread starter Helixpoint
  • Start date Start date
H

Helixpoint

Is it possible to do multiple select statements in an access stored
proc? If so, How?
 
Helixpoint said:
Is it possible to do multiple select statements in an access stored
proc? If so, How?
Click to expand...


In an MDB/ACCDB, as opposed to an ADP? Not directly, no. The Jet database
engine supports only a single SELECT statement in a QueryDef, which is the
closest equivalent to a stored procedure. And only one recordset can be
returned by a QueryDef.

What I have done upon occasion is use a memo field in a table to hold a
series of SQL statements, with code to retrieve, parse, and execute them.
However, in that case the "procedure" was a series of action queries, with
at most one SELECT statement to return the final results.
 
Back
Top