ADHDsowhat's Q&A profile

• SQL Server Can I get a Query from a Fetch_cursor in SQL2000

  Hi, The main application we used uses prepared cursors when running statments against the database. This makes it very hard to debug the querys as if you get an error or lock on the database all you can see is the Fetch_curror statement and the number of the statment. If you know the lock is coming that's fine as you can run up the profiler but if you don't know it will happen then the profiler doesn't help as the cursor has already been prepared. Is there a way of using the cursor number to query the SQL engine and find out what statment was prepared If your app is doing server side cursors and names them then you may be able to use sp_cursorlist, sp_describe_cursor_tables and sp_describe_cursor_c ...Show All

• Windows Forms i want to add all the integer value of the datagrid row

  i want to add all the integer value of the datagrid row. how can i do this.. thanks If you are bound to a datatable you can use datatable.compute ("Sum(YourColumnName)",nothing) otherwise you will have to loop through the rows and create a total manually ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT won't set LoopEvent property

  Hi, I have a problem getting sounds to loop from within XACT. I open my project, open the Sound Bank window, select the sound name and highlight Play Wave - this causes the Event Properties panel to reveal LoopEvent, amongst others. Now, when I try to open the combo box to set "No" to something else, I get a dialog saying: "Object reference not set to an instance of an object." So, two questions: 1. Is there a way around this bug in XACT 2. Preferably I'd like to set the sound to loop from within my code. Is there a way to do this in Beta2 Many thanks =) Mark Hi, As far as I know this is a machine specific problem and it simply cannot be reproduced in every co ...Show All

• Windows Forms Newbie with uninstall and update questions

  Hello, I am a complete newbie when it comes to VB and VB Express Edition. My issue with my app is twofold: 1.) when uninstalling the app, only the start menu shortcuts are removed. The files and folders are not. Is there way to force these files to be removed 2.) when auto-updating the app, I either need to have it delete the old files, or find a way to change the "home directory" setting in IIS automatically. Are either of these possible with the express version If so, how do I go about implementing the changes well I just got my copy of Visual Studio Standard installed and have been playing around.  Now I am having two issues: 1.) simple... how do I a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Custom DirectSound Effects

  Hi, I would like to know if it is possible to create new directsound effects using C# code. I am interested in using the directx SDK to create a music synthsiser. In order to do this I will have to route the audio from a secondary buffer through my own DSP classes. Is it possible to route audio in this way using directx and C# I see that it is possible to create new effects (to compliment the existing effects) using C++ and a DMO wizard - is there an equivelant in C# Thanks. ...Show All

• Visual Basic Statup in Vb.net 2005

  I'm not able to assign Sub Main() as the start up for my windows project in VS 2005. It is taking a form by default. Is there any way of calling sub Main as startup instead of the form My application uses methods in a library (.dll). In VS 2003 I could 'Step Into' the code of added library while debugging. How do I do it in VS 2005 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. About Updatesurface

  In my program I need update texture Frequently, So I use a off-screen-plain-surface(created in D3DPOOL_SYSTEMMEM) , and a Texture(used for rendering, created in D3DPOOL_DEFAULT),in every frame, I lock this surface, write data into it and unlockrect,then use UpdateSurface update the texture with this surface,finally render scene with the texture. but I noticed a 'problem':between I updated the texture and presented the backbuffer,if I changed the surface,the texture changed too,like this copy picture1 to off-screen-surface update texture with this surface pd3ddev->beginscene(); render scene with this texture pd3ddev->endscene(); copy picture2 to the same off-screen-surface pd3ddev->present(); In a ...Show All

• Visual FoxPro Combining mutltiple PDFs into one

  HI, First time posting a question. I have been asked to do the following. Take mutliple already existing PDFs and combine them (not worried about the order right now) into one PDF using vfp6. Is there a way of doing this or if you could tell me where to look for information on how to go about doing this would appreciated Thanks Pbriggs1 If your pdfs are generated with REPORT FORM command you may use the option NOPAGEEJECT to print all reports in one pdf file, but I used only with vfp 8 and preview is not possible.(Preview is possible in version 9) http://msdn2.microsoft.com/en-us/library/ms965464.aspx You may use to combine pdfs: http://www.download3k.com/Business-Finance/Office-Suites/Downloa ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. volume texture mipmap

  Hello. Here i would like to ask about oon how to change the level of the texture. Let say i have dds file that contain volume texture with 10 mipmap level. then later i need to print certain level only. for the first time, i create volumetexturefromfile by only specifying that there is only 1 level. so the program can actually display the first level. but later when i change it into 0, meaning it automaticaly create full mipmap chain, then there come the problem. I dont know how to display different level of mipmap. and by specifying level to 0, i dont see the first level show up when i use settexture to display the mipmap. Can somebody please teach me about this. i try to find some tutorial regarding this but there seems to be la ...Show All

• Windows Forms app control using only keyboard

  Hi! I'm working on an windows form application that has to be controlled only with keyboard. I have a form on which a have some controls (2 rows of 3 controls) similar to buttons. What i would like to do, is to move with cursor keys between these controls and when a cotrol is currently selected it should highlight and when i press enter it should execute a piece of code. The problem is that i can't capture the cursor keys. It seem that i can only move between controls by their tab property. It seems like the form is handling the cursor keys by it self Best regards, Nec Private Function FocusedControl () As Control Dim TheControl As Control = Nothing For Each c ...Show All

• Software Development for Windows Vista Application are not sent WM_QUERYENDSESSION in Vista build 5308

  My application does not seem to be sent WM_QUERYENDSESSION on Vista. I'm using build 5308. Is this message still supported in Vista I have heard of new ShutdownBlockReasonCreate and ShutdownBlockReasonDestroy. But they don't allow you to specify which operations to block. I would like to block logoff but not shutdown or restart. Thank you, John There's some information on this page: http://windowssdk.msdn.microsoft.com/en-us/library/ms700677.aspx ...Show All

• Visual C++ msvcr80.dll Problem

  Hi there, can someone possibly tell me why Noton WinDoctor is telling me that 10 executables in the .NET Framework 2.0 cannot access the necessary dll file msvcr80.dll I see that the dll exists in the WinSxS directory and I'm running XP pro. I didn't have this problem until I downloaded the 2.0 framework at windows update. Any advice appreciated. Thanks. Naolin I am having the same problem... I even uninstalled it.. and it didnt show a problem then I reinstalled the update and it showed up as a problem in the Windoctor again... any ideas as to what is wrong with this update Im sure its a simple fix but I cant seem to get it.. ...Show All

• Visual Studio Express Editions StreamReader & StreamWriter-Error!

  I've searched a round a little, and am having trouble with StreamReader in VB. When I debug the application, I go to open a test file. When I click Open from the dialog, the debugging process pauses and VB shows the form's code. A line: SR.ReadLine.ToString(textbox1) is highlighted. A box appears: I don't understand what it means, I am loading Hello World into a textbox from a file. Sorry if this question seems "stupid," just got this a week ago. Thanks in advance! Kevin [edit] can't see the image goto http://www.freewebs.com/hardwarecompugeek/error.jpg I'm guessing you're getting an InvalidCastException; be sure to mention the exact error when you post questions like this. Use Option Stri ...Show All

• SQL Server Median calculation

  I want to calculate the MEDIAN time interval between the two date field. In an OLAP cube one of the dimension consists of the two date fields as well as Interval(days) field (calculated at the data source view). How to create a Measure in the OLAP cube to calculate the MEDIAN Interval MEDIAN( <<Set>>[, <<Numeric Expression>>]) And to slightly change Deepak's query to be more efficient: With Member [Measures].[MedPromoDays] as Median ( existing [Promotion].[Promotion].[Promotion], DateDiff("d", [Promotion].[Start Date]. MemberValue , [Promotion].[End Date]. MemberValue )) select {[Measures].[MedPromoDays]} on 0, [Promotion].[Promotion Ty ...Show All

• Visual Studio Tools for Office KB908002 bootstrapper questions

  Hi; I am trying to figure out the KB908002 bootstrapper and have a couple of questions. This is all based on the download at http://support.microsoft.com/default.aspx/kb/908002 This includes the files for both KB908002 and KB907417 - correct This puts the two msi and one exe file in the bootstrapper - there is no way to have it download them only if needed - correct If there is a way to have them downloaded only if needed - how do we do that Granted they are only 1/2 a meg but all the various hotfixes, PIAs, etc that are sometimes needed add up. The product.xml can be used to add this using GenerateBootstrapper in a MSBuild project - correct Is there anything special if it is used this way instead of through Vis ...Show All