shama's Q&A profile

• Smart Device Development Debugging of eVC++ 4.0 application on WinMobile 5.0 using VS2005 dummy project

  Hi Friends, I am doing following steps- 1) Install eVC 4.0 SP4 and Visual Studio 2005 on the same machine. 2) Build the eVC 4.0 MFC project and copy the executable to the appropriate location on the device using Remote File Viewer from Visual Studio 2005. 3) Create a dummy project on Visual Studio 2005 (this must be an executable project) for the correct WM 5.0 platform. 4) In VS 2005, open the project properties page and navigate to the Debugging page. Set the Remote Executable to the eVC 4.0 application using the macros to specify the target directory. 5) F5 and things should just work. ...Show All

• SQL Server SQL Server Data Archiving

     I am wondering if there is a quick simple method of archiving partial data from a sql server db Is the easiest method via scripting or is there another more direct method Yes I am new to DBA methods. Any help greatly appreciated. Look at the DELETE statement in Books Online. For example, if you have a date column in the table you can do:   delete tbl where datecol < '2005-09-07'   Note that DELETE removes the data from the table/database so you cannot retrieve it back without having a backup of the database. The command-line options for BCP utility is also present in Books ...Show All

• SQL Server Is there a way around using MAX Statement on Report

  I have a report that due to being unable to find a successful solution across the web relies on me using a value in a box as shown below; =MAX(Fields!budgeted_net_rent.Value) The problem I now have is that I have another field on the report and want to a =SUM on it and it tells me that you can't do that unless it is a header or footer and something about being part of an aggregate function. How can I fool SSRS into placing the value for this field into a sperate box so that I can complete the calculation I need to do. This report uses various drill throughs etc. If it is relevent, the value that I want to perform the calculat ...Show All

• Smart Device Development Inbox transport

  I am experience a problem loading custom Tmail (Inbox) transport DDL on Windows Mobile 5.0 Pocket PC. I used 'TransportDemo' sample from Windows Mobile 5.0 SDK for Pocket PC, located at: <C:\\Program Files\Windows CE Tools\wce500\Windows Mobile 5.0 Pocket PC SDK\Samples\CPP\Win32\Transportdemo> I followed MSDN documentation and setup instructions in 'readme.txt' file located in the same directory: 1) The DLL implements and exports: OneStopFactory object. 2) The DLL created and return the IMailSyncHandler class. 3) The DLL is registered under [HKLM\Software\Microosft\Inbox\Svc\] key 4) Signed DLL with privileged certificate The ...Show All

• Visual Studio Express Editions Find an element in a ComboBox with a list of objects

  I have a class Class clMark as public id As Integer public name As String ............ ............ Public Overrides Function toString() As String toString = me.name End Function Public Overrides Function Equals(ByVal obj As Object) As Boolean If (obj.GetType Is Me.GetType) Then Equals = (Me.id = obj.id) Else Equals = False End If End Function end class And I have a combobox with an array of objects of the clMarca class like this DIM cb as ComboBox = New System.Windows.Forms.ComboBox cb.addRange(<array of clMark>) this ...Show All

• SQL Server SQL Server test to production database migration

  Hi, Is there any tool available to migrate the data from the SQL Server test database to SQL Server production database. Data Migration should be based on a condition which can be given as an input for a table by the user. The dependant tables also should be migrated based on the condition. i.e data subsetting based on the matching conditions. Ex : Salary > 2000 The rows of the table which matches the condition alone need to be migrated for the corresponding table. Also its dependant table's rows should be migrated based on the given condition. Please help me with a tool which can automate this. Thanks, Smitha ...Show All

• Windows Forms Determine mouse XY coordinates for double-click

  The DoubleClick event for a DataGrid is just using the basic EventArgs and not MouseEventArgs. That makes it kinda difficult to determine <em>where</em> it happened since you don't have the coordinates to perform a HitTest check. My MouseUp event is already used to performed a full row selection, so what's a possible go step to solving this ...Show All

• Visual Basic Graph/Chart Controls in VB.Net Forms

  Hi, Can anyone help me with finding good graph/chart controls for VB.Net Forms, Like the ones used in Microsoft Money 2000 or later. Regards check out these: http://www.graphicsserver.com/dotnet/gallery.aspx category=Pie http://www.dundas.com/products/chart/reference/index.aspx Section=new#Version%204.51 ...Show All

• Visual Studio Team System How to use TFS best as a code-reviewer

  Hello, we are using Beta 3 Refresh of TFS along with VS2005 and the Team-Explorer. 1) I should be able to do a weekly codereview. Is there a specialized view for this Getting the whole history, opening each history-element, comparing the version with the previous version takes way too long. 2) I am missing an information: We got two branches. We merge from one branch to the other. When I do my review I would like to be able to see, whether this change has been merged into it from the other branch. Any suggestions Thanks a lot. 1) tf diff $/folder/under/review /r /version:D1/10/2006~T will ...Show All

• SQL Server How to ignore a dimension in MDX?

  So my fact table looks like this: SurveyID ( --> Survey Dimesion) GroupID( --> Group Dimension) StatusID ( --> Status Dimension ... e.g. Complete, InProgress, New) GroupCount (the actual measure) How would I create a calculated member that would return the "overall" count for a specific group in a survey (e.g. ignore Status dimension) regardless if the user is slicing the data by Status or not Thanks again - wgpubs Try this ("ignoring" the status dimension - your exact naming may differ): CREATE MEMBER CURRENTCUBE.MyCount AS '([Status].[StatusID].[All StatusID],[Measures].[GroupCount])'; ...Show All

• SQL Server MStudio Always "helps" me to connect to server

  From database tree I want to open table trigger (I think this problem for all objects). MStudio ALWAYS offer me to log on. Why I would like to open object from the SAME database, not other. Can you provide more detail on exactly what you're trying to accomplish and the steps you're taking. Start with "I launch SSMS". ...Show All

• Windows Forms Draw line between pictureboxes

  I have picturebox added to panel at run time. I need to draw line between pictureboxes and also get their respective tags. The line has to be drawn on the panel by clicking on one picturebox and dragging the mouse and leaving it on the other one. Is is possible  Thanks Nitin  ...Show All

• Visual Studio VS 2005 Crystal Report License

  Anyone from BO... Can we up the 5 report connection limit by buying more If that's not possible, what do I need to do to get more than 5 connections to the report engine. Point me to some information please. Thx, Carl Hello Carl, This can be found on our web site at: http://www.businessobjects.com/products/reporting/crystalreports/net/licensing.asp This covers only the bundled versions and not the full products. Licensing information for our full products is also available from our web site. Keith - Business Objects ...Show All

• SQL Server Grant Select

  I am getting a syntax error in SQL 2005 with the command "Grant Select to user". I get "Incorrect syntax near the keyword 'to'". This worked in the previous version, and according to what I can find in the documentation, it should work in this version. I hope I don't have to specify each table individually. Anybody know any more about this ...Show All

• Visual Studio Install MSDN documentation but Missing Visual Studio Help

  I installed SQL Server 2005 server, then Visual Studio 2005. Studio asked for the MSDN which I installed (Oct 2005 Library I believe, hmm, maybe I should look for a later one ) Anyway everything installed no errors but when in VS and select help (set up for external help window) there is no help for Visual Studio, only for SQL Server 2005. Any suggestions on how to get ALL the help available. Thanks, Jim Did you install the help that came with the VS CDs (There should be 3 MSDN CDs). ...Show All