Zekske'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

• Visual FoxPro Problem trying to create an Encryption Library

  I have followed the example for creating a C# Encryption Libary, but receive numerous errors with regard to no overload method ' ' requires 2 arguments, I have verified that my code is exactly as the example provided by microsoft and found no difference. Has anyone ever tried this code and had problems. Is there any other code to create an encryptoin library in C#. I would appreciate any and all assistance. I am responsible for figuring out how to encrypt the connection string for our web config files in Asp.net page. (we dont' have the .net 2.o framework, we are using Visual Studio 2003 with 1.x framework Thanks Heather Ok. In Encrypt method you have to add this row IV = transformer.IV; in this point ...Show All

• Visual C++ Kerberos TimeStamp -- Unhandled Exception 0xC0000005: Access Violation

  Hi All, I've developed a Single Sign On application using Visual C++ 6.0 that uses Kerberos authentication. My application does what it is supposed to do, but I want to be able to view the expiry time of both the credentials (as returned by AcquireCredentialsHandle) and the security context (as returned by InitializeSecurityContext) for debug purposes. The expiry time is of data type TimeStamp, which is a LARGE_INTEGER union structure which is used to represent a 64-bit signed integer value. You can reference the low and high order 32 bits (using LowPart and HighPart) or the full signed 64-bits (using QuadPart). Just for starters I was trying to view either the LowPart or the QuadPart, but everytime I include ExpiryTime.QuadPart (where ...Show All

• Visual Studio Tools for Office Outlook Addins VST2005

  Will outlook add-ins developed using VSTO2005 work the same in Outlook 2007 Thanks, Hrishi It is very hard question and depends on what the add-in does. Consider, that Office 2007 UI has changed dramatically, so if you do have customized CommandBars you might want to read more about how the change to legacy CommandBars are reflected in new UI . Otherwise, the Outlook team has tried to maintain compatibility to the hight possible degree. So, it should work. ...Show All

• Visual Studio Express Editions MS-DOS??

  How can i create a program that can open up a MS-DOS program within a window Thanks. Process.start is definately the class to use to start a application. In you case a DOS application. For more info Process.Start http://msdn2.microsoft.com/en-us/library/0w4h05yb.aspx This method allows you to provide a command line argument by specifying a second parameter. Often useful as many DOS application allow the applications startup/configuration setting to be configured when calling the application. ...Show All

• Visual Studio Addin Logging

  Hi, I want to add logging to my addin file. we are using standard loggers, so that you can configure them from the application.exe.config file. Of course we are running inside visual studio, and we don't want the users to have to deal with the devenv.exe.config file. Is there another way to do it Is there a config file for the addin dll something like myaddin.dll.config Is there a way to add logging level to the .addin file thanks. Hi Noa, Carlos is correct. Your addin, could make use of the devenv.exe.config, but we don't really recommend that. The only logging facility currently built into the shell is the IVsActivityLog interface. This is an interface defined in the Visual Studio ...Show All

• Visual Studio Team System Conditional Code Analysis Builds

  Is there a way to simply (either via a macro or some other method) disable code analysis for a particular build. I know you can instruct VS to run code analysis on just one particular project, but sometimes I want to build quickly, without CA, like when the project I am building has many dependencies that I don't want to analyze at that time. I want to build conditionally. That is to say not change any code or the active solution configuration. I just want to build with or without code analysis on based on a shortcut assignment. ...Show All

