Michael Bird's Q&A profile

• SQL Server When using FILTER: #Error The function expects a string or numeric expression for the argument. A tuple set expression was used.

  Here is the MDX that I'm trying to implement: WITH MEMBER [Measures].[Filled Order Sales] AS 'FILTER([Measures].[Order Price], [Measures].[Order Price] > 0)' SELECT NON EMPTY { [Measures].[Filled Order Sales] } ON COLUMNS from sales The second argument doesn't look like a set to me - but am I mistaken How could it be rewritten Also, why are the error messages, well, broken I updated to SP1, but still have the issue: #Error The ( ) function expects a string or numeric expression for the ( ) argument. A tuple set expression was used. Is there a hotfix for this Filter function returns a set, so your query can be rewritten as WITH SET [Filled Order Sales] AS 'FILTER([Measures].[Order P ...Show All

• Visual Basic Question on DataGridView Data

  Pardon me for posting twice in quick succession, but I've always found that if I post two questions in a thread, only one gets any attention. I've got a DataGridView where each line displays information from a class called 'Flag', which has a number of variables. One of these variables is a URL for a page that the particular 'Flag' pertains to. But rather than displaying the URL in a column, I'd like to display a clickable link that just says "Video" and, when clicked, opens a new window with the URL. How can this be done The only things I'm familiar with on DataGridViews are .DataPropertyName and .Name, so I don't have any idea how to set all the text for a column to one text value, or how to handle the click event of each ...Show All

• SQL Server Problem with linked server stored proc in a maintenance plan

  Hello there, I have a scenario where I need a few stored procs to auto-execute on an hourly basis so I thought it would be nicely done in a maintenance plan job list. I have experience with this in sql 2000 but I am struggling with sql 2005. I have been struggling with my maintenance plan to successfully run the 2 jobs that it has to complete: 1) execute a stored proc that creates/updates a client in the Client table on the local server (This step works fine without hassles) 2) execute a stored proc that synchronizes this entry with a database on another server. This stored proc works fine outside the maintenance plan, but inside the maintenance plan job it gives me an error : Executed as user: NT AUTHORITY\SYSTEM. Cannot roll back T1. No ...Show All

• Visual C# Element 'ProjectProperty' is not a known element.

  I have this problem: Element 'ProjectProperty' is not a known element. This can occur if there is a compilation error in the Web site. Can anybody help me! Thank's! Hi go and see your web.config probably the projectproperty element is either in the wrong place, or there is something missing in the configsections element Hope this helps ...Show All

• Windows Forms UserControl as Container

  Hi all, Just a quick question and I am sure there is a simple solution but I just haven't found it yet. I know how to make my UserControl a container by using ParentControlDesigner etc. This works fine and I can drag and drop Windows Forms Controls at design time. However, if I add a Panel to my UserControl Class, compile it and then try to drag and drop another control on the Panel, the Panel does not act as a container. So my question is: If I have a UserControl which consist of a single Panel, which is a pretty lame control I know, how can you get the Panel to act as a container at design time Any help in this would be greatly appreciated. Kind Regards AM PS. The UserControl that I have written does not consist of a ...Show All

• Visual FoxPro How to make a web page in VFP

  May I please know what is the easiest way to make a web page using VFP 6 or 7. For a start I may just put some photos and then use a table to accept input from user. Thank you for your help. Rolly Thank you very much for your quick reply. God bless you for helping other people. May all go well with you. Rolly Militar ...Show All

• SQL Server Problems with Roles and sp_helpRoleMember

  I have a database role named gc_stationAdmin. I have a user x who has this role granted him when via Mgmt Studio under Logins. In fact I have 50+ users who have this role. 1) when I execute sp_helpRoleMember I see only 20 users who have this role when I'm expecting to see 50 and user X is not amongst the 20 2) when sp_helpRoleMember is executed AS user X, they only see 1 user with this role (and it's not himself) 3) when I drop user X from Role using sp_dropRoleMember OR using Mgmt Studio under Login Properties, it never drops him according to Mgmt Studio. When I pull up the login properties, that role is still always checked no matter what I do...although he doesn't appear in the sp_helpRoleMember result ever. What is goi ...Show All

