Having trouble filling a DataGrid (VB 6) using a stored procedure

[Javier Rodriguez Paiva]

Hi, I need a stored procedure that returns a result set so I can fill a DataGrid in VB 6. I'm new on mySQL and I'm having big problems making this work. What I did at first was to stick to the basic structure of the procedure:


BEGIN
SELECT * FROM table;
END;

When I entered it using the mySQL client, it worked fine. However, when i try to use it in my VB application and get that result into a ADODB.Recordset object (so I can fill the DataGrid control), I get an error message : "SELECT in an stored procedure must have INTO". Does anyone know what's going wrong? I'd really like to use stored procedures instead of just sending the SELECT from the client for performance reasons, anyone has any ideas? I'd really apreciate them. Thank you