echavez's Q&A profile

• SQL Server Correlated subquery column referencing outer date range

  Any ideas how can I pass date range values from the where clause of an outer query to the inner correlated subquery ... without using a stored procedure because I am using Report Builder Using the simplified sql below I need the average freight charge between the dates for all of the ShipCountry's orders. (I have hard coded the dates for demo purposes only as it is these that I need referenced from the outer query's where clause.) select OrderDate, ShipCountry, ShipCity, Freight, /* how do I get to the outer query's date range */ (SELECT AVG(Freight) FROM Orders WHERE ShipCountry = O.ShipCountry AND OrderDate between '01-jan-1997' and '01-jan-2000') AS CountryAverageFreight from Northwin ...Show All

• Visual Basic cursor

  How do i set the position of the bllinking cursor in a text box Mitch Public Class Form1 Private Sub Button1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click ' Select caret position 6 ' If it exists TextBox1.SelectionStart = 6 TextBox1.Select() End Sub End Class ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3DXMatrixLookAtLH & D3DXMatrixLookAtRH

  D3DXMatrixLookAtLH and D3DXMatrixLookAtRH How we can differentiate these functions Please help me PRE.clsCode {font-size:110%;} PRE.clsSyntax {font-size:100%;} TD DIV.clsBeta {display:none;} PRE.clsCode {font-size:110%;} PRE.clsSyntax {font-size:100%;} TD DIV.clsBeta {display:none;} Well, one way to differentiate those functions is to recognize that one creates a left handed coordinate system, while the other creates a right handed coordinate system. If you have a peek in the MSDNL, I believe you'll find those matrices given. Personally, I like right handed systems, even though I'm left handed :-) Hope that helps. ...Show All

