Todd A. Heath's Q&A profile

• SQL Server SELECT WHERE Date is...

  Hi All... I have a table that has a field called LogDateTime whose type is datetime. How do I specify the WHERE clause if I want only those records that are say from the last three days Such as WHERE (LogTimeDate < Today - 3 days)... Thanks for any help!!! -- Curt Curtis: -- ------------------------------------------- -- It is best to avoid enclosing the target -- within a function such as DATEADD or -- DATEDIFF because this can potentially -- inhibit the use of an index that might -- provide a performance boost. -- -- The dateadd can of course be used instead -- of directly decrementing the GETDATE -- function. I have chosen to directly -- decrement the getdate function. -- --------- ...Show All

• Visual Studio 2008 (Pre-release) WinFX Runtime Components 3.0 Beta 2 installation problems

  Hello! I have some major problems installing WinFX Runtime Components 3.0 Beta 2. It won't work... The errorlog says: [05/26/06,11:43:37] Windows Communication Foundation Beta 2: [2] Error: Installation failed for component Windows Communication Foundation Beta 2. MSI returned error code 1603 [05/26/06,11:43:56] WapUI: [2] DepCheck indicates WinFX Runtime Components 3.0 Beta 2 was not attempted to be installed. I have tried everything, please help me! /Goran Please follow this procedure described the readme: "2.7 WinFX Beta 2 installation fails on a system with WinFX Jan CTP or earlier previously installed" The readme is here: http://msdn.microsoft.com/windowsvista/support/relnotes/winfxbeta2/defaul ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. The values used in the attempt to create the GraphicsDevice were invalid.

  Is this because my graphic card does not support shader model 2 I didn't even know of this requirement till I saw it on the readme file. Time to change my geforce4 Nvidia GeForce 4 Ti 4600 here, same error - total bummer too, might have to work on the laptop for a while until I either buy a new card or a solution arises... still, looks like nice concise code, reminds me of the Jad engine, good stuff guys at least from what I can see of it :) ...Show All

• SQL Server CAL vs. Processor License on secure login enviroment

  I need to upgrade a solution from SQL Express Advanced to Workgroup Edition because of the 4GB size limit. I'm planning on deploying the solution in an secure web enviroment were only authenticated users will be able to access the database. The actual username's and passwords would be stored in an Express database. Therefore since only named users would be accessing the database server web app, can I use the CAL license model I believe the answer to this is "yes". You'll want to make sure that you check with your local Microsoft rep, but we don't license based on how or where the technology is deployed, just on how it is accessed by the users. I had a deployment like you're talking about, and ba ...Show All

• Visual Studio Adding C# to a previous installation of VS2005

  A couple of months ago, I installed VS 2005 (only VB). Now I would like to ADD C# to that installation, but it looks like the setup asks me to DEINSTALL everything before proceeding Is it the normal behaviour Or have I done something wrong thx You shoud normally have the option to add/remove features, repair/reinstall and completely uninstall Visual Studio. Which version did you install And when you try to add C# are you using the same installation media ...Show All

• Windows Forms Multiline tooltip for ListView control

  How do I make the tooltip display the ListView item text in multiple lines when the mouse pointer is hovered over This is exactly what you need- http://www.vbaccelerator.com/home/NET/Code/Controls/Popup_Windows/Floating_Controls/article.asp You can tweak it to met your needs. ...Show All

• Internet Explorer Development Having problems with accepting certificates on IE7

  Hello, I'm having problems with IE7, cause it doesn't want to accept a certificate. I've tried almost everything. I've installed the certificate to one of the "Trusted..." certificate folders and still didn't work. Than I've cancelled all the certificate controlls in the "internet options" menu, but still din't help. Actually, I can access the site, but every time I open IE, I got to click the button to tell it to open the site, and that's very frustrating to me. Could you please help me how to accept a certificate permanently I just wanted to use IE to have the best support on WinXP when it's developped by MS as well as WinXP. Many thanks for all help. Hi, I a ...Show All

• SQL Server Getting a file name from Query Analyzer

  Hi all, im trying to write a stored procedure that will basically browse a folder and get me the first file that it sees. Is there any way that I can do this in TSQL or using CLR in C# I was thinking something along the lines of using the dos dir command and triyng to pipe it into a variable, not sure how to go about doing this. Any suggestions dir /b ...gives me the bare file names, but it lists all the files in the folder, any way that i can just get the first file ( i dont really care what file). create table #filelist ( files varchar(500) ) truncate table #filelist insert #filelist EXEC xp_cmdshell 'dir c:*.* /b' select top 1 * from #filelist ...Show All

• Visual Studio Express Editions Compile a stand-alone cpp using the IDE

  Hey guys, can anyone tell me if it is possible to compile a stand-alone cpp using the Visual C++ Express IDE. I've seen in the other threads that it's possible using the command prompt compiler. But I dont want that! How do I compile a .cpp file without using a project It was possible in previous versions of VC++ (atleast to my knowledge!), in that if you try to compile a .cpp without a project, it would make a temporary project and compile it, doing all that in the background. Plus, in another thread, someone said I should uncheck the 'Save new projects when created' option in the 'Projects and Solutions' node in the Options dialog (Tools > Options). But it's still not working. There is no Build option for the stand-alone. What do I do ...Show All

• Software Development for Windows Vista Handling Events.

  At many examples of WF i saw that when a logic is implemented handling an event, the syntax is this: child.Closed += ContinueAt; and not: child.Closed += new EventHandler < ActivityExecutionStatusChangedEventArgs >(ContinueAt); My question is: When i use the first approach it ensures that the execution of the ContinueAt method will be scheduled, meaning that it will be created a new work item, added to the Scheduler Work Queue and executed when appropriate (when called the Dispatch method). If its so, the second approach would cause a break of the WF Runtime normal execution, since the ContinueAt method vould be invoked immediatly after the event was raised, without creating a work item at the Scheduler Work Qu ...Show All

• Visual Studio Express Editions Ending a Sub

  Hi there, I have these IF statement and after it finds the first one which is true I want it to stop the Whole Sub. Thanks, AliQ Exit Sub or Exit Function depending upon whether its a sub or function your trying to exit The following shows and example Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If textbox1.text = "Foo" Then Exit Sub End If End Sub End Class ...Show All

• Visual Studio Tools for Office OutOfMemoryException with new ServerDocument in custom setup action

  We have created an installer that installs pre-reqs for our custom Word solution using VSTO 2005 (a Task Pane app embedded in a .DOT). We have a custom setup action that updates the document manifest - generic cookie cutter stuff here, nothing special. The installer works very well for most users. However, one user has reported receving "System.OutOfMemoryException" during install. Forunately, we embedded some code that made it possible for me to know that it was this line of code: serverDocument = new ServerDocument (documentPath, FileAccess .ReadWrite); The documentPath variable points to a valid DOT that has our customization. Any ideas This is a potential showstopper for an upcoming general release. The ...Show All

• SQL Server Filter Parameters to exclude empty members

  How does one only provide a list of potential parameters that contain values... Let's say I want to show a report of product sales by Employee, yet only certain employees actually sell products. In the parameter dropdown I want to just have a list of those employees with a product sales value as opposed to a list of all current employees. I'm guessing it has something to do with NONEMPTY but I can't quite get my head around it Can anyone help with the relevant sample MDX for the parameter dataset Deepak, Thanks for the help & advice. In the end I created three datasets as follows, using your steer from the last post so thanks. 1. The main Dataset SELECT NON EMPTY { [Measures].[Fact Account Balances Count], [M ...Show All

• Visual Basic CheckBox Service control (VB, VS 05)

  I decided to try and expand my project, I now wish to have the (current, I'm adding more as I find out which aren't required ) two processes here's a brief on what stage the additions are at. I have added 4 check boxes named; SpoolCheck1 SpoolCheck2 MDMCheck1 MDMCheck2 (more will be added as I find out more that can be stopped) and two command buttons named; StopCheckedButton StartCheckedButton I would like to 'link' the check boxes to the command buttons, but the checkboxes job (when checked, then clicking the start/stop command buttons) is to start/stop the selected program/process, in this case spool and mdm. I have these codes for starting and stopping the processes and return a message if there is a problem. ...Show All

• Software Development for Windows Vista Asp.net & WWF solution architecture advise???

  Hi Everyone, I'm a newbie with WWF and am looking at using it in a web app. I've got a standard solution architecture for apps where i have the client layer (webui project), a shared domain (c# lib project with domain objects) and a facade (lib proj, which contains ref to bl, also do some AOP for transactions etc here), bl(lib proj which in turn refs the dl). so: Webui--->facade--->bl--->dl--->database <-------------------domain-----------------------> ------------------------------------------------------------------------------------------------------------------------ e.g. getting a list of vans's page_OnLoad(){ List<Van> vans = Global.Facade.VansGet(); } in the facade method i do so ...Show All