0to60's Q&A profile

• SQL Server Why is this query breaking my server?

  This is a strange one. On my development machine, this query executes instantly. On our production Windows Server 2003 box, this query never finishes and one has to wait for it to timeout. The table in particular only has about 10 rows in it right now: UPDATE MagContent SET ViewsPartial = ViewsPartial + 1 WHERE ID = 10 OR ID = 9 OR ID = 8 OR ID = 7 OR ID = 6 ViewsPartial is of type int, and ID is the primary key and is of type int too. If I use SQL Profiler, I can see the query being passed to SQL Server. If I use Task Manager I do not see any CPU usage going to SQL Server, and System Idle Process stays at about 99%. If I use SQL Management Studio and put the above query in myself, it too takes forever to execute. If I attempt to que ...Show All

• Visual Studio Accessing User Macros from a vcproj

  How can I access the User Macros from within the OnBuildProjConfigBegin event What I want to do is generate some .cpp source files before the project starts building. I wanted to use a macro to pass information to the add-in so that it knows what to generate. I tried to use VCProject.LoadProject but I was getting a COM error. Maybe because the project is already loaded This thread helped me with my problem. ...Show All

• Microsoft ISV Community Center Forums about macro....

  hi all. if any1 can help me... i hav simple form having 1 command button...on click event of it i hac call 1 function.... the code is as shown below.... *****code******* Function Macro2() On Error GoTo Macro2_Err ' all data DoCmd.TransferSpreadsheet acImport, 8, "tableimport", "D:\hetal\vb\tempxl.xls", True, "" Macro2_Exit: Exit Function Macro2_Err: MsgBox Error$ Resume Macro2_Exit End Function Private Sub cmd1_Click() Call Macro2 End Sub ******* after running and clickin on button.. i m getting error like...." Object required".... so... how to add macro object on form... error is for line... DoCmd.tran... line of above code... plz help me... ...Show All

• Visual C++ Tips for Displaying INT Arrays in Views or Forms?

  I've been trying to figure out a simple way to display an INT Array in one of the 'Views'. "Painting" in a Cview seems a little tedious (i.e. not as easy as using iostream), CEditView and CRichEditView seem to be geared towards CStrings. FormViews don't seem to be able to simply attach an Array directly to something like a List Box. Any suggestions I am using Visual C++ 6.0 and working on a simple SDI application. Thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. HLSL & Alpha Blending help plz!

  Hey all - I'm pretty new to XNA so I need some help with my Blending and HLSL stuff... Here's the setup: I'm trying to make a 2D game where the graphics are 2D but they're textures that have been placed onto polygons. So basically I'm using the 3D part of XNA to make the 2D game (because I want to have faster speed, rotation, scaling, better manipulation of the pixel colors, etc; making it this way because I also want a deeper than 2D playfield even though I'm using 2D graphics - and its actually working out well apart from the blending problems.) and I want to know how I can get the blending mode to be 'just right'. Basically the effect I'm going for is for Polygon textures to be opaque where there is color - and transparent where there i ...Show All

• Visual Studio Team System TFS sp1/url change breaks Sharepoint documents

  Hi NG, We've upgraded our workgroup edition of TFS to service pack 1. As part of this process we also wanted to take advantage of the new functionality available for accessing TFS remotely and went through the TFS transfer process so that we could access TFS using a remotely accessable url. However since we ran the update we can no longer access sharepoint documents. When we click on a document it spits out a 2.13Mb file that appears to have some code and SQL calls within it instead of the file itself. Also, if we attempt to access the sharepoint site using http://ourtfsserver.com/oursite/ it spits out the same 2.13Mb file. The url http://ourtfsserver.com/oursite/default.aspx works fine though. Does anyone have any ideas how we can fix thi ...Show All

• Smart Device Development Where to Post Non-Visual Studio 2005 questions regarding device programming?

    This forum is primarily monitored by people from the Visual Studio for Devices Team and some members of the Windows Mobile Team. Some of the Questions are more relevant to core OS , Compilers , Active Sync or General Development questions not relating to VS 2005. To ensure your questions gets looked at by the right set of the people, I determined the newsgroups the Other Product Teams monitor frequently and that would increase your chance for chance for getting a question answered more quickly. Native Compilers microsoft.public.windowsce.embedded.vc General Device Programming Questions microsoft.public.windowsce.embedded and microsoft.public.windowsce.app.development Active Sync microsoft.public.pocketpc ...Show All