• Visual Studio Helpstudio Lite

  When i built my project, it show an Errors or warnings were generated by the Help Compiler. Click here to view the compiler Log When i click the hyperlink, notepad is opened then Warning: HXC6048: No Term defined in tag <Keyword ...>. Ignored. Warning: HXC6048: No Term defined in tag <Keyword ...>. Ignored. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Re-focusing XNA game window

  I am sure this is easy, but I am new to C# and having a hard time re-focusing the XNA window to the front after my splash screen is done.... when the splash screen goes I need someway to call something similar to this.focus....Help please =).. Thanks..... using System.Windows.Forms; ... Form myForm = (Form)Form.FromHandle(this.Window.Handle); myForm.Activate(); worked like a champ thank you very much. You saved me a lot of digging. ...Show All

• SQL Server Converting data question

  I need to combine two columns and copy them to another. One column is varchar and one is decimal (3,0) and the destination column is int. The column of decimal contains only 1 and 2 digit numbers. I need to perface a 0 to the data with 1 digit before combining the two columns. If someone could guide me here, I'd appreciate it. I've been trying to use cast and convert with no success. Hi, Here is the update statement for question: UPDATE yourTable SET DesINTColumn = CAST ( CAST ( CONVERT ( int , VarCharColumn1 ) AS varchar )+ RIGHT( '0' + CAST (DecimalColumn1 AS varchar ), 2 ) AS INT ) ...Show All

• Visual C++ C++ design capabilities

  I want to create software that allows the end-user to create multiple copies of their own buttons on a scanned map which buttons can be rotated 360 degrees and linked to a database. I thus need libraries of code for rotate and also zoom functionality that I can incorporate. Can I get this done with C++ or any of the other Visual Studio programs If not, what software do you recommend C++ is a programming language, and as such one you can do pretty much what you want in -- granted the needed understanding and/or libraries. You should download and have a look at the DirectX SDK, which would allow you to do what you describe, with relative ease. Be warned, though: this will not be a project which you desi ...Show All

• Visual Studio Team System Question with VS 2005 and TFS

  Hello everyone, The organization I work for is beginning a redesign of our website and we're migrating from .Net 1.1 to 2.0. We currently use Visual Source Safe 6.0 for our source control and we barely use any of the functionality outside of checking files in and out (though I'm pushing to change that hopefully). So I've been researching other source control systems and, of course, ran across Team Foundation Server. I've spent most of the day researching the different "role" version of VS 2005 and found that our small development team wouldn't really need that (we have 3, sometimes 4 developers who write the code and then 2 or 3 people who do the HTML mark-up. Using something from the Team Suite might just be overkill). So my q ...Show All

• Visual Basic DeviceIOControl and SCSI_PASS_THROUGH_DIRECT

  Hi, I'm trying to get data from a SCSI Inquiry command in VB. I'm using DeviceIOControl with SCSI_PASS_THROUGH_DIRECT - the call goes through OK and DeviceIOControl returns 0, but I can't seem to get the expected data back - retBytes just contains 7 bytes of seemingly (but probably not) random data: (40, 4, 20, 0 , 40, 4, 20). Changing scsi.dataIn to 0 gets me 255 bytes of data, but not the data I should be getting. Any help would be greatly appreciated. Here's what I'm doing. offset as Byte is ignored for now, and fileHandle is a valid handle to \\.\F:. Private Function getVPDPage(ByVal offset As Byte, ByVal fileHandle As Long) As Byte() Dim status As Long Dim dIn As IntPtr = Marshal.AllocHGlobal(255) Dim dOut As IntPtr = Ma ...Show All

• Visual Basic Visual Basic 2005 Pro (Visual Studio)

  Does VB 2005 Pro support 64bit Net framework Does it ship with SQL Thanks. If you wanted to create anything in a more scenario such as 64 bit applications, mobile application, office add-in application then VB express wont provide the templates. VB Express doesnt allow ASP.NET development For some fo the functionality differences of the versions of VB http://msdn2.microsoft.com/en-us/library/b4z62wxz.aspx So if VB Express works for you great !!!!, If you want functionality thats not included - either make do without or spend some cash. ...Show All

• Architecture Load Balancing of Business functionality in a Distributed Scenario

  Hi, I have a scenario wherein the custom application that I am developing would be installed at 3 different locations. Now based on how the business load is, one system should be able to offload certain part of its work item queue to the other two systems where load isnt that heavy. Sounds confusing. Well let me try to articulate with an example. Suppose I have to process Insurance claims and I have two office within a city which does that. Each office would handle requests designated to their area. Now suppose Office 1 has heavy load of claims to processed and it knows that Office 2 doesnt have any heavy workload, it should be able to offload the same to the other office get it processed and give the result back even though the claim doe ...Show All