Jeff Hosley's Q&A profile

• SQL Server Previous Row Calculations (sql server 2000)

   if anyone know a way that you can look up a value from the previous row in a View to do a calculation on (in sql server 2000) for example: expr1=PreviousRow.Expr1/30 + expr2 - expr3 =100 so the next row is expr1=100/30 + expr2 - expr3 =300 so the third row is expr1=300/30 + expr2 - expr3 =100 or tell me if it not possible please and special thanks to Umachandar Jayachandran - MS for help. Hi, Im not quite sure if this is possible in a view. But you can do this in a stored proc. You can use a cursor and manually traverse your records...     cheers, Paul June A. Domag ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Transparent textures again

  Hi, I'm bringing the transparent issue once again to this forum, mainly because after of doing a lot of google searches, forum searches, etc, I still can't get transparency to work. I've created a png file that has transparency. I know it is correct, because I've opened it with the D3d texture viewer, and I can see the alpha channel. I've created a simple object and assigned the texture to it in 3ds max. I've loaded the object but the transparency isn't working. I'm already tried SetRenderState(D3DRS_ALPHABLENDENABLE, TRUE). I'm rendering with DrawSubset(). Any ideas Thanks SetRenderState(D3DRS_ALPHABL ...Show All

• Software Development for Windows Vista Internal Statement Parser

  In spelunking the WorkFlow dll's I have noticed a Parser (System.Workflow.Activities.Rules.Parser to be exact) class that is used by the RuleSetDialog and RuleConditionDialog to parse the rule condtions/action text into CodeDom expressions. It is also used to provide Intellisense support etc... Is there plans to make this class public It would allow developers to more easily write custom rule editors, as well as write in-code rules easier then handcrafting the CodeDom expressions by hand. BTW: I have created a wrapper using relection that exposes the internals of this class, which I could post in case anyone was having similar thoughts/issu ...Show All

• SQL Server Slowly Changing Dimensions Errors (volume related?)

  Hello, We are having issues with SCDs that appear to be volume related. Small dimensions work fine. Pasted below is the last few lines of our package run without any contention (We get different errors at different time with contention referring to buffer or virtual memory). It seems to be calling out the SCD main task but just gives a number and not much of a description. 2) For the errors referring to a buffer ( I can paste them also but did not want to put too much at once); we have the "BufferTempStoragePath" pointing to a drive with lots of space. We have tinkered with the DefaultBufferMax Rows and Size but that seems ...Show All

• Architecture biztalk and the System Messaging namespace

  When communicating with Biztalk, does the System.Messaging namespace seem a good place to start writing objects The Global Bank example seems to use its own mechanism for Biztalk and uses the namespace for MSMQ only. Is there a reason for this Thanks for any advice Jason I don't understand my problem either! I couldn't figure out why the Global Bank doesn't use System.Messaging for its communication with Biztalk and seems to use its own. Even if I use a file or soap port on Biztalk, the messages I receive and send could be manipulated using this System.Messaging objects (or at least I think ...Show All

• SQL Server DTSX package continues to throw errors when working with large dataset.

  I have a dataset that is between 40-50K records that has to go through a process that is pre-defined. SSIS works just fine with the smaller sets even up to 20K but this job keeps blowing up saying something along the lines of cannot write to recordset destination. Does this make sense to anyone The sever is a 2 processor with 2GB of ram. Physical memory usage spikes to about 1.6GB during the run but the processor never really gets above 30% usage. Does this product just not scale yet I'd be interested to see the full error message. Depending on how wide the buffer is, trying to stuff that many rows into a v ...Show All

• .NET Development error CS0136 while using XMLSerializer

  I am writing a single-user application In VS2005 beta2. In order to ensure a simple file-handling I decided to use XML-Serialization. So I have an object that contains of some simple types and a collection of a class which itself consists of some simple types and a collection.. there are 4 levels of deeper going information. I can post the declaration if needed. At this point Dim Formatter As New XmlSerializer( GetType (clDatasetsSerialize)) I get an error message which I do not really know how to interpret. I changed the code from XMLSerializer to BinaryFormatter. That one works perfectly. So the error seems to be in the Serial ...Show All

