Why would you use GOTOs? There is no good reason to use GOTOs for anything, ever.
- Log in to post comments
Why would you use GOTOs? There is no good reason to use GOTOs for anything, ever.
Thanks David. I was declaring cursor C1 in two locations in the routine (no C10 though). I have now renamed one of them to C2 and Studio has compiled it without error.
Yes I did a search and replace. Cheers!
I think that defeats the point of what he's asking for.
Hello @Ashok Kumar T
No it doesn't work. It might if I waited indefinitely but of course I need to stop it quickly. The process is still running after attempting to terminate the process, routine %sqlcq.APEX.cls17.1
Thanks but I'm using Caché and don't have that option.
I hadn't tried that - it works! Nice one - thanks.
Thanks John. I deleted the routine via Management Portal - problem solved.
I think it would be a good idea to put the name of the EHR in question (TrakCare?) in the post title.
How is using string concatenation for the query parameters a security risk?
Thanks David. It works!
I see - thanks. I guess this depends on where the parameters data is coming from, and if it's user input, whether it's validated exhaustively.
Thanks Jeffrey. I thought I had replied to your comment already; anyway it was indeed Local System account.