Javahar's Q&A profile

• SQL Server Multiple relationships between one fact and one dimension

  Hi, One of my old 2000 cube got converted so poorly that I rebuilt it from scratch. This cube has a fact table with 3 different version of an integer representing a week. In the new dataview, I linked the 3 weeks columns to one week column on a calendar dimension. Then I build a week shared dimension. It looks like it works, I have 1 shared dimension and in the cube dimension usage i have 3 dimensions based on that shared dim, each is using another column for the join. Sounds too god to be true. Where can I find more information on complex or exotic relationship I have to forget my old relational conception of relationship and joins, actually these may not be joins, this may be the bigest thing to forget. Thanks, Philippe ...Show All

• Visual Studio 2008 (Pre-release) VS 2005 XAML IntelliSense

  Hello, I have installed everything I can find on .Net 3 including the extensions. I am currently having issues with the XAML Intellisense not working. Not only will it not pick up my own project references eg xmlns:custom="clr-namespace:SDKSample;assembly=SDKSampleLibrary" <custom: does not work. But also when I try to tap into TextBox.Text for the <Binding> It does not recognise it. Have I missed something to install Thanks, Brett. Hello! I had Intellisense work with XAML editing at the beginning of a project. But suddenly, it would not work any longer (with WPF base types, actually). I also use custom controls, but I knew Intellisense would not work with t ...Show All

• Silverlight (formerly WPF/E) How to do development on a Mac?

  How do you do develoopment on Mac >> What programming language is used for Silverlight-applications working on Windows AND Mac Answer: XML and Javascript. Silverlight is a declarative tool. You build up your presentation with XAML (XML), and then you make it interactive, and add other various animated features via Javascript. >> So every Silverlight "application" that is developed with .NET will only work on Windows yet, right >> Does the Mac user gets an error message then Answer: Silverlight is completely independent of .NET. It only uses XML and Javascript. Everything you build works just as beautifully on MAC as it does on Windows >> Is there a ...Show All

• SQL Server Failed to launch 'osql'

  I use one-way Transactional Replication on 38 servers with same configuration. On one server I have problem with OSQL.EXE path. On Publication properties -> snapshot -> Additional scripts -> Before applying the snapshot, execute this script: Is set preinit script (C:\ReplData\ReplPreInit.sql). On Distribution agent properties -> step "Run Agent" I set additional command for log problem. command= -Output C:\ReplOutFile.txt -Outputverboselevel 2 Here is part of ReplOutFile.txt: -------------------------------- The osql command is: "C:\Program Files\Microsoft SQL Server\80\Tool\Binn\osql.exe" -U"***" -P"***" -i " \\STROSBB\ReplData\unc\STROSBB_antikor_DataCDB\20060908104051\Rep ...Show All

• Visual C# How to get a page source code of URL programmatically?

  From a C# routine I need to go to a URL page and download the HTML source code of that page bypassing the browser. I then intent to analyze the code and extract another URL -- but I already know how to handle it. I prever to have this page in memory, as a string variable, not as a disk file--it is intended for a very temporary usage. The challenge for me is to figure out how to have the program download the HTML code without alerting the Internet Explorer Browser. I am sure it is a simple problem for a longtimer. Hope for help. Thanks You can fetch the html page using HttpWebRequest class: HttpWebRequest request = ( HttpWebRequest ) HttpWebRequest .Create(url); using ( Stream stream = request.GetResponse().GetRespo ...Show All

• Visual C# project properties file(s) and web references

  A project Im working on was updated by someone else (via source control) and apparently they created some properties files when they added a reference to a web service. However, i think they didnt do anything explicity to do this, but when i updated my code with these changes, I didnt have these properties files and hence my build failed. Why would adding a reference to a web service cause data to be saved in a properties file and how can I avoid it ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. F14 XNA Game with Full Source

  Well here it is. I finally got my first game into a releasable state. Screenshot, video, and full source available after the jump. http://aroganworld.blogspot.com/2006/09/f14-xna-game.html I couldn't have done it without the great help from this forum (and all those xna sites). Let me know what you think. Yeah let me know if you have any issues. I did d/l the zip, unzipped it to a new directory, compiled and did a test run so I think it should work. Also, I just remembered I forgot to hook in the game over voice clip. Oops. It's in the sound bank, I just forgot to trigger it so I'll probably update the zip tonight when I get home. It was a late night last night. Damn you Microsoft for making this time si ...Show All

• SQL Server limiting the number of child rows

  Hi I have got two related tables (tblMembers and tblTickets) that have a 1 to 2 relationship i.e a member can have 1 or 2 tickets, but not more. How do I enforce this condition in SQL . Please help Hello, There are several ways to implement this. I assume you have a table similar to tblMemberTicket in which you have a 1-n from tblMemebers and a 1-n from tblTickets... 1. Triggers 2. Check constraints 3. Application login in stored procedures. If you need enforcement at the schema level, then only options 1 or 2 are applicable. Cheers, Rob ...Show All

