Urban Terror target's Q&A profile

• SQL Server SQL Server 2005 SELECT MAX function for multiple columns on the same record

  Hello, I am trying to figure out how to use the select maximum command in SQL Server 2005. I have already created a database and I have it populate it with multiple fields and multiple records. I Would like to create a new column or field which contains the maximum value from four of the fields. I have already created a column and I am trying to figure out how to use a command or SQL statement which is entered into the computed equation or formula in the properties for this field/column. Any help you can provide will be greatly appreciated! Thank you, Nathan Thank you for the information. I would like to use this function in the computed column specification formula for t ...Show All

• Visual C++ Help

  Im currently learning how to code c, c++. Im having some issues with visual c++ express. It doesnt seem to debug any of the sample code from my three books on learning c++. Its just standard ansi code and its getting frustrating not being able to get past the first chapter because of constantly having to add libraries and modify code. Its frustrating because the code or libraries added arnt in the book and I like being able to understand each line of code. Oh, if you're using precompiled headers, then stdafx.h needs to be first in the list. Your book won't tell you that, that's a MS compiler thing. Is stdafx.h first on your list What are the errors (for future reference, saying 'there are errors' with ...Show All

• Microsoft ISV Community Center Forums RunTime Error '2001'

  Hi, I am getting " runtime error '2001' you cancelled the previous operation " in my VBA code for MS Access. The database is saved on the server and linked to a table of another database which is also on the server and used by many users. But when i put everything locally then i wont get this error. Pls help! Thanks in advance Cheers Rohit Yes Cindy, you are correct, it is an Access db form. I have done as you have said in my above code towards the bottom but that's where it takes me when debugging the runtime error. Anyways, I stopped using bookmarks in my posted other code below and everything works out fine now using DoCmd's. Thanks for the post! ...Show All

