Worf's Q&A profile

• SQL Server Problem on comparing strings

  Hi All, I've problem on comparing strings with the following SQL statement: select * from events where venue = 'myhome' where venue is of type varchar(50) The above SQL should return something (i.e. I've 3 events hold at my home!) but it return 0 rows. Please kindly help. Thanks, stard may be your column valeus have carrage return (ascii 13+10 = \r\n) character.. When you see the result in GRID VIEW on Query Analyzer you wont find this character.. You can apply the following statement on select.. select * From  Events Where replace(Venue,char(13)+Char(10),'')= 'MyHome' or select * from events where venue LIKE  '%myhome%' -- It may return unexpected additio ...Show All

• Visual C# In that case...

  Does anyone know the best way to create hot keys for menu items in an mdi parent form programmatically Struggling a bit with this one. For example, ctrl + n - fires an event. You can use this as well : protected override bool ProcessCmdKey( ref Message msg, Keys keyData) { if (keyData == ( Keys .Control | Keys .N)) { ... } return base .ProcessCmdKey( ref msg, keyData); } But for a menuItem the above might be the thing to do. ...Show All

• Visual Studio textbox: \n or <p> or vbcrlf or #13 or ... ?

  Using ASP.NET C# 2.0. 1) One of our reports is a business letter. I have a query that returns "letter body." but I don't see how to specify the breaks between paragraphs (There are 6 different body content that will display, each with different length of and number of paragraphs.) Please let me know any options for generating these letters in ASP.NET 2.0 as PDF. Thanks, Kim STATUS: For the PDF letters I've decided to go with Dynamic PDF, which we are getting for other projects anyway. The free download is fully functional: http://www.cete.com/Products/GeneratorForNET/ This probably is more logical anyway, since these letters don't have header, footer, detail data, ...Show All

• SQL Server unique problem

  Hi friends I am currently working on a project using miscrosoft sql server 2005 analysis services I faced a unique problem on the day of UAT wat i found was that after processing my cube sucessfully when i was going to the browser wiindow the entire screen was coming but when i was pulling facts across dimensions there was no data coming in any of the facts. i checked the perspectives..re inserted the dimensions in the cube structure and re inserted the facts ..checked in the data source view whether the facts are properly connected with the dimension and then re processed the cube ...but again the same old problem Then panic struck me and without wasting more time i re made a new cube with the same dimension and same facts and the new cub ...Show All

