SterlingH's Q&A profile

• SQL Server Performance problems with SQL commands in data flow task

  SQL statement within an OLE DB Command component is extremely slow (hours, days). Same SQL statement executed within a query window of SQL Server Management Studio takes only a few seconds. Using a fairly simple SQL UPDATE statement against a table with only 21,000 rows. Query: UPDATE Pearson_Load SET Process_Flag = 'E', Error_Msg = 'Error: Missing address elements Address_Line_1, City, and/or State' WHERE (Address_Line_1 = ' ' OR City = ' ' OR State = ' ') AND Process_Flag = ' ' Any suggestions on how to improve the performance of this task or an alternate solution are appreciated. Thank you. Jeff-B wrote: SQL statement within an OLE DB Command component is extremely slow (hour ...Show All

• Visual C# Using Auto Spaces

  Hello, I want to use the auto space system, for example: if I write this: a=1; it will write me: a = 1 ;( with spaces ) I tried to find this option but I haven't found. Can someone tell me please where is this option Thank you! thread moved to the appropriate forum usually the IDE of C# does this automatically for you anyway. Take a look at the IDE options: Tools > options, select "Text Editor" and expand the tree, then go to C#, Formatting then spacing. ...Show All

• Visual Studio Tools for Office MacroButton Field

  Hi Can't insert MacroButton field with text label. After file creation I have field without display text. When I change WdFieldType.wdFieldMacroButton to WdFieldType.wdFieldComments everything goes alright. What's going on Hi Ruben This question isn't really VSTO-technolgy related, so this isn't the proper place to ask it. A better venue would be the office.developer.automation newsgroup , or maybe word.programming. When you post, be sure to include the following information - the type of project you're working with, including the programming language - the version of Word you're targeting - more information about what you're actually trying to accomplish. Are you trying to create a Ma ...Show All

• Visual C++ Multiple Compilation

  I have a class defined in a header, for example Node root;, but when I compile and link I recieve a link error, saying it has already been defined. To get rid of this I placed #pragma once at the top of the header, to no effect. I then replaced it with #ifndef DIRECTXSCENE #define DIRECTXSCENE 10 and then at the bottom: #endif This did nothing either. Any suggestions Mike I also helped to differentiate between declarations and definitions in this thread . ...Show All

• Windows Forms Dynamic Property Grid Enum

  Hi everybody, I’m having trouble solving an issue that I’m not even sure is feasible. I have the following scenario: A class library (LIB1) with a class called BaseItem{ int Id; } Another class library that references LIB1 with a class called: DerivedItem : BaseItem{ string Description; } And a Console App that references both. What I need to be able to do is in the console application type: DerivedItem d = new DerivedItem(); Console.WriteLine(Properties.Description); And the output be "Description". What I’m trying to do here is create a dynamic enumeration ("Properties") with all the properties in the class. So in the case of DerivedItem, this enumeration would look like the following: ...Show All

• Visual Studio 2008 (Pre-release) Custom Control, Converter parameters, Trigger using parent property

  Hello all I am trying to create a custom text box which uses the next template: < Style TargetType = " {x:Type local:XTextBox} " > < Setter Property = " Template " > < Setter.Value > < ControlTemplate TargetType = " {x:Type local:XTextBox} " > < Border Background = " {TemplateBinding Background} " BorderBrush = " {TemplateBinding BorderBrush} " BorderThickness = " {TemplateBinding BorderThickness} " > < TextBox x:Name = " txtVal " Background = " Beige " IsReadOnly = " True " Text = " {Binding RelativeSource={x:Static Relati ...Show All

• Visual Basic My.Settings overwritten during upgrade installations

  Hello, Is there a way to keep the settings stored in My.Settings from being "reset" during an upgrade installation Every time I put out a new build of any application using My.Settings the settings in My.Settings are reset to whatever they are in the visual studio designer. Thanks, not the answer I was hoping for but at least it answers my question:) Do you think this is a bug or by design It seems like the entire point of My.Settings was persistance, this sorta defeats that purpose. ...Show All

• Visual Studio Team System Can we print the extracted value from the script

  When using the coded script is it possible to use a message box and give a message to the user what is the value extracted. For example: Dim rule3 As ExtractFormField = New ExtractFormField rule3.Name = "txtLoanNumber" rule3.ContextParameterName = "LoanNumber" MsgBox(rule3.ContextParameterName( "LoanNumber" )) here if i want to know the value present in the LoanNumber how should be the format of the message box Thanks Thanks for the code. I tried the same in my script but it failed, we are using a VB code for the script and the example what you gave may be for VC++ . In case if you can give a snippet of the VB code for the same it would be of great us ...Show All