• .NET Development 64-Bit OS Error: VFPOLEDB.1 Is Not Installed on Local Machine

  I need some help folks... I am getting the Infamous " provider not instaled on local machine" message for the VFPOLEDB Driver. 1.) It has NOTHING to do with what user I register it with (I've used them all, local and domain) 2.) The driver is most certainly there, and so are the registry entries. This error only occurs on 64-bit Operating Systems. Is there something different out there I have to do on a 64-bit OS. It says it registers correctly, the registry entries are there, and yet, I still get the error. I can install my VB.NET app on 32-Bit OS's all day long without error. I've tried setting a deployment project specifically for an "x64" CPU, and still no luck. I can find anything on the internet ...Show All

• Visual Studio GetMarkerCommandInfo in HTML Editor

  I have a text marker that is implementing a marker context menu by implementing GetMarkerCommandInfo. This works great in ever text editor except the HTML editor, where it never gets called. Is this simply not supported, or are there additional marker registrations needed to have the HTML editor participate Sweet. Thanks for your help, that did it. I went and registered the context marker menu and my own menu group in all those mode target ids and all is working. It's a bit verbose in my CTC, but otherwise not a big deal at all. ...Show All

• Software Development for Windows Vista "WORKFLOW FAILED VALIDATION ERROR" in XOML WORKFLOWS!!!!

  Hi Gurus, Pls Help..I got stucked with this error while running the XOML State machine Executable Workflow.Here is my Code where it showing error XmlReader reader = XmlReader .Create(xomlpath); WorkflowMarkupSerializer wms = new WorkflowMarkupSerializer (); Activity wf1 = wms.Deserialize(reader) as Activity ; //HERE I GET ERROR SAYING WORKFLOW FAILED VALIDATION!! NewInstance = WFRuntime.CreateWorkflow(wf1.GetType()); NewInstance.Start(); 'xomlpath' is the path of the Xoml workflow. I tried other ways of creating workflow passing (xomlreader,rulereader,parameters).That also is showing the same error. Pls help..Its soo urgent Thankz in advance Sunath My apologies,  ...Show All

• Software Development for Windows Vista Replicator/Parallel Activity Performance Question

  What's the upper limit for Replicator+Parallel Activity created sub-workflows. I have an existing app in C# which is workflow-like and could use improvement. One of the possible redesign decisions would be to split the data stream into its constituents and send each item through the workflow in parallel. We're talking thousands of items here, perhaps as many as 10-20 thousand. Thanks Costas There's no hard limit. It really dependends on what's inside your replicator/parallel activities. In this scenario, your workflow instance state could be big, because you're executing all these activities in parallel and it can take some time to initialize them. You should closely monitor memory footp ...Show All

• Visual Studio HTML Help Workshop versions

  I have not been able to successfully build the sandcastle samples. I believe that my problem is with my version of the MS HTML Help Workshop; in the hhw.exe's about dialog, my version is listed as 4.74.8702.0. I've downloaded the vesion 1.3 of the htmlhelp.exe installation file, but am prompted after installation that "This already has a newer version of HTML Help." in a dialog titled "HTML Help 1.31 Update". I've tried uninstalling my MS HTML Help Workshop before installing the v1.3, but I still end up in the same scenario. So, my question is: How do I get rid of this 4.74 version (dated from 2000), and get v1.3 installed Or, am i missing the boat with the versioning and the version I have is what I need t ...Show All

• Windows Forms Windows Activation

  Hi. I have just formatted my hard drive and when i try to re-activate windows it says my key is in use. Is there any way to re-activate not via phone Any help appreciated. Sorry if this is wrong place to post. You can ask your question in following webpage.I hope it helps http://www.microsoft.com/communities/newsgroups/default.mspx ...Show All

• Visual C++ Help me to write a C++ program

  Hi, I am new to C++ program, Pls help me for following probelm. I have a text file as following, DYNAMIC ANALYSIS 次元 部加振　活荷重 3 1 0 0 KACC KDIS KSTS KSTN KSSR KJOT KNOD KRAT KSEC KMSS KWPR 7 7 14 14 0 14 1 0 0 1 0 FREQ GFREQ EXMAX 0.0 2.00 1.0D-6 VISCOUS BOUNDARY INFORMATION 3 2.00 77 60 11 66 0 0 加速度時刻 出力節 番 (KACC=0.OR.>NTJ 場合,削除) 1080 1254 1484 1549 1563 1592 1608 JOINT 動出力要素番 (KJOT=0.OR.>JOINT 場合,削除) 7 8 20 22 117 118 127 128 129 130 133 134 139 140 NODES 1 -101.582 -234.742 280.000 3 2 -76.838 -234.742 280.000 3 3 -54.479 -234.742 280.000 3 4 -34.276 -234.742 280.000 3 5 -16.020 -234.742 280.000 3 6 0.476 -234.742 280.000 3 7 19.06 ...Show All

• SQL Server [XML Task] Error: An error occurred with the following error message: There are multiple root elements.

  I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message: [XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.". The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it: < xml version="1.0" encoding="UTF-8" > <ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title=& ...Show All