I have MySQL-5 running and have made a simple stored procedure which
accepts a varaible and selects from a table based on that variable:
create procedure msp_BillingBySavingsNo(input_SavingsNo int)
select * from Billing where SavingsNo=input_SavingsNo
If I enter the mysql client and type:
I get the expected result; a few records that match the query.
However if I create a pass-through query in MS Access, point it at
MySQL, and type the same exact same text as above, I get:
'SELECT in a stored procedure must have INTO (# 1282)'
Anyone know what's wrong?
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989