• Software Development for Windows Vista mcms - VA Error please contact site Administrator

  Hi I got a error in mcms db.( VA Error Please Contact site Administrator ) In my application, i am using Sharepoint 2003, mcms 2002 and SQL server 2000. I using mcms placeholder in portal and retrriving the data's from mcms. in production i got a VA Error some times. Once this error comes full production stop. we have a temperature solution. i.e, There were two process on the mcms db that were bloked. These two were both owned by vzh/rc_admin - one was select command and other a DBCC. When the two processes were killed, the application retured to normal functioning. i need a permanant solution. Please do the needfull Thanks Jenkins Try the “ Where Is the Forum For... ” forum. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. metronome using directSound or directMusic

  hey. i want to code a program that includes a metronome using c++ and directSound and/or directMusic. this metronome should raise an event periodically, it should be as precise as possible and i need to change the tempo at runtime. now what i need is something like the StartTimer (UINT TimerDuration) onTimer(UINT nIDEvent) killTimer() functions in VC++ but with a higher resolution than milli-seconds and with a way to affect the duration between the timer events at runtime, as mentioned above, thus without having to stop and restart the timer... is there a way to use directSound / directMusic in order to achieve this perhaps sth with IReferenceClock:: AdvisePeriodic or does this problem not really have anything to do with ...Show All

• Windows Forms Change the language in the install.msi-file

  Hi I have Visual Studio in english and therefore the language of the .msi-files will be english too. But I need to get them in other languages, maybe even in the system language. Is this even possible -Nattis ...Show All

• Windows Forms Exception occurred during store operation

  Hi, Im deploying a clickonce application using MAGE.exe When I try to run the application on mydespktop I keep on getting the error ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of http://...../myapp.application resulted in exception. Following failure messages were detected: + Exception occurred during store operation. + Value does not fall within the expected range. I used mage -cc and re-run the application and it worked. I then repeated the steps using mage to deploy another application and it did not work. It's not working anymore if I try it all over again despite using mage -cc. Then I copied the directory to another PC and run my.application sev ...Show All

• SQL Server Building a report-dashboard in WSS 3.0 integrated mode

  I have a page with three Web parts; 1. Filter Web Part that uses a BDC-driven list of clients 2. Part showing RDL's from a doclib 3. Report viewer Web Part I can use the Filter part to supply a parameter value to 3. when I select an RDL manually, I can set the Viewer connections to get the Report Definition from 2. But I can't get both options to work at the same time. The reports in 2. all have the same Parameter so there shouldn't really be a problem. Looking forward to any suggestions or a way to provide feedback on the CTP (RS SharePoint Addin). TIA. Ed Hi, I am working on sharepoint 2007 integration with reporting service 2005. There are few facts which i am trying to understand and need some clarificatio ...Show All

• Visual Studio Express Editions Webbrowser Progress bar

  can someone please point me to some code that will trigger a progress bar when a webbrowser control is navigating and return to 0 when complete. Thanks Trucker. It worked great. But the progressbar moves too fast. I found this code http://www.vbforums.com/showthread.php t=390724 and amended it to work with vb2005e. Hope you find it useful.   Private Sub WebBrowser1_ProgressChanged( ByVal sender As Object , ByVal e As System.Windows.Forms.WebBrowserProgressChangedEventArgs) Handles WebBrowser1.ProgressChanged ToolStripProgressBar1.Visible = True Dim p, d, t As Integer d = e.CurrentProgress t = e.MaximumProgress If d <= 0 Then ToolStripProgressB ...Show All

• Visual Studio 2008 (Pre-release) Display ToolTip for TabItem.Header only?

  Does anyone know how to display a ToolTip for the Header of a TabItem without having the ToolTip appear for the entire TabItem.Content Example XAML: <TabControl x:Name="contentTabs"> <TabItem x:Name="tab1" ToolTip="Home Page"> <TabItem.Header> <TextBlock>Home Page</TextBlock> </TabItem.Header> <Frame x:Name="contentFrame" /> </TabItem> <TabItem x:Name="newTab" ToolTip="New Tab (Ctrl+T)" Width="20" /> </TabControl> Why not simply settinng the ToolTip property on whatever element is in your TabItem.Header property It only supports one child so that child could h ...Show All