Glint's Q&A profile

• SQL Server Hide some columns in Matrix but not in subtotal

  Hi all, I would like a matrix that look like this: 2006/01 2006/02 2006/03 Total % % % % Amount Amount Class. BU1 98,82% 78,53% 88,12% 88,49% € 217.763.099,50 € 207.328.766,75 BU2 64,98% 32,53% 92,19% 63,23% 5.093.781.522,65 € € 287.731.766,75 BU3 74,71% 45,78% 78,69% 66,39% € 847.871.349,50 € 819.123.124,75 I want detailed subtotals but I don't want the "Amount" and "Amount Class." values in the details of my Matrix. I've not found other w ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. AccessViolationExcpetion

  I have a really weird and annoying error appearing. Basically, I'm following the Hazy Mind engine tutorials for XNA, and I can't get post processing working correctly. I get this error occouring An unhandled exception of type 'System.AccessViolationException' occurred in Microsoft.Xna.Framework.dll Additional information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. This does not always happen in the same place though, if I turn off code optimisation, it happens in the line above. I have run Windows Memory Diagnostic and my memory seems fine. Here is the code public void ResolveAndRender(GraphicsDevice myDevice) { myDevice.ResolveRenderTarget(0); myDevice.SetRenderTa ...Show All

• SQL Server Unintended rounding problem

  Hi, I'm having a problem with unintended rounding of decimal values which I'm retrieving from a SQL Server 2000 table. The table contains a decimal column defined as 9(16,8), and which contains values very close to 1, such as 0.9996. The problem is that when the query executes from within our application, the recordset contains 1, whereas we were expecting to receive 0.9996. As you'd expect, this is causing problems in our app. Our app is a legacy VB6 application connecting to SQL Server 2000 via Microsoft DAO 3.6 (dao.dll, 3.60.3706) using the SQL Server 2000 ODBC provider (sqlsrv32.dll, v2000.85.1117). Platform is Windows XP, SQL Server is running remotely. Any help with this would be greatly appreciated. Cheers, Mark ...Show All

• SQL Server Determinism of UDF

  I'm having a problem getting SQL to recognize a UDF as deterministic so I can use it in a persisted, computed column. I'm using INFORMATION_SCHEMA.ROUTINES to check the IS_DETERMINISTIC value and it is always NO. Why isn't the following UDF deterministic ALTER FUNCTION [dbo] . [SecondsToTimePart2] ( @part CHAR , @seconds INT ) RETURNS INT AS BEGIN DECLARE @hours INT , @minutes INT SET @hours = @seconds / 3600 IF @part = 'H' RETURN @hours SET @seconds = @seconds - ( @hours * 3600 ) SET @minutes = @seconds / 60 IF @part = 'M' RETURN @minutes SET @seconds = @seconds - ( @minutes * 60 ) RETURN @seconds END It does not use any DB objects, flo ...Show All

• Visual Studio 2008 (Pre-release) Inheritance of types used as DataContract

  Hello, I have a service interface ( IMyService ) with a method ( DoSomething ) containing a parameter of a "general" type MyObject . Furthermore there are some types inheriting from this type MyObject. [ServiceContract] public interface IMyService { [OperationContract] void DoSomething(MyObject obj); ... } [DataContract] public class MyObject { private string _myParam [DataMember] public string MyParam { get { return _myParam; } set { _myParam = value; } } } [DataContract] public class MySubObject : MyObject { private int _myNewParam [DataMember] public int MyNewParam { get { return _ myNewParam ; } set { _ myNewParam = value; } } } ...Show All

• Microsoft ISV Community Center Forums Adding a command button to the toolbar or menu bar in Excel?

  Hi I'm wondering is it possible to add a command button to the toolbar or menu bar in Excel using VBA I came across an excel file before in work that somebody had setup this way but not sure how to go about it! I basically have two buttons that I would like to have added to the toolbar or menu to make the sheet tidier and enable the user to see all the data without having to move the buttons etc. http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_buttons.jpg Any ideas folks Thanks, Scott There's code below that shows you how to do it. There are a couple of points worth noting. 1. When the workbook opens you need to build the command bar and add it to Excel's b ...Show All

• Windows Search Technologies Searching for DIM2002 versus [account]:DIM2002 (Outlook 2007/WDS3.0)

  Hi, I use the "account" field in outlook to store customer numbers. When I use instant search to search for an account "DIM2002" it returns no results. However, if I use instant search to search for [account]:DIM2002 it does return the results. Is there a reason that it won't return results on just DIM2002 Does it just need more indexing time Does my index need to be rebuilt or something Thank you. -John Hello John, This situation exists by design. The intent is to prevent users from getting search results that they may not be understand (as can happen when fields that are not often used are displayed in standard search results). Outlook currently searches a fixed set of properties by def ...Show All

• SQL Server Problems installing Reporting Services

  Hi Folks, I want to download Reporting Services for SQL Server Express Edition but I can't find it. It seems to be in Analysis Services but when I run SQLEXPR_ADV.EXE I don't find any mention of Reporting Services. I get to the final options choice which offers me 'Database Services' and 'Client Components' but neither of these mentions Reporting Services. I have installed BI Studio successfully. I'd be grateful for any and all suggestions. Thanks a lot. Barry Hi Andrea, Thanks for your reply. Unfortunately, you told me what to do but not how to do it so I couldn't follow your advice. Barry ...Show All

• SQL Server sql server agent service failure

  Hi all, I'm new to sql server administration so please show some understanding! I installed sql server 2000 personal edition (upgrated to sp4) on an windows xp pro OS, but I cannot get the sql server agent service  running. I get a message " the service did not start due to a logon failure". The server is my local pc , I'm using windows authentication and the login is "domain/loginname" where domain is my pc name. Does it have to be installed on a server OS to have this service running   Thanks George Hi, ensure 1). User Account used to start SQL Server Service have correct password! Do you change the password in recent 2). The Domain and Workstation (your pc) have trust ...Show All