• SQL Server run-time changeable queries

  I need to extract and store a value from a table (or from a MS Access file with OpenDataSource) which is not always the same and it is therefore stored in the @openfile variable. Something like this: ... declare @standardselect nvarchar(4000) declare @value int select @standardSelect='select top 1 @value=val from ' + @openfile exec (@standardSelect) ... It obviously doesn't work because the variable @value is not declared within the sql string. However, since @openfile is always different, I need to pass it through a string and the only way I know is within a variable. If I declare @value inside the @standardselect it is not accessible to the rest of the procedure, which is not acceptable for me. Any suggestions ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Are multiple SpriteBatches necessary?

  I"m currently working on a tile-engine demo, and a single spritebatch all of my drawing. Are there any advantages to using multiple spritebatch objects If yes, what is the criteria for determining how to break it down Using a single spritebatch should generally be fine. The main issue to do with sprite performance is how many times you call begin and end on the batch, and the sorting of your sprites within each batch. For optimal speed you should use a single begin/end pair for as much drawing as possible, and within that block, draw sprites ordered by their texture. If that's hard for you to achieve, you can tell the sprite batch to sort them by texture for you (but that might be slower ...Show All

• Visual Studio Tools for Office Stablish cursor position in Word

  Hi: I'm using a WebBrowser control to display a word document. But I have to open it ready to start typing. Right now the cursor is not abailable until you click inside the control and appears at the beggining of the document. And a toolbar appears too, I need to hide all toolbars. I hope you can help me. Thanx. NMB I presume you are loading a word document inside IE as a host of Word You have to have the document activated and as such dont think there is a way around this. This is not the best forum for this answer as it is more of an IE Hosting scenario. You can try and control the Host Object and cast this to a WordApplication and then set the Toolbars to be visible. I a ...Show All

• Visual Studio 2008 (Pre-release) MediaElement Scrubbing Issues

  I am working on a software project which makes use of WPF's MediaElement. I have used it to make a media player which allows the user to save pause points of the video, and it also includes the standard playback controls found in other players. The user is allowed to select these pause points, and then the MediaElement is told to jump to these locations, and also pause the video. Because the video may or may not be playing when a pause point is selected, I have set ScrubbingEnabled to true. Anyway, the problem I am having is that occasionally (15-20% of the time), when a pause point is selected, the video frame is not updated accordingly. The video does seek to the proper location, as when playback is resumed, it resumes from the proper p ...Show All

• Visual Studio Express Editions check application Open or not

  Hi, I have created one application in VBE. I have installed the application. I wanted to check in my program how many times the program executed or opened. Or is it possile to check whether the application is opened on current date or not Please Help me Thanks Try this: Imports System.Diagnostics Imports Microsoft.Win32 Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim start As Date = Process.GetCurrentProcess.StartTime Dim key As RegistryKey = Registry.LocalMachine.CreateSubKey("Software\Nobugz\MyApp", RegistryKeyPermissionCheck.Default) Dim runs As Integer = CInt(key.GetValue("Runs", 0)) runs += 1 key.SetValue("Runs" ...Show All

• Visual Studio Team System New Team Foundation Server MSSCCI Provider Available Now!

  I am happy to report we have released an updated TFS MSSCCI provider here . We have been able to address a number of requests (keep them coming) in this release including the following: PowerBuilder support Enterprise Architect support Improved Open from SCC experience Work items can now be modified in the checkinwindow Get latest on checkout support Check-in lock is treated as exclusive Setup works on x64 This is an unsupported "powertoy" like tool. There have been some discussions about the possibility of supporting it, but nothing yet. Keep reporting issues and comments to the forum or by e-mail . I have installed this thing in the hope of using it to manage my VS.NET 2003 projects wi ...Show All

• Visual C++ Unresolved external symbol when using __inline in implementation file

  Hi, I am new to C++. Could somebody please explain why when I include __inline in the implementation file, some functions caused "Unresolved external symbol" error but not all. XCString.h ========================== class XCString { private: LPWSTR Buf; // Buffer. int Len; // Length; public: WCHAR operator[](int loc); // Operator [] overloading. XCString& operator=(LPWSTR str); // Operator = overloading. XCString.cpp ======================== __inline WCHAR XCString::operator[](int loc) <- ERROR { return Buf[loc]; } __inline XCString& XCString::operator=(LPWSTR str) <- No problem { delete[] Buf; Buf = new WCHAR[(Len = wcslen(str)) + 1]; wcscpy(Buf, str); return *this; } ...Show All