• Windows Forms Form generates MouseEvent upon Showing?

  It appears that when a Form is created (or perhaps "Show"n), it generates a MouseEvent. Is this correct If so, is there a way to disable this feature/nuisance I checked the MSDN Library, but I did not see any solutions. Thanks. are they mouse move events That would seem the most likely to me. If so, is it possible to only wireup the mouse move events at the end of your form load event ...Show All

• Smart Device Development The target device does not have a compatible version of the CLR installed for the application you are a

  Error Message: "Unable to load the CLR. The target device does not have a compatible version of the CLR installed for the application you are attempting to debug. Verify that your device supports the appropriate CLR version and has that CLR installed. Some devices do not support automatic CLR upgrade." The Device is running Pocket PC 2003. And has been running programs written with .Net 2003 I just loaded .Net 2005 and ActiveSync 4.1 and created a little test program to deploy onto the hand held. I get the above error. Any help/hit would be greately appreciated. Thanks, Joe That means NETCF V2 i ...Show All

• Visual Studio Team System Difficulity in viewing test results summary

  Hi all, I have following inconveniece when I want to view my test results. 1. I have several test runs, and each one have one or more test cases. All these test cases are different. 2. After each test run completes, I publish the test results. 3. In the Test Runs view, I see those completed test runs. But I can only select ONE test run each time to view the test results in the Test Results view. My expectation is to see ALL the test results for one build at the same time, and I can group them by project, or results, etc. (This group feature has been provided in Test Results view as I know). If users can select multiple ...Show All

• Visual Studio Team System Problem with MSF Agile Process Guidance template customization

  Hello, I have tried Randy Miller's cookbook about customizing MSF for Agile SD in VSTS Beta 2 ( http://blogs.msdn.com/randymiller/archive/2005/03/17/398419.aspx ) but it is working only in the folder with the exported framework templates. When I try to return it to the VSTS via Process Template Manager, everything goes well until the showing the Process Guidance web after the successful creation of the new team project. Then I receive IE Scripting Error: Line: 667 Char: 3 Error: The download of the specified resource has failed. Code: 0 URL: http://...(project site).../Process Guidance/Supporting Files/processGuidance.htm Everything is ...Show All

• Windows Forms How to capture circled text from a label

  I am using the tabletpc sdk and .Net 1.1 framework.  I have a frame with a couple of labels on it.  On one of the labels I have some text.  I want to figure out what texted on a given label has been circled.  Any help or suggestions would be greatly appreciated. Thanks ...Show All

• Windows Forms Copying project to another computer - won't work b/c of 'Microsoft.Office.Interop' not being found...

  Hi all,      I transferred a project to another computer so another developer can take over the application.   Everything is working perfectly except when compiling it gives the following errors in the task list: 1) Namespace or type 'interop' for the Imports 'Microsoft.Office.interop' cannot be found 2) The referenced component 'Microsoft.Office.Core' has an updated  ...Show All

• Visual C# C# program to a Windows palm desktop

  Hello everyone, Can someone tell me if I need to do anything special when publishing my Visual C# .NET application to make it work on a palm desktop I am not really sure about it, and so far, not able to test it, it really just have to work, so can anyone tell me what I should look out for to make it work smoothly and perfectly without errors, would all the errors also happen when I try to run the application on my computer Thanks Bullzhot - There are a bunch of smart device development forums where you'll find a lot of information for programming Pocket PC's. Check them out here: http://forums.micro ...Show All

• Windows Forms Bug in Object.Equals method.......?while comparing boxed object...

  I don't understand whether its a bug or not... Consider this code. int i=1; int j=1; Object ii=(Object)i; Object jj=(Object)j; 1) Console.WriteLine(i==j); 2) Console.WriteLine(ii.Equals(jj)) 3) Console.WriteLine((Object)i==(Object)j); Resuls: 1) True. 2) True 3) False Why its giving difference result for == operator and Object.Equalse() method while comparing object after boxing(ie int are type cast to Reference types) but for correct Reference type objects both == and Object.Equalse() method gives same result. No, I don't think it's a bug. When you c ...Show All