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:
call msp_BillingBySavingsNo(4211)
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?
Thanks!
-- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