• Visual Studio How to determine if a project is built

  Hi there, Does anyone know how to determine if a given "EnvDTE.Project" has been successfully built What about a particular "EnvDTE.ProjectItem" Thanks. Thanks very much for the feedback. I am aware of "Solution.LastBuildInfo" but was hoping I could inspect things at the file level. I'm almost tempted to check the source file date against the target file date but it's not official so I can 't rely on it without MSFT's blessing. Could you ask your contact if this is safe. I assume it probably is but if so, I would then need to know how to get the name of the target ".resources" file (it's a little more tricky for form-based ".resx" files since the target name is built using the name o ...Show All

• SQL Server Incremental update of dimension?

  With the fact table one can use the "process incremental" option to add new factdata without having access to all the old data. Is it possible to do something similar with dimensions I.e. add new dimension members without having to store all the old ones for rereading with "process update" The process option UI and documentation seems to agree that it can't be done. However a quick googling found some microsoft paper promising incremental updates to dimensions as well, leaving me slightly confused. Thanks - that was exactly what I was looking for. Oddly enough the options mentioned in your document doesn't correspond to those in the help here: http://msdn2.microsoft.com/en-us/library/m ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Error message when dowloading

  Hey all, I'm trying to download 9.0, but it gives me the error message, "the cabinet files necessary cannot be trusted." Does anyone have any idea how to fix this I'm going crazy here. Thanks I opened up the command prompt but couldn't stop and start the service. Should I type that within the C (default) drive What abbreviation should go before "net stop cryptsvc " ...Show All

• Visual Studio 2008 (Pre-release) maxClockSkew on wsHttpBinding

  I have a service using a wsHttpBinding, looks like this: < bindings > < wsHttpBinding > < binding name = " MyBinding " > < security mode = " TransportWithMessageCredential " > < message clientCredentialType = " UserName " /> </ security > </ binding > </ wsHttpBinding > </ bindings > Then I have a couple of services using this binding. Works perfect! BUT! I need to accept that client clocks differ with more then 5 minutes. I have seen how this can be changed on custom bindings, but it doesn't seem to work with my wsHttpBinding. So, is there any way for me to change this parameter I would prefer if it was possible to only set it on ...Show All

• Visual C# How can I edit the OCXs' properties in the form [design] (not in the editor) while the app is running?

  I'm running a C# project in VS2005. If I make a small change to one OCX's property such as a textbox's visible property in the editor while the client is running in debug mode I get a dialog box saying "property value is not valid." This option is enabled in my IDE. I have to hit "OK" and then press stop the app in order to edit. editing. This is happening at least 100 times a day and it is just too frustrating at times. This wasn't the same in VS2003, it would let you edit and would remind you to either continue execution or restart the compilation. Is this still available with VS2005 Please let me know if you have any good idea about this. Yes, I see you rewrote your question... I'm not sure what yo ...Show All

• Windows Live Developer Forums Bounce on feedback email

  Nice. I installed the Search SDK and was greeted with an install complete message that included a comment like "We would like to hear your feedback regarding the SDK documentation and examples" referring to the email address msrchdocf@microsoft.com . Sending mail to that address is promptly bounced with a 550 error (user unknown). ...Show All

• Microsoft ISV Community Center Forums Updating text in a text box on an Excel Graph

  I am automating a spreadsheet, designed by someone else, which has 18 graphs on a worksheet. Most of these graphs have a text box on them which indicates the week commencing that the graph refers to. The text box appears to be a shape object on the chart. I want to loop through each chart on the sheet, then loop through each shape on the chart, and change the text if the shape is a text box. Can anyone put me on the right track, I did try using the macro recorder to get me started but this code does not work in my VBA module. Then this should do it: Option Explicit Private Sub Workbook_Open() Dim ws As Worksheet, o As ChartObject, c As Chart, s As Shape Set ws = Me.Worksheets("Sheet1&quo ...Show All

• Windows Forms ToolStripLabel BackColor not displayed

  Hi! I have following issue with ToolStripLabel: 1. Create a ToolStrip in design view (VS 2005). 2. Add ToolStripLabel control. 3. Change BackColor property of that ToolStripLabel control. When I run it I do not see the BackColor I selected. Thanks, Edijs The ToolStrip and its controls are painted by one of three built-in renderers. Only the "System" renderer allows you customize the label background color. Set the RenderMode property of the ToolStrip control. ...Show All

• SQL Server Connecting to SSAS on workgroup W2K3 server using SQL Server Management Studio...how?

  Hi All, I'm trying to connect to SSAS on a workgroup (i.e. non-AD) Windows 2003SP1 server from my XPSP2 PC, using SQL Server Management Studio and/or Visual Studio, with no luck. I have set up SSAS to accept anonymous connections, firewall is off, no anti-virus software, etc. I have added 'Everyone', 'NT Authority\ANONYMOUS LOGON' to the SSAS 'server' role (I don't care about security at this stage). I can connect to SSAS from my PC via code , though I have found out by trial-and-error that I need to specify a connection string that includes a User ID and Password; e.g.: "Data Source=sandbox; Provider=msolap; Initial Catalog=Analysis Services Tutorial;User ID =some_user; password= password ;" When I try to connect ...Show All

• Visual Studio 2008 (Pre-release) C# / Object Experts - Why Does this Code Work ??

  In playing around creating buttons, I cam up with the following code which I thought would generate an error. Specifically I thought re-declaring btn would either trigger an error, an object with the same name had already been declared, or that at least when the 'new' btn was declared, the 'old' btn would be destroyed. The hashTable here has 5 items, 5 buttons are displayed on the form, and all 5 are available to "ButtonOnClick". I would have thought that if no error were generated, only the last btn would still be in existance and available to "ButtonOnClick". Does the btn object go out of scope anyway after the "stack.Children.Add(btn);" line IDictionaryEnumerator enumerator = hashtable.GetEnumerator(); ...Show All

• SQL Server Inconsistent OLE DB Failure when running SSIS packages

  I have a series of SSIS packages which populate 12 different databases. Which data source & target they use is controlled by values passed down from the SQL Agent Scheduler Job Step using "Set Values" These values are passed to Variables which are used in the Expressions in the connection manager for the database to change the connection string and initial catalog. e.g. REPLACE( @[User::ConString] , "Royalty", @[User::RoyDb] ) These jobs run successfully the majority of the time but each day I get a significant number of failures where one or more target or error trapping table cant be found. They are all using the same connection manager and most of the tables in the database get updated correctly but the ...Show All