stretchtack
Last Activity: Feb 18 '11, 04:53 PM
Joined: Feb 18 '10
Location:
-
Hey Frinny... I got past my initial issue. I didn't have 'admin' rights and when I got those rights, then the register/unregister and DLL works as it was supposed to. What was strange is it would tell me that the DLL registered successfully... and it wouldn't let me unregister it. Not sure why that only 'appeared' to work one way and not the other.... -
Hey there,
I think I might be having a similar issue. Meganutter - can you eleborate on the changes you did? I'm in C# WinForms app trying to use a COM DLL that wraps some legacy C++ code. I'm getting the same error when newing-up the object. I've run Dependency Walker on all the need DLL's and everything 'looks' good. So, your find is interesting.
Thanks,
Stretch...Leave a comment:
-
Ok, so you can put a condition in the 'ON' clause... not just the columns to link on? Slick. We actually found another way to get what we need, but I did learn something. Thanks much for your time fellas.Leave a comment:
-
I see other examples like that, but the @TravelType in our case would need to be a field in the table being joined to. @TravelType is just a local variable. But if you're saying it'll work, I'll give it a shot.Leave a comment:
-
Is that putting the condition within the ON clause? So, it will only do the first JOIN if @TravelType = 'A' and only do the second JOIN if @TravelType = 'B'?Leave a comment:
-
Joining to different tables based on a condition
Hey Troops,
I'm not sure if this is allowed, but I'm trying to keep my SP generic and reduce duplicate code. Depending on a condition, I need to JOIN to different tables, which slightly changes the result set. So, I would include conditions later to grab the proper fields based on checking the same condition (@TravelType = 'A').
Here's a sample of what I'm doing, which is currently giving me a syntax error near 'CASE':...
No activity results to display
Leave a comment: