Kalyot's Q&A profile

• SQL Server Change the WHERE conditions dynamically

  Is there a way I can build a case statment or similar to handle different where conditions I know I can do it dynamic sql but it would be nice to have a method where I can create the querries directly in a normal statement Someting like: Select c1, c2, c3 From Table WHERE Case @Condition WHEN '>' @SelColumn > @Limit WHEN '=' @SelColumn = @Limit WHEN '<' @SelColumn < @Limit END I know this doesn't work so an example that do work would be nice. Yes, you CAN do it, but it's not going to perform well.  To do it, remember that CASE is an expression, not a control-of-flow statement -- it must have an output.  And since there's no BOOLEAN ty ...Show All

• Software Development for Windows Vista WinFx Runtime Components 3.0 Beta 2 install error

  Hi! The installation of the mentioned distribution fails becouse of error, the log file is: [08/13/06,22:23:25] Windows Communication Foundation Beta 2: [2] Error: Installation failed for component Windows Communication Foundation Beta 2. MSI returned error code 1603 [08/13/06,22:23:43] WapUI: [2] DepCheck indicates WinFX Runtime Components 3.0 - Beta 2 was not attempted to be installed. I've tried the command: sc delete "InfoCard Service", but the answer is: [SC] OpenService FAILED 1060: The specified service does not exist as an installed service. It is a brand new installation of Windows XP SP2 with only Office and Visual Studio on it, so I haven't tried to install WinFx on it. Please help! ...Show All

• Visual C# Processing global mouse and keyboard hooks in a new thread!

  Hello, I've read the following article: http://www.codeproject.com/csharp/globalhook.asp The code is working very well except for the problem the author mentioned: Question: I have a long delay when closing applications using hooks by clicking the x button in the titlebar. If I close the application via another event (button click) for example, that works fine. Answer: It's a know bug of Microsoft. It has to do with the Windows themes. If you disable the Windows themes, the problem goes away. Another choice is to have the hook code run in a secondary thread. Can anyone tell me how can I 'have the hook code run in a secondary thread' I would really appreciate your help. Thanks. ...Show All

• Visual C++ backward compatibility

  I have some project files which was built in the previous version of VS. I currently have VS 2005 installed in my system. when I try to open the project files, i am being asked to convert the same to the new version. Even though I converted once, every time I open the project, I have to convert the entire project once again. What is the way out Does it mean that we do not have backward compatibility here What would be the issue if we do not convert VS2005 can convert previous project files to the new version. After you convert, save the file and look into the vcproj file. If it's a VC++ 2005 project, it should start with < xml version="1.0" encoding="Windows-1252" > <VisualStudioProject Pro ...Show All

• Windows Forms Threading Problem

  Hi I have a winforms application which does some database processing and updates a progress bar. As it does the processing, it also writes to a log file using log4net. I would like to add a Multiline text box to the application which can be used to display the a "tail" of the log file. How can I do this thanks for that, I have now managed to resolve the problem by using Control.InvokeRequired and if this is true then I use Control.BeginInvoke (for asynchronous processing) on my textbox control to appendtext to the textbox. thanks ...Show All

• Audio and Video Development Getting a VC-1 file ready for advanced content authoring

  Hi all, I just started to author advanced hddvd content but i vailed in getting a valid video content to test my first project. is it possible to multiplex a VC-1 file with the Sonic authoring system for standard HD content in a way that i can use it for my first advanced content project I tried to import the vc-1 file into sonic, generated a simple autostart HDDVD, multiplexed it and used the HVDVD_TS folder for my advanced content project but it didn't work. The Nero Showtime softwareplayer diplayed the menu correctly but didn't play the video. I also tried to burn a dvd rom and inserted it into my Thosiba HD_DVD player but it just displayed the disc error 0x4095C501. Can anybody help me thx mikeret ...Show All

• Visual C++ FindFirstFile returing wrong results

  hi all , i used FindFirstFile function to search for files in folder and supplied a input as 'sea*' and though there is no file starts with sea still it is returing results as SEER_CSpringRight.xxx and SEER_ESpring_F_L.xxx .. Any help is appreciated . Well SEER_CSpringRight.xxx does match see*. Try "dir see*" in a command console. I guess you want "see*." to match all entries without extension, right -- SvenC ...Show All

• Software Development for Windows Vista what about legacy messenger service

  hi there, I noticed there's no legacy messenger service anymore, and the NET SEND command is now unknown. I'd like to know whether applications which relies on it will continue to work or not, and, if not, which is the best way to migrate them. I'm testing beta 5384 and it's the first Vista for me, so I don't know about previous ones. thank you. matro Hi, Since you asked for a perticular API, I am facing problem with API NetMessageBufferSend on VISTA. Also there is no Messange Service. Do you know if Net Send is discontinued in VISTA Is there any alternative to sending Net Send in VISTA Your help on this will be hugely appreciated. Thanks. Amol ...Show All

• .NET Development adding multiple constraint relationship in Access

  I need to add a multiple-constraint relationship between two tables in my app. The DDL for Access says that it should look something like: ALTER TABLE tbl_name ADD CONSTRAINT multi-field-index However, I can see no definition of what multi-field-index is. Have I missed something somewhere Sean Hi Paul. Thanks for this. I was just about to post that I found this very same answer by spending a couple of hours pawing through the Access docs. I appreciate your help. Sean ...Show All

• Visual Studio Express Editions MenuStripItem on sys tray

  After looking at this topic here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=381830&SiteID=1 Anyone know how to add some Sub or something for handling each individual MenuStripItem yes, exactly as I said. try this: on your form designer add a notifyicon and a contextmenu then click on the notifyicon to bring up is properties and in the "ContextMenu" select the context menu you just added then select the contextmenu control and on your form will appear a context menu strip. add your items in there once added, for each item you added, double click on the item to make an event for that item you would click on your systray icon (When you right click) do ...Show All

• Visual Studio Reportviewer works in firebox & safari over ssl, but not IE over SSL (fortress)

  Hello, I have a local report - using the reportviewer control - being displayed to internet users over an ssl connection (Fortress). The report works find in Safari and Firefox web browsers, but does not display in I.E. What happens is the reportviewer acts like it is going to display the report properly, but as soon as the "Report is being Generated" message ends, the report viewer control tool bar drops to the bottom of the page effectively not showing the report. I can click export on the tool bar - that works as expected and allows me to download the report as an excel or pdf file, but inside I.E. I cannot see the report. Thanks. I solved the problem. The issue was the reportviewer contro ...Show All

• Visual Studio Tools for Office vsto project - opening & closing of documents

  Group, I am working on a VSTO project that does the following: Project opens with my word.dot do while rs = true reads a record from a data file, builds a document, (based on data within the file), saves the document to a network path, prints the document closes the document loop. First document works great...... I now attempt to read record #2 and complete the same process as above, and before I can read the second record, my program is running somewhere, but I have no control of it. The MSWORD application is open, but no document appears. I no longer can step through my code, I don't have control. . IF I do not close the document, the program runs straight through, reading the 5 records in my file, the only ...Show All

• Windows Forms \r\n problems with textbox

  Hi All, I'm making a program which has a textbox, when I try to set the text of that textbox it seems to not allow \r\n to work, a small square box appears in the text instead of a new line being started. I've set the properties of the textbox so that multiline = true and scrollbars = true Does anyone know how I can resolve this please Any help would be gratefully received. Many thanks in advance and kind regards, Rich Well you should work out exactly what's in there.  There's no point randomly trying things out until it works.  Create a little for loop that steps through the string char by char.  \n = 10  \r = 13.  You might find there are other characters in there that you didn ...Show All

• Visual Studio Project updates

  Is there a tool for creating service packs in Visual Studio Currently we are running 2003, does 2005 maybe have this functionality Currently we are manually changing updated sections for the project. Ther must be a better way so that the user can download and run a patch or similar. Thank Mike ...Show All

• Silverlight (formerly WPF/E) Creating animations programmatically

  Hi Everyone, Is there a way to programmatically create storyboards in the current drop Example: I have a number of objects and an animation that I want to be applying to some of the objects programmatically. A new animation might be needed before the previous one completes, so naturally I'd want to design the storyboard once, and then clone a new storyboard each time it's needed, set the target and start it. Ideally it would be great to have controls / resources for that. But here's what I'm trying to do in the current CTP: this.xaml = '<Line><Line.Triggers><EventTrigger><EventTrigger.Actions><BeginStoryboard>'; this.xaml += '<Storyboard x:Name="{name}" Storyboard.TargetName="{targetName ...Show All