I saw a previous entry from Minty about how to do this. but so far haven't been about to get this to work. The plan was to use the dynamic stuff after this worked.
I have Store Procedure in MySQL like this
Code:
CREATE DEFINER=`root`@`%` PROCEDURE `ReNumberInventoryReceiptLi`(
IN documentID varchar(25))
BEGIN
set @x = 0;
set @t1 = concat("update tblInventoryReceiptLi set li = @x:=@x+1 where ID = '",DocumentID,"' order by li");
Prepare stmt from @t1;
execute stmt;
deallocate prepare stmt;
END
I am able to call it in MySQL Workbench with
Code:
call cyclodata.ReNumberInventoryReceiptLi("TEST");
but in access pass through
Code:
EXEC cyclodata.ReNumberInventoryReceiptLi("TEST");
gives me an error. telling me to check my MySQL manual.
did I miss something?