Ljhopkins's Q&A profile

• SQL Server Force columns to appear in matrix.

  I have created the report below in SSRS to show the total by month for the calendar year. As of my January running it runs great as there is data for all 12 months of the year and the matrix is created with the required 12 columns. 01 02 03 03 4 05 06 07 08 09 10 11 12 Total AA 17.5 22 17.5 75 30 162 BB 15 15 15 15 15 15 15 15 15 15 15 15 15 195 CC 15 15 15 15 15 337 15 233.3 15 325.5 117 15 15 1147.8 DD 315 290 1231 1231 1231 269 953 384.8 706.8 1798.8 ...Show All

• SQL Server Primary Key Violation

  Dear Friends, I am a DBA and I am getting a lot of table locks due to unhandled errors in front-end developed by Power Builder, 5 years back. The backend is SQL Server 2000 Enterprise edition. Below I will explain the problem in detail. The Big Problem. { O Users enter sales data into rm_salehdr (docid,..,..,..) table (LOCKED) O The rm_salehdr table need a new docid O The new docid will be generated by a function called as docnogen O The docnogen function o will select the last docid from ps_docno table o add 1 to last value o return docid to rm_salehdr o update the last docid with the new value. o ps_docno table will hold the lock till the insert transa ...Show All

• Visual Studio Team System Database Projects and other Team System flavors...

  I'm currently looking at moving to database projects for all of our database code. I've used the older type of database project and though while not nearly as good as the new type, it has many benefits over no database project at all. I would really like to use datadude and have everything in the new database project format, however I need to enable the developers to change the database code. Is an upgrade/patch in the works for the developer version of team system to read the new database projects This is the only thing holding me back from updating the database team to using datadude. Can someone from the team please answer this It looks like from the developer version they could edit individual files, but I'm assumin ...Show All

• Visual C++ After installation of an add-in software, I can not shift+Tab a block of source code ? How can I go back to its previous state ?

  Dear Members After installation of an add-in software for VS2005 , meanwhile it is VisualVSN, and replying a confusing message box produced by this software as Yes, I can not shift+Tab a block of source code How can I go back to its previous state Sincerely Cem DEMiRKIR Maybe you should reset the keyboard settings Try clicking on Tools --> Customize --> Keyboard --> Reset . I hope this helps. ...Show All

• Smart Device Development Problem detecting mobile device processor type via RAPI

  Hi!   I am writing an installation program (in C#, VS2005)   which is installing CAB file using Active Synch manager   on the pocket pc device (Windows Mobile 2003 SE, Windows Mobile 5.0 and Windows CE 5.0). App has to install .Net CF 2.0 and SQL Server Compact Edition (Mobile) CABs on the device. I am using RAPI to communicate with device. In order to install appropriate CAB files, I have to detect device processor or Instruction Set ID as outlined in the “Creating an MSI Package that Detects and Updates the .NET Compact Framework” article. But it seems that RAPI is not capable to do it. And it is very difficult on Windows Mobile and CE 5.0 (for security reasons) to run dll on the device.   Is it any other ...Show All

• Visual Basic run application in back ground

  hi all i have prepared an application which dose not take any user input and the aim of the application is to take screenshots at a regular interval of 5 min i am using vb.net 2005 for this i have taken a form and in that form i have placed a timer control and in timer trick i am calling the function which takes the screen shot my requirement is to set up this application and this should run in the back ground and the user should not be able to cancel or stop the running of the application can any one suggest me how to do this the application should run in the background it self and this should start when ever the system boots this is showing a following exception of "the handle is invalid" when i start th ...Show All

• Windows Forms How to get a scroll bar to scroll down a large programme.

  How do I make a VBscrollbar scroll down my programme. I have it docked in the form but I need it to actually function. Thanks. A panel and form has autoscroll property that you can set so you don't have to add scrollbars manually. Are the contents of your program manually drawn or just widgets ...Show All

• Visual Basic Array Help

  Hi, This may be a very basic problem but im haveing real trouble with it and its driving me crazy!!!!!!! I have created a class called Class1 I can create a new object by calling Dim test2 As New Class1 I can change its attrributes by test2.summary = True test2.is_stage = False etc..... Now what I want to do is store this class in an array. I have tried the folowing code but it doesnt seem to work Dim proj_tasks(10000) As Class1 proj_tasks(counter) = test2 This keeps erroring and I dont know why! Can somebody help me out! Also if your feeling very generous could you please adivise me on how I could make this a dynamic array rather than having to set the array to a huge size in the first place ...Show All

• .NET Development System.Net.Socket disconnect problems

  Hi, I've done some searching but haven't managed to find an answer - hopefully this is the correct place to post. A group of us are writing an internet chat protocol with associated server and client. The server is written in VC++, and goes through a specific chain of events if the OnClose() function of one of the CAsyncSockets is called. For one of the clients in development (realbasic on mac OS X) this works fine - they close the connection at their end, and the server picks it up. However, for the VB.NET version of the client we are having problems. No matter how we disconnect, the server doesn't realise that the client has gone. I can only assume this is a .NET related issue as the other client does work. Has anyone got ...Show All

• Commerce Server Discount Question

  Hello, I looked at the types of Discount and I didn't see any that could do this: Be one of the first 100 users to place an order and get 4% off your first order. I understand we can set an end date, but can we set a max number of time the discount can be used Thanks for your help. Pat Hello Patrick, I think that there is not such a Discount Type. The only Discount type that seems to be similar to your resquest is the Simple Discount type. So when you define you discount with the discount Wizard, In the Discount value step, choose Percentage off option and enter 4 in the textBox In the Order limit step, choose Number of times this discount can be applied option and enter ...Show All

• Software Development for Windows Vista Major Compile Error

  I am running 3.0 with 2005 Team Suite and I have installed the extensions for WF. I have downloaded the samples but when I try to compile them I get the following error. I need help figuring this out. The "CompileWorkflowTask" task failed unexpectedly. System.NotSupportedException: The given path's format is not supported. at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copy ...Show All

• SQL Server R

  How do i replace that character in a derived column Some rows have that character in one or more columns. If i just write this column == "" Unknown : column where the character is inside "" (can't write it here) the task will just succes without ever doing anything. The output says something like "the dataflow task had no tasks.....", which seems like a bug. Let me know if using Unicode escape sequence as follows works for you: CENTRE == "\x0002" "Unknown" : CENTRE Thanks Mark ...Show All

• Visual C# automagically adding "" {} () [] etc...

  I was at an MSDN event yesterday and the presenter enabled a setting in VS2005 that would automatically add a pair of quotes "" whenever the context was expecting it. I have looked in my options of VS2005 standard and I can't find an options which does this. I have found options which purports to automagically add braces {} when a new line is typed I.E. class MyClass { <these added when new line (enter key) typed. } However my system doesn't do this. Is there a master setting somewhere that enables these enhancements Thanks Edwin Edwin - Other than you, we've heard significant feedback that users want this feature. It's something that we're definitely trying to do and hope to see in ...Show All

• Visual Studio 2008 (Pre-release) XNA (Managed DirectX) inside WPF

  I am delighted with Windows Presentation Foundation. There are automative layout, animation and so on in there.. Still it's slower then XNA after all. I have to visualize CAD-geometry. I tried to use WPF directly and failed. It was too slow. I can host an WinForms control and initialize XNA on it. But WindowsFormHost have a lot of problems and doesn't suit at all. I see another way to solve this problem. I want to extend WPF. For example I would inherit Brush or another class to draw the content myself using XNA. How I can do something like this   SerialSeb wrote: Simply put, it cannot be done. WPF is a directX surface, just like XNA, and there is no interop scenarios supported at the mom ...Show All

• SQL Server cannot rename instance of analysis server.missing reg key

  when i use the rename instance tool i get this error saying it cannot find the regestry key hkey_local_Machine\wow6432Node\Microsoft\Microsoft Sql Server\90 When i look for this key, it doesnt exist. My installation went perfectly. what is going wrong There are 2 versions of ASInstanceRename utility. Make sure you use one that is installed with 64bit version of Analysis Server. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All