Working with TransactionNotification stored procedure
Following some threads I've tried to work out a test with the TransactionNotification stored procedure.
However I do not seem to get it to work as I hoped.
- If I add a small test query in the stored procedure and make some changes in SBO, the query is executed perfectly.
- My target query (rather large) can be ran manually and works perfectly.
- If I add my target query to the stored procedure, nothing happens.
- If I addres the same stored procedure through Access it does execute perfeclty (and runs the target query)
What am I missing here?
Thanks for your help
Ben Marty replied
I have found that errors encountered during TransactionNotification are ignored no matter how severe. Try "evolving" from the very simple query that works into your final query slowly to see where the problem begins. Or maybe you can add debug code to your query that inserts rows into a debug table or something so you can see how far your query got before failing.