[dba-SQLServer] MySQL not MS SQL question

You can "Bind" the recordset from a stored procedure by putting that procedure in a 
pass-trhough query and "binding" to the query 

Note the quotes around "bind".  Recordset returned by  SPs are snapshots, there is no 
persistent connection.   So you only view/filter/sort the records.  You can't create/edit/delete 
any.

-- 
Stuart


On 25 Feb 2013 at 12:10, Arthur Fuller wrote:

> 
> What I want to do next is bind a form to the result set returned by a
> Stored Procedure in the MySQL back end.
> 
> None of the "obvious" approaches works. So now I'm thinking that what I
> have to do is:
> 
> 1. create a command object within VBA code. (Perhaps create a new
> connection object, too; not sure about that yet.)
> 2. Populate its attributes with procedure name, indicate that it is a SP.
> 3. Add parameter objects to suit.
> 4. Execute the command, assigning the result set to a recordset.
> 5. Set the form's RecordSet to the recordset just created.
> 6. In the form close event, close my recordset and set it to nothing.
> 
> Does that sound about right? Have I overlooked anything?
> 
> One thing that I do know in advance is that I'm puzzled about the parameter
> objects. With some exploration I hope to clear up my haze.
> 
> Does anyone have an example of code that does this, ideally to a non-MS SQL
> database?
> 
> TIA,
> Arthur
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>