• Software Development for Windows Vista Regd SubType for 48-bit RGB

  Hi All I'm now working with Source Filters.Direct Show Filters support bitcounts upto 32.There is no support in direct show to handle Images of bitcount greater than 32.I need to handle TIFF Images of BitCount 48. I did the code to output the stream of Image data to Transform Filter/Renderer Filter.But it doesn't work b'cos there is no subtype to handle 48-bit RGB. Can anybody tell me how to make a Transform/Renderer filter to handle 48-bit RGB OR Any other possible ways to do it. With Regards, Jeno The general way to create new media types for existing FourCC's or D3DFORMATs is to replace the first 32 bits of the media base GUID with the FourCC or the D3DFORMAT. The media type base GUID is { xxxxxxxx- ...Show All

• Windows Forms Searching Data in a ListView -String^

  How do you find a String^ in a listview I tried this (amongst other things): array<ListViewItem^,1>^ itemToChange = listView1->Items->Find(HW->HeadWord,1); //HW->HeadWord is a String^ Item to change is always Length == 0 even when I know that the String is already in the listView. I have also tried IndexOfKey(HW->HeadWord), which always returns -1. Still no luck with this. The closest I could get was listView1->FindItemWithText, but that finds the first entry that begins with the search key. I have considered a linear search, but how can I know how many items are in the list There is no .Length parameter for listview items. ...Show All

• Windows Forms WebBrowser

  I use a webbrowser to load a web page, then i click a <A> tag within a <td>, after that the new page is loaded, i want to get back the new document as below, but the document i got is the first one, not the new one. Dim cols As HtmlWindowCollection Dim cells As HtmlElementCollection cols = WebBrowser1.Document.Window.Frames() cells = cols(1).Document.GetElementsByTagName("td") cells(2).Children.Item(0).InvokeMember("click") While (WebBrowser1.ReadyState = WebBrowserReadyState.Loading Or WebBrowser1.IsBusy Or WebBrowser1.ReadyState <> WebBrowserReadyState.Complete) Application.DoEvents() End While Dim cols_new As HtmlWindowCollection Dim cells_new As HtmlElementCollectio ...Show All

• SQL Server Internet Explorer 7 Release Candidate 1

  After downloading and installing this update I find that java script doesn't work (e.g. I cannot now access news videos). I have checked in Tools and find that Scripting is enabled. Can anyone assist me please as I rely on the Internet for news, not having a TV This forum is for SQL Server Reporting Services, and in general the MSDN forums target developer related questions, but you could try the Internet Explorer forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=923&SiteID=1 You may also want to enable "Display a notification about every script error" on the Advanced tab of Tools->Options and provide the exact script error in your post. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. space wars jerky?

  Hello, When I run space wars it seams to jerk alot when I move the ship around. It just doesnt run smooth at all. Can the game be played in full screen it runs windowed on my pc. I thought it would run smooth. My pc is: AMD A64 3200+ 2 gb ram 7600GT All drivers are up to date. Also when I try and publish spacewars, when installing it, it comes with an error. Anyone else have this problem thanks This issue isn't just specific to space war. One of my development pcs has this issue with every application I've tried that's written with the framework. ...Show All

• Architecture O/R Mapping and visual controls

  Hi I'm rather new to .Net: what is the best way to link persistent domain objects with data-aware visual controls What I'm trying to do is to use a rich domain model, get an O/R mapping tool/framework (e.g. NHibernate) to take care of persistence but still be able to use Girds and other DB controls. Any help would be greatly appreciated. Andrei. But I thought that Datasets would take care of at least filtering and sorting - I mean, I would expect that it will fire a new select query to get it sorted by some column or apply a filter. That way dataset does not have to fetch all the data to sort/filter it. Am i being completely wrong here Thanks Andrei ...Show All

• Visual C++ Managed array of pointers to elements in another managed array

  Hello, I have some problems using arrays (system.array) in managed code. I have a two-dimensional array available and I would like to sort the values in this array by making a second, jagged array of pointers to the elements in the first array. However, there are some problems: the first array is of course declared on the managed heap. Pointers to elements in that array can change as the CLR rearranges the heap. The solution to this is could be an interior_ptr (which makes sure the pointer is updated when the heap is rearranged) or a pin_ptr (which makes sure the 'pointed' part of the heap isn't rearranged). The problem is that both pointers are only declared on the local stack: it is not allowed to form an array of pin_ptr or inter ...Show All

• Visual Studio Express Editions Is this possible???

  As part of my program I would like to set up an address book. I have created the form for this. My question is: can I connect/create a database for just this part of my program. I have never created a database but am looking forward to giving it a go. This programming thing is totally addictive!! The reason storing in a text file is not the best of ideas - is that it means you have to write more code to do searching, sorting, modification of records etc. For this reason a database is a better bet. As to how difficult it is - With databinding, this is not a difficult task. Many of the walkthroughs / examples and webcasts which cover databinding can be modified to basically store different fields for ...Show All

• SQL Server SQL Server 2005 SP2 CTP1

  The word is that a public download of SQL Server 2005 SP2 CTP1 is available. Does anyone know whether this is true - and if so, where can it be downloaded The reason for my interest in this service pack is that significant changes around the behavior of subcube queries in AS should have been made, and I would very much like to test this. Subcube queries present a significant challenge when combined with certain types of calculated members. See: http://sqljunkies.com/WebLog/reckless/archive/2006/03/08/18601.aspx http://sqljunkies.com/WebLog/reckless/archive/2006/07/05/22106.aspx http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=282896&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=488496&S ...Show All

• Visual Studio Express Editions Excel Problem_VBE 2005

  Hi, I am new to this forum. I have an excel sheet with 4 column. I want to check first two columns values,if they are equal then i want to add 3 and 4 columns I want to put this result in 5 the column. any idea thanks Dim XL As Excel . Application Dim xlwb As Excel . Workbook Dim xlsheet As Excel . Worksheet XL = New Excel . Application xlwb = XL . Workbooks . Open ( "TheFilePath" ) xlsheet = xlwb . Worksheets (1) xlsheet . Range ( "a1" ).Select() If XL . Selection . value = XL . Selection . offset (0, 1). Value Then XL . Selection . offset (0, 4). value = XL . Selection . Offset (0, 2). value + XL . Selection . Offset (0 ...Show All

• Visual Studio Integration?

  Is there a forum just about VSS I am new to it and some pretty basic things have me stumped. For example, I have created a VSS database on U: and a working directory on C:. Yet every time I go to get a file for whatever purpose, I have to browse. It's time consuming and seems unneccessary, and there is no documentation to suggest the logic to be used when browsing. If I have a VSS database, I assume I should get files for my project from that location. Then when I 'Check Out' files . . . browse again . . . isn't it logical that I want to check them out from the same place I added them And why wouldn't I logically want to copy them to my working directory so that the web site I have set up can run them I think perhaps the software has man ...Show All

• Visual Studio Programmatically setting/changing command arguments for a VC++ projects.

  Greetings, I am working on a project that requires me to repeatedly change command arguments between running sessions. For example, I need to run the app with "-args1", exit it; and then run the app with "-args2", exit it; then run it again with "-args1", exit again; and then with "-args2", and so on. Such switching could happen dozens of times a day, so I want to simplify this task by using either a macro or an add-in, whatever works. For a baisc start, I hope to employ the macro to record what I do mannually: I bring up the project properties dialog and activate the Debugging tab, then change the Command Arguments string, then exit. The following is what I get from the macro IDE: " ...Show All