• Visual Basic Listbox selectedItem not working!!

  Hello All, I have a function that fills a listbox with data from sql server 2000 database. Here is the code: (It's in a class) cClass.FillControl(listbox1) In the Class I have this: Public Sub FillControl( ByVal objControl As Object ) Try 'DETERMINE WHAT OBJECT IS BEING PASSED If TypeName(objControl) = "ListBox" Then objControl = CType (objControl, ListBox) ElseIf TypeName(objControl) = "ComboBox" Then objControl = CType (objControl, ComboBox) End If 'CLEAR ITEMS objControl.Items.Clear() 'OPEN THE DATAADAPTER Dim daControl As SqlDataAdapter = New SqlDataAdapter daControl = New SqlDataAdapter(m_SqlQuery, m_Connection) 'FILL THE DATASET WITH DATA ...Show All

• Windows Forms App runs after click-once, fails after setup prog

  Has anyone seen this before : I deployed my VB2005 app to a server using click-once publishing, and the app runs quite nicely on it. I later decided to move to a setup program so that I can give more install options to the user. After creating the setup program, I copied the entire "release" folder to the server, ran the install without error, but now my app won't execute - no fatal errors or any indication of a problem. Basically, double-clicking the app's icon appears to do nothing. If I am missing assemblies, I would expect to see an error of some kind. Any ideas ...Show All

• Visual C++ Problem with deployment (VC++ 2005)

  I have run into a strange problem with deploying applications developed using the VC++ 2005 Express Edition. After building "release" versions on my development machine, I usually copy the release binary over to a laptop and run it there (the laptop has .NET 2.0 and VC++ 2005 Redistributable packages installed, but not the development environment). Both computers are running Windows XP Professional. Now, all of a sudden, I am finding that new applications that I am developing are NOT running on the laptop after I copy the release binaries over. The error message complains about incorrect configuration... And yet, I am still able to copy my earlier applications over to the laptop and run them without any problem. As far as I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can I dispose of instances without explicitly removing all references to them?

  As I understand it, because C# is a managed language, I shouldn't need to dispose of any instances I create, as they are removed by the garbage collection when there are no more references to them. I have all my instances of game objects (enemies, projectiles, etc.) stored in lists (System.Collections.Generic.List), so that more objects can be added on the fly, and they can all be updated and drawn with foreach loops. Is it possible to dispose of one of these instances without explicitly removing the instance from the list For example, from within the class itself I suppose this could be done indirectly, by having a boolean property on each object that flags the object for deletion from the list by another loop, but this seems a bit messy. ...Show All

• Visual Basic AutoCorrect inellisenseoptions

  Hi, I am struggling to find out how to get that brown colored underscore thing that comes in intellisense, To better explain Use this you will get a brown colored underscore at the end if integ Dim a as integ The problem is I have seen that brown underscore appear several other places, not just keyword error It prompted me to rename my variable names, Can anybody tell me what are the otherways you get this options If you are talking about the squiggly line(the color of the line is definable) that would appear under the name integ...it is an error telling you that the type is not defined... but to look at all of the editor color and highlighting options go to tools....options.. ...Show All

• Visual Studio Team System TF53010 NullReferenceException from "TFS Warehouse" source

  Each hour there are two TF53010 errors in Event Log. Thanks in advance for help how to resolve the issue. ------------------- THE FIRST ------------------- TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 10/16/2006 7:32:35 AM Machine: SERVER Application Domain: /LM/W3SVC/3/Root/Warehouse-4-128054503400728648 Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727 Process Details: Process Name: w3wp Process Id: 5140 Thread Id: 884 Account name: DOMAIN\tfsservice Detailed Message: Micros ...Show All

• Visual C++ Identification of object id at run time.

  Hello Gents, I have developing one win32 application.In this application, I was created 5 no of static control at run time. Then i was selected and track any one object from the group of objects using mouse pointer. Now, how can i identify the object id selected by mouse ( OnLButtonDown function ) Thanks and Regards, K.Vishvanathan. Please see articles such as http://www.codeproject.com/dialog/windowfinder.asp . Also note that this question is not within the scope of this forum, as this covers merely C++ language related questions. In the future, please direct UI and MFC questions to the respective newsgroups at http://msdn.microsoft.com/newsgroups . OTP. ...Show All

• SQL Server Calculating Age in a Stored Procedure

  Currently, I'm having an issue with patients under the age of 1 year. I had a patient 9 months old and it calculated 8 weeks. Can anyone see where there may be an error in this This is the section pertaining to the "Patients Age" -- Full SP below this. '308.PatientAge' = CASE WHEN datediff(day, pp.birthdate, @ApptDate) <= 6 THEN cast(datediff(day, pp.birthdate, @ApptDate) as varchar(10)) + ' dys' WHEN datediff(day, pp.birthdate, @ApptDate) <= 112 THEN cast(floor(cast(datediff(day, pp.birthdate, @ApptDate) as decimal) / 7) as varchar(10)) + ' wks' WHEN floor(cast(datediff(day, pp.birthdate, @ApptDate) as decimal) / 365.25) < 2 and day(pp.birthdate) <= day(@ApptDate) THEN cast(datediff(month,pp.birthdate, @ApptDate) ...Show All

• Windows Forms Problem with publishing in VB 2005 Express

  I have seen some other posts where the user gets the message "Application cannot be started. Contact the application vendor" I am having the same problem. I thought this might be connected with the SQL database I was using (I hadn't copied it into the project directory). So, as a test, I created a new form, consisting of one button which displayed a MessageBox in the click event. When I publish this, I get the same error message when I run the .exe file. The exception details are listed below. Also, I am unable to use the File.Encrypt method and get an error that suggests that my file system is not NTFS although it claims that it is NTFS. Could there be some kind of problem with my .net installation Any thoughts ...Show All

• Visual C++ ref friend class?

  I'm using the Unit Testing framework of VS2005 and I'm running into a problem I'm trying to access private member functions of a NONmanaged class with a managed test class like so: class CBob { private: static int PrivateFunctionToTest(); friend class TestCBob; }; [TestClass] ref class TestCBob { [TestMethod] void TestPrivateFunction() { Assert::AreEqual(0, CBob::PrivateFunctionToTest()); } }; Is there any way to do this This post is a duplicate. I answered it here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=537138&SiteID=1 ...Show All

• .NET Development SQLConnection.GetSchema and ForeignKeys

  Hi I am just getting into retrieving schema info from a SQL Sever 2000 using the GetSchema method on the SQLConnection. My problem is that although I can retrieve the fact that a particular table has a foreign Key of a particular name I can not find away to retrieve the name of the foreign  table. Can someone guide me in the right direction. Thanks in anticipation that there is a solution:-) Unfortunately, none of the GetSchema schema collections provided by SqlClient will provide this information. However, I do see that the sys.foreign_keys catalog view will give you both the parent object of the constraint, as well as the referenced object. You can join that with sys.objects to get the name of t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How am I supposed to expose objects as properties?

  Ok, here is the situation. I have a GameComponent that does 2D collision processing called Collisions2D. It requires that an object implement the interfaces IPhysical and ICollidable. Included in these interfaces is the property of type List<Vector> Vertices. This property needs access to other objects in the class that are not created yet since this is not at runtime. I also need to expose the position vector for the object which is held within an object in the class. The designer did not like this at all and had to set up a layer of abstraction so that the properties affect simple types in the class which are then used to update the inner-object's vector. Is this really how we have to do this How are we supposed to expose object ...Show All