• Visual Basic How disable Named Pipes in SQL Server 2000 from VB.NET

  Hello, I have a big problem with SQL Server 2000 and Visual Basic .Net. I wont disable named Pipes from code write in Visual Basic (.Net). How make this This problem is very important for me. Help me! Please!!! ...Show All

• .NET Development framework 2 install problem

  i downloaded the framework 2.0 to correctly run a program i downloaded. but when i run it it extracts the setup and run it normally but after that it does nothing. when i check the task administrator there is a process called install.exe running and using 50% of my procesor. i checked the temporary files and i found the files that where extracted and it was called install like the process, so i assume it does run the program but it is doing nothing i left my computer on for aboout 5 hours and the process would just use 50% of my processor and do nothing. so i cant install this and because of that i cant use this program i downloaded and i cant install visual studio 2005 either. actually, visual studio also tries to install the framework 2 ...Show All

• Smart Device Development Freezing when a control data is set

  When I set data in a control (setting the text in a label or image in a pictureBox) the form freezes. I stepped throught the code, and the exact line where a controls data is being set, it enters but never returns. I am using CF 1.0. Has anyone seen anything like this I actually ended up using delegates as function pointers. When I set the pointer when the form was instantiated and then called it from the method that was being called by the external thread it seemed to work :P ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Question about 'EffectParameter' class

  Given that the EffectParameter class is sealed I need to ask: any chance for future versions to take advantage of generics for methods like SetValue and GetValue I 'm not meaning to create a new 'EffectParameter<T>' class (what'd make it difficult for the 'EffectParameterCollection' class), but something like: GetValue<T>() or GetValue<T>(T dummy) -the latter to avoid the use of the static <T> when calling the method, instead of GetValueVector3() and so on (ditto for the methods that return an array). SetValue<T>(T value) , instead of overloading SetValue(...). That way it could be easier -for us- to implement a sort of "fx parameter mapping" technique as well as an 'EffectParameterHan ...Show All

• Visual Studio VS 2003 and VS 2005

  Hi, I have Visual Studio 2003 install on my laptop and I'm wondering if it is perfectly ok if I can install Visual Studio 2005 too, can both IDEs live with each other peacefully what are the potential problems I might have. Thanks in advance! It works fine, especially if you install VS2005 after VS2003 as in your case. The only potential problems will be when double clicking files like C/CPP/CS etc that will now be opened by VS2005 instead of VS2003. ...Show All

• Visual C# Creating Hotkey

  Could you show me a sample code of creating a hotkey and then watching it. I am tried to do this but I couldn't do. you can use RegisterHotKey and UnregisterHotKey API function here is some free examples may help you http://www.codeproject.com/cs/miscctrl/systemhotkey.asp http://www.pinvoke.net/default.aspx/user32/RegisterHotKey.html http://www.codeproject.com/cs/miscctrl/ashsimplehotkeys.asp http://www.codekeep.net/snippets/ea68475b-c33e-4a71-8008-90f63d7e918d.aspx ...Show All

• Visual C++ question about dlls

  hey all i am using visual studio express and i was wondering if it was possible to creat dll files. i am putting a hook procedure in it. if it is please tell me thanx. I am suggesting that you first create a windows application, and then manually make the changes to the project settings to convert it to a dll project. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Math 101: Lerp() vs SmoothStep() ?

  For all practicle purposes, what's the difference between VectorN.Lerp() and VectorN.SmoothStep() Is one more efficient (speedy) than the other Will I get radically different results at given percentages Under what circumstances would you want to use one rather than the other Yes, the SDK docs tells me one uses linear interpolation and the other uses a cubic equation, but let's assume that doesn't mean anything to me :) (I believe I understand linear interpolation from the docs... looks like what I probably would've come up with on my own. Hoever, the docs really don't shed any light on SmoothStep.) Matt Lerp is the simple method that interpolates along a straight line, according to the distance ...Show All