Roman_at_work's Q&A profile

• SQL Server Trying to use the results of a case statement in my select list in my WHERE clause?

  I am fairly new with SQL and still learning. I have used a case statemtent for a column in my select list and want to use the results of that statement's field in my WHERE clause but it is not working for me. Here is the code I have so far: SELECT l.loanid, p.investorid, l.duedate, case when pc.duedate >= l.duedate then pc.duedate end as RateDueDate , pc.interestrate FROM loan l inner join participation p on p.loanid = l.loanid inner join paymentchange pc on pc.loanid = l.loanid where p.investorid = '12345' and RateDueDate is not null order by l.loanid, pc.duedate I want to put the results of this case statment in my where clause like highlighted above but it is not working because RateDueDate is not an actual column in the table. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Buttons not waiting for release

  I'm making a Tetris clone in XNA GSE and I'm having trouble with the controls. I've created the pieces and got them to animate using the Animation tutorial in the docs, but when I hook the animation to button pushes, they spin wildly until the button is released. What I want them to do is turn once when the button is pushed and wait until the button is released and pushed again to turn again. I know I'm missing something but I can't think what it is. Here's my UpdateGamePad() method which is called from Game.Update(): private void UpdateGamePad() { gamePad = GamePad.GetState(PlayerIndex.One); if (gamePad.Buttons.A == ButtonState.Pressed) { CurrentFrame++; if (CurrentFrame > 3) CurrentFrame -= 4; ...Show All

• Visual Studio Tools for Office Update

  hi every one, I'm trying to run the benefits registeration example on my machine but I keep getting this error when I try to open the *.doc from IE The customization does not have the required permissions to execute. I tried  to republish the BenefitForm incase it was using Absolute Paths. but that did not change anything. I tried uploading a new *.doc but also got the same error Using .Net Framework 2 configuration tool   , I gave Full trust to the path \BenifitsRegisteration\CS\BenefitsPortal\Forms\* under user,machine and enterprise but still got the error. From the file system, Double clicking on BenefitForm.Doc at \BenifitsRegisteration\CS\BenefitsPortal\Forms works fine but double clicking on Fit ...Show All

• Visual C++ Delete a certain tree node

  hi, now i facing a problem which i do not know how to solve it...:( My binary search tree structures stores a double number in every node, whereby a higher number is appended as right child and a less or equal number is appended as a left child. Now i want to write a function which deletes the node with the highest number in the tree. I started the function as follows: [code] template <class Item> void bst_remove_max(binary_tree_node<Item>*& root_ptr, Item& removed) // Precondition: root_ptr is a root pointer of a non-empty binary // search tree. // Postcondition: The largest item in the binary search tree has been // removed, and root_ptr now points to the root of the new (smaller) // binary search tree. Th ...Show All

• SQL Server Using a server alias in connection mgr

  Hi, In DTS 2000 when you created a connection you could use a server alias (as created in the network client utility) as the servername. When I try to use a server alias in connection mgr(I am using Native Client) it fails to connect with the standard error: "Test connection failed because of an error in initializing provider. Login timeout expired. etc etc... Has anyone had success using a server alias (Yes i set up the alias using sql configuration mgr) The problem I am trying to solve is I have dev/test/production environments that I want to move this package to and I don't want to have to change any server name properties within the package when moving to the different environments. Thanks ...Show All

• SQL Server VS2005 can't see the database in SQL Server !!?

  hi I created 2 databases in "SQL Server 2005 Trial" Software, and when I try to add one of them to VS2005 windows form project the vs can see the SQL Server, but it can't see any of my databases!! pls help, What version of SQL Server did you install and how did you create the databases VS can install another version of sql server called express. How are you expecting to see the databases in VS2005 are you using code or is it in some part of the IDE. It could be you have created the database in the instance of SQL server you installed but VS is looking for the database in the one it installed. ...Show All

• Visual C++ Problem in linking the VC++ library with Borland C++

  Hi, I am using the "Borland C++ Builder6" as the development platform. Recently, I got a (static) library from my partner which was built using VC++ version 6. I had problem to link the (static) library with my source. I got the error message that a function call is missing but it should be included in the (static) library from my partner. Anyone has any idea what I should do in order to link the (static) library Thanks for your help in advance.   violetsnowman wrote:  I am using the "Borland C++ Builder6" as the development platform.  Recently, I got a (static) library from my partner which was built using VC++ version 6.   If it isn't a COM dll ...Show All

• Software Development for Windows Vista Can't download .NET Framework 3.0 June CTP SDK

  When I try to download it, it reports : The download you requested is unavailable. If you continue to see this message when trying to access this download, go to the "Search for a Download" area on the Download Center home page. This has been a particularly difficult release to publish live, and it has caused us a lot of late nights and internal conversations. Bottom line is that it took a long time for all bits to be fully live, and now they are. We on the SDK team apologize for your frustration on this, and we're using this as a lesson to help drive how we manage future releases. If you continue to have problems, please email me with a copy of your log. ...Show All

• SQL Server Looping through non system database objects using SMO and VB.net

  Hi, We are using SMO to compare objects in our SQL Server database with another instance of sql server. I'm able to loop thourgh the stored procedures with no problem and retreave the names of them however it loops through all of the SPs even the system ones. This makes the loop take a while since it has to cycle through all of the system stored procedures. Is there a way to loop through only the dbo sps I'm using VB.net For Each sp In theserver.Databases.Item(DBName).StoredProcedures x = sp.ToString If sp.IsSystemObject = False Then 'MsgBox(x) End If Next Thanks Hi, see this here: http://www.sqlteam.com/item.asp ItemID=23185 The following can be used ...Show All

• Software Development for Windows Vista Rule editor problem

  My scenario: I have a custom workflow designer (I use the latest sample of Workflow Designer .) I create a custom activity with a bool type property - "IsChecked". I put this activity into a sequental workflow in the designer. Next I add "if/else" activity and triy to set up the "Rule condition" property of each branch. I want my "if/else" activity depends on the property "IsChecked" of the custom activity. When I write the condition in the "Rule Condition Editor" everything looks fine and I can find my custom activity with intellisense. But I can't see my property "IsChecked" with intellisense and when I write it manually (custom activity name is "boolActivi ...Show All

• .NET Development Access query to transpose table data

  Hello, I have the following table structure in my database and would like to create a query or table that displays a single record for each country with the three different RatingsType1 across the top as column headings with the respective rating filled in. Something like this: Country Rating1 Rating2 Rating3 US AAA CCC Baa1 where Rating1, Rating2, Rating3 are one of the three types of ratings from the tblRatingsType1 table. Here's the table structure: tblCountry CountryID (PK autonum) CountryName tblCountryRating CountryRatingID (PK autonum) RatingType1ID (FK to tblRatingType1) Rating RatingDate tblRatingType1 RatingType1ID (PK au ...Show All

• Visual Studio Express Editions migration of the __try_cast operator

  Hello, I am migrating code from the old Managed Syntax to the new C++/CLI syntax. To do this transformation I followed the hints explained in several articles of the MSDN. But what I didn't find there is how to convert the __try_cast operator when the type being casted is unmanaged. Does I have to use dynamic_cast and append an assertion Or there is a special operator like safe_cast but for unmanaged types Thank you in advance. Interesting. __try_cast was supposed to work with managed types, I see no reference anywhere about it being used with unmnaged types. Testing (in VC++ 2005) shows that __try_cast with used with an unmanaged type generates a dynamic_cast so the rules seem to be: use s ...Show All

• Visual Studio Express Editions Can I link to more than one AboutBox in a Form?

  I have several AboutBoxes working, but one simply will not. While I was trying to think this through I came up with a couple of other questions. 1) Can I create a drop down button in VS Pro that would allow me to click the drop down and have several options that I could click on to open the various AboutBoxes I need 3 AboutBoxes for various reasons. 2) Am I able to have 2 buttons linking to 2 separate AboutBoxes in a single Form I ask because the first AboutBox button works fine, but the second won't even autocomplete or recognize the other AboutBox. Any information would be greatly appreciated. Thanks. Yes. If it shows in the Solution Explorer, you should be good to go. I added 3 About Boxes. I put ...Show All

• Software Development for Windows Vista Parenthesis in Rule Condition Editor

  It seems as if the Rule Condition Editor is inconsistent in handling parenthesis in conditions. If you add parenthesis to your condition in order to clarify the precedence of a compound condition, sometimes they are persisted, other times the editor removes them as you press OK. The behavior appears to be that if the parenthesis are placed where according to the default order of precedence (e.g. AND takes precedence over OR), then the editor removes them. If you use parenthesis to specify a non-standard precedence, then it leaves them. I would prefer that the rule condition editor leave things the way I entered them, even if they duplicate default behavior. Some of us like to document default behavior by explicitly entering things like pa ...Show All

• Visual Studio Team System Plan iterarion

  hi, the gantt In the project structure document is only for the actual iteration for estimate the durarion of all the project, i need to plan each iteration is this corrrect How i now the duration of the prject tks Hi Fabian, Good question. There are two types of projects: date-driven and functionality driven. If your project is date driven, you probably have a date in mind for its delivery (such as a trade show) and want to scope the functionality appropriately. The iterations are fixed periods of tiem (between two weeks and two months). You can divide the project into several iterations using a calendar or project. If the project is functionality driven and you want a date, perform a few iterations and get your ...Show All