Re: VB,ODBC & Stored Procedures
From: George Credland <G.Credland_at_shef.ac.uk>
Date: 1995/07/28
Message-ID: <3vb0nr$sml_at_hippo.shef.ac.uk>#1/1
Date: 1995/07/28
Message-ID: <3vb0nr$sml_at_hippo.shef.ac.uk>#1/1
Ronan Miles <milesr_at_bhnov1.agw.bt.co.uk> wrote:
>The correct SQL would be "BEGIN Create_Jane_doe;END".
>
>However, all this does is execute the procedure, ODBC does not have the
>ability (as far as I have ever found) to read any returned results from
>the procedure (or function).
>
A crude and inflexible way round this, is to insert the 'results' into a temporary table with a runtime unique id.
Then select the results back as normal using this id...
-- George Credland Management and Administrative Computing Services The University of Sheffield email: g.credland_at_sheffield.ac.ukReceived on Fri Jul 28 1995 - 00:00:00 CEST