Re: MySQL Stored Procedure Help needed
Hi -
Finally figured this out. It (of course) was not a problem with the stored procedure - it was doing exactly what it was told, which was to delete any records that matched the number in the InvoiceBatchDetail table. Well - there were some items created by an incorrect join in another SP that were not listed in the InvoiceBatchDetail table. As usual - no one's fault but my own.
And - on the IsError: I realized I had commented out the code that declared the handler during debugging & then when I posted it here, I removed all commented code to make it cleaner. The handler is back in & working.
Garret
Time for an oldie but goodie:
"If it ain't broke, you're not trying." - Red Green