my problem was lack of reading permissions from the SP server to wherever i could write a piece of code to include. I've solved that now, but my main question remains because i could still use calling a SP from within another SP. It's a bit of a long read, but i appreciate your patience: I have this SP web app where a bunch of Quality Agents have to check some 4k bank accounts to see if the bank has all the required documentation from the account holders of each account. So in the first screen a Quality Agent is presented with a random list of 20 bank accounts from the 4k+ that have to be checked and he clicks on one, which takes him to the second screen where there’s a list of documents and he has to say if the bank is in possession of that document or not for the account he just chose. There are 3 radio buttons after each document – yes, no, not applicable and he must choose one for each document that’s required. (for example: account holder’s proof of address – he chooses yes if the bank has that document, no if the bank doesn’t have that document and NA if it’s not applicable for whatever reason) My problem is this – what if two agents might choose the same account at the same time? The way I took care of it was: when agent A chooses account 123, I’ll insert that account in a temporary table so that if another agent B chooses that same account, I’ll check on the temporary table if the account 123 is there already and if it is, I’ll tell agent B, sorry, that’s being checked already, go back and choose another one. But then I get a complication - what if, for whatever reason, agent A doesn’t carry out the check until the end? His browser might crash, he might click “back” on the browser, he might close the browser, etc before actually submitting his check. In this case I want to go to the temporary table and delete account 123 so that another agent might pick it and check it, otherwise nobody is ever going to be able to pick up account 123. The way I solved this was with the onbeforeunload HTML method. But because this is HTML, how do I say to onbeforeunload something like delete * from temporary_table where account = 123? The way I’m doing it is - on the function called by onbeforeunload I’m opening another window which is also a web SP put "window.onbeforeunload = function(e) { "; put "window.open( '&sp_that_deletes_from_temp_table');"; put "};"; which actually opens a window, does what it has to do (delete * from temporary_table where account = 123) and then closes itself. But this is very ugly! The user is in the middle of the documents check, decides to not complete it, closes the browser window and suddenly another window opens and closes almost immediately after!!?? Very messy. What I wanted here was to call an SP that didn’t open any windows (I tried but then got a new window anyway with the error that the SP didn’t have any output, which was precisely what I wanted, but SAS complained about it) and just did what it had to do (delete * from temporary_table where account = 123) quietly. In summary: what I want is a way to call a SP within another SP to do the cleanup, or ultimately, solving my concurrency problem. Thanks for your help! Alex
... View more