ThEpRoPhEcY373's Q&A profile

• SQL Server Dates in Reporting Services

  hey all set up Visual Studio 2005 SQL Server Express / Reporting Services four fields State date Start time Finish Date Finish Time I need to take one away from the other - can someone please help me Is it better to keep these in separate fields or to combine and subtract Is there anything special I need to know with subtracting time I am reasonably newbie still so would appreciate any help thanks I am using the visual side in Reporting services - Data - Layout - Preview. thanks Jewel it depends where you combine the fields. You can either do this in you source query or using the .NET object model in an expression. Either way you need to make sure the field has the ...Show All

• SQL Server [SSIS] : STDEV in Derived Columns

  Hello, Does anyone have already tried to calculate a standard deviation (STDEV) in a derived column Any help is welcome ;-) Cheers, Bertrand Bertrandr wrote: Hello, Does anyone have already tried to calculate a standard deviation (STDEV) in a derived column Any help is welcome ;-) Cheers, Bertrand Have you looked into the documentation http://msdn2.microsoft.com/en-us/library/ms141671.aspx it looks to me thta function is not available...you may want to do that in the DB or create a script component. ...Show All

• Visual C# ActiveX control in Windows Service

  Hi   I need to use an ActiveX control in my Windows Service. It doesn’t need to have a form or show anything to the user.   When I debug my Windows Service i can see the AtiveX control object have a lot of inside exceptions like this one:   SHDocVw.InternetExplorerClass Document threw an exception of type System.Runtime.InteropServices.COMException   Yes its the Internet Explorer ActiveX!   So how do I use an ActiveX object in a Windows Service (Internet Explorer)   (I know its risky and a bad design to use ActiveX controls in a Windows Service, but I don’t care ... if is possible, plzz help) ...Show All