• Visual C++ Weird compiler error related to function template argument deduction

  Hi everybody. I have just found a compiler error that is driving me crazy. I can not guess what is going on with this: //****************************************************************************** struct Dummy { void CallMe(const int i) { //WhatEver... int a = 43; } }; template <typename T> struct Test { template<typename R> void Function(R* pInstance, void (R::* TMemberNonConst) (T param)) { //WhatEver... int a = 43; } }; int _tmain(int argc, _TCHAR* argv[]) { Dummy dummy; Test<const int> test; test.Function(&dummy, &Dummy::CallMe); //Error.... } //*************************************************************************** The compiler says: error C2784: 'void Test&l ...Show All

• Visual C# Keeping the arraylist value to the next program run.

  Hi, I have built a C# program that processes a huge amount of data and keep the processing results in arraylist. This is takes a long time , so if I need to keep these results to be used in the next time , How can I do that. Is there any way Thanks too much. Aya. The best thing you can do is by serializing the full List with een Xml Serializer or Bineary: How to serialize an object to XML by using Visual C# . More information about serialization can be found here: .NET Serialization, Part 1 .NET Serialization, Part 2 XML Serialization in C# XML Serialization in .NET XML Serialization Using C# Customize XML Serialization using IXmlSerializable ...Show All

• Visual Basic Show Pictures in rows (e.g. Emoticons)

  Hello I have a number of small picutures and all of them has the same size. How can I show them in rows in VB2005 Look at this picture: http://www.onh1986.3000mb.com/vb.jpg And when I click one, I want to show it in a separate picture box. How can I do it   Thanks Not sure what you mean... Each time the user clicks on an icon in the ImageList, what do you want to happen Do you want to add that icon to the image in a PictureBox, putting each image in a line or a grid Please explain more... ...Show All

• Software Development for Windows Vista Generic Workflow Host

  Dear all, Just want to know is it possible to write a generic Workflow host which allows users to: 1) pick and browse for a pre-designed workflow file (from the file system) 2) then change some of the rules 3) Run the workflow or we need to design an indvidual host for different kind of workflows. My concern is whether we need to re-compile the host or the workflow in case of any changes to the workflow rules. For example, the auto approval amount. Andy Andy - I think what you are proposing is possible. Generally a Host (or services in the host) need to be aware in some way of the workflows that are running - but if all your users are changing are the rules - that should work fine ...Show All

• .NET Development Setting up events in Remoting takes more than 20 seconds.

  I use a server and several clients - all of them run on the same PC (Visual Studio 2003). The client invokes a method in the server that in turn raises an event to all the clients. (I used Ingo Rammer's book on Remoting as a reference). I use tcp channel in binary format. It works. The problem is that the first time a client invokes the method that raises the events it takes over 20 seconds (sometimes it doesn't take time at all). I profiled my code and since the event is raised in the server till the client catches the event it takes 20 seconds (I put breakpoint in the line in the server that raises the event, and the first line in the client's function that is invoked - no other user threads). After the first invocation of the ...Show All

• Smart Device Development sync problem

  when i on my motorolla mpx220 mobile phone it gives a msz your phone running with low memory.and then the phone become hang. it also not allow now via usb sync with my pc.it also give a msz that ur divice is menufecture but windows can not recognize. what can i do to use my phone. Check the space on the SD Card. Are you able to establish a connection via ActiveSync What version of ActiveSync are you using As per this link http://www.motorola.com/motoinfo/product/details.jsp globalObjectId=53 Motorola mpx220 is indeed a Windows Mobile based phone. Manav ...Show All