• .NET Development Windows App from .Net 1.1 to 2.0

  I recently installed VS 2005. I converted my 1.1 windows app to 2.0. It debugs fine on my machine (no errors). The release runs fine on host machines with 2.0 (and 1.1) but it crashes on machines w/o 1.1 installed. The release runs fine on my machine even after I've uninstalled 1.1. I don't know what the difference could be. The debug report on the host machines contains no useful info to me. Thanks in advance for any suggestions. are the computers with the same OS Well, hmm some features are not available in Windows 2000 SP4 apperently, and can cause the InvalidOperationException. Then again, the except means that it cant do something because its not there - can either be the OS being used OR (most likely ...Show All

• Visual FoxPro how could i permanently delete a record deleted in a form?

  Good day to everybody in this forum is there a way we could issue a command "pack" in an open table in a form . My table is at dataenvironment, naturally it will open automatically when the form shows. i use primary key in the account code which is automatically increment when a new record is added, But if i delete the last record, and add a new one it gives an error, so i have to close my form and issue a pack to that table at another form created for packing,validating database, & reindexing tables. But it seems to be time consuming, i have to close the form then back again to my work. Thank you very much in advance for any help regarding this matter. Pack should be reserved to maintenance routines. Rethink your desi ...Show All

• .NET Development C# ListBox Glitch

  Hi, I'm using VS .NET 2003. I have a list box and a user can add a file and it will read through the file and add each line to the listbox using: ListBox.Items.Add(theString); That part works fine. The problem is I set the list box to allow the user to select multiple items so those selected items can be removed. When I load just one file, it removes the correct selected items, but when I load two it doesn't remove every item that was selected. I've tested it in detail printing out everything it did and realised the 'aListBox.SelectedItem' method wasn't working correctly. Say when 5 items were selected the SelectedItem method said only 3 items were selected. Anyone know how I could possibley fix this problem without disabling multiple sel ...Show All

• Visual Studio An error has occurred while trying to access the log file. Logging may not function properly.

  I receive the error message defined in the subject of this post, then Visual Studio hangs and fails to launch. How can I repair this Excellent! I had the same problem and had completely forgotten about VM 6 beta installing that IDE support. Re-ran setup and removed the IDE support and everything is working much better! Thanks! ...Show All

• SQL Server import flat file

  I am trying to import a flat file using SQL Server Management Studio and am receiveing the error: Error 0xc0202055: Data Flow Task: The column delimiter for column "Column 19" was not found. (SQL Server Import and Export Wizard) I would like to capture the rows that are causing the error and have the import continue. Am I able to edit the behavior somehow Thanks. tantz wrote: I've been trying to edit the package in BIDS but am not having success. I'm importing a flat file and am trying to write the records that do not get imported successfully to an error file. If anyone can help me out..... Thanks. You will have to tell us what you are not having success with first. ...Show All

• .NET Development Regular expression quick question.

  Ok I have a string like this: string myString = "blablabalbal\r\nSTART/this is some test//this is another test\r\n//litle test test2\r\n//test3//"; What I want to archieve is a regular expression that will return: START/this is some test// In order word, from the START and from the first two backslashes. I have try that: regExpr = new Regex ( @"^START/(.*)//" , RegexOptions .IgnoreCase | RegexOptions .Singleline); match = regExpr.Match(repText); if (match.Success) { } The problem is that it will get everything and will return the START to the end of the string...Is there any way to return the first occurence of the // Another test that I've tried witout success is: regExpr ...Show All

• Windows Search Technologies Where can i find samples for IFilter to support more file extensions?

  Hi, I want to know where can I find samples for supporting new files types in Windows Desktop Search I found an article on MSDN, writing an HTMLProp sample . It mentions a path Path Source: mssdk\samples\winbase\indexing\htmlprop\ I'm not sure abt he 'mssdk'. I guess its Windows SDK for Vista. Still, after installing I couldn't find appropriate sample for IFilter (at that location). Can anybody point some useful stuff to start Thanks, ~ Ankit you also might want to check out channel 9: http://channel9.msdn.com/wiki/default.aspx/Channel9.DesktopSearchIFilters cheers, Ed ...Show All

• Gadgets Layout for gadget

  If I would like to create a layout with a navigation bar on the top for access to 3 different areas/panel of the gadget .... how Can I do this I hope you can help me! ToddOs wrote: simple available right now. For now, pick your way through the soapbox gadget code I mentioned before for the layout question, and the binding post I mentioned for info on bindings. I'll work on writing up a sample based on Soapbox's tablist and will post here when I've got something shareable. Thanks for your reply ToddOs ... but where Can I find the "gadget code mentioned before..." I can't see the code Thanks! ...Show All

• Internet Explorer Development document.location.search is null in ie7 rc1 for local url

  I launch my app from a local file and pass it the location of a remote server in the query string.  For example, given the following shortcut: "C:\Program Files\Internet Explorer\iexplore.exe" file:///c:/abc/abc.html REMOTE_SERVER=https://ie7.microsoft.com/server/ I have javascript on that page which parses document.location.search to obtain REMOTE_SERVER .  In ie6, this works.  In ie7 rc1, it is null.  Can anyone suggest a fix or workaround   -Thanks This does not seem to work. document.URL is slightly different. It changes the forward slashes to backward after the drive letter and removes one of the forward slashes after file:/// , but it still removes the sear ...Show All

• Smart Device Development System.Thread.Timer help

  Hi, I was hoping some could help with a threading issue that uses a timer. I would like to have a piece of code execute every 10, 15 or 30 minutes. (users choice). So, as users are using the application every ten minutes I need to do write something to the database. Sorry I am so unfamiliar with the System.Thread.Timer object I do not even no wherre to begin. Any help would be greatly appreciated. A logical first step would be to get familiar with it, e.g. by reading MSDN article. I would assume you can't find it because your namespaces are wrong, so here it is: http://msdn2.microsoft.com/en-us/library/system.threading.timer.aspx Also please read this, item #7 and #17and ask specific question ...Show All

• Visual Studio Team System How will CTP7 and RTM Install as a Product?

  Will CTP7 and the RTM version install as a completely separate and distinct version of Visual Studio For example, assume I own VSTE for Developers and purchase DataDude. Will DataDude integrate into my current copy of VSTE for Developers, or will it install as a completely separate (second) version Meaning, if I want to work on my C# code for example, I would load VSTE for Developers. But, if I want to work on database schema, I would load VSTE for Database Pros. Thanks - Amos. To rephrase Gert's answer: it will still be one single Visual Studio IDE, and you will be able to open, for example, both C#/VB and DB projects in the same solution if you have VSTE for Developers and VSTE for DB PRo installed. ...Show All

• Visual Studio Team System Viewstate hardcoded as Form Post Parameter

  One of our web apps allows the user to create notes or reminders by launching a new window. The webtest is recording the launch of the new window and the submittion of the note or reminder however, looking at the Form Post Parameters for the submittion, __VIEWSTATE is hardcoded. I can extract the viewstate from when the form launches and use that, but I am wondering why it is not automatically being grabbed as a hidden field. Could there be a limitation as to the length of the viewstate as a hidden field For Creating a Note it is over 200K long. For Creating a Reminder it is over 700K. (Please give any recommended code in VB. ) Thanks in advance.   This is likely a bug th ...Show All