Jasper22's Q&A profile

• SQL Server Daily report generating Monthly rollup stats

  Daily report generating Monthly rollup stats I have a daily report which each morning generates monthly information for the current month which was implemented in December. Everything was working correctly untill January 1st. On the 1st the report generated blank since it was suppose to generate 1-31 Dec but but the currently month was Jan, so it failed. How do I program it so if it is the 1st of a month generates the previous month but still would generate current month but while in the current month Any help is appreciated. SELECT GETDATE() - 1 AS rptdate, Errors.WTG_ID, lookup.Phase, Errors.STATUS_TYPE, Errors.STATUS_CODE, STATUS_CODES.STATUS_DEF, Errors.TIME_STAMP, Errors.ANSI_TIME, lookup.WTG_TYPE, Errors.POSITION FROM Errors ...Show All

• Visual C# changing label from program.cs

  ok well i have a listener thread in program.cs that listens for messages from my NetworkStream and then needs to acces a label on my Form1 ive tried Client. Form1 test = new Client. Form1 (); test.label1.Text = data; Client being my application name lable1 is probably a label in Form1 class and it cannot be access here because it has by default private modifier. The best way to do it to create a property in Form1 Class like this: public string SetLabelText { get { return this.label1.Text; } set { this.label1.Text = value; } } Put the above code in Form1 class And access it from other class like this: Client. Form1 test = new Client. Form1 (); test. SetLa ...Show All

• Visual Studio "Unexpected Error" in VS2005 on loading a solution

  Reproduced from another thread as requested: I have several branched codebases, and the problem only occurs when switching between codebases (ie. I run 'clean' on the solution in the codebase I'm switching from, and open the solution in the codebase I'm switching to). The codebases represent the same code at different points in the release cycle and are mapped to different directory hierarchies in the filesystem. My .sln file is in the same directory as all of the contained project directories (ie. one level up from all the .csproj files): MySolution MySolution\MySolution.sln MySolution\MyProject1 MySolution\MyProject1\MyProject1.csproj MySolution\MyProject2 MySolution\MyProject2\MyProject2.csproj etc.. As ...Show All

• .NET Development Thread scheduling problem: (apparent) violation of "wait on event" mechanism between /CLR processes

  Out of all the available forums, this one seems to be the most appropriate for this issue. This certainly is a .Net-related problem because I have done this successfully in the past with native applications (using VC++ 6.0). I am currently using VC++ 2005 with the latest .Net on an up-to-date Windows 2000 computer with 512MB of RAM. The failure is observed with high-probability under low-memory conditions: after running two instances of the Studio (so I don't have to keep swapping the solutions when I want to consult the code), but only one debugger session (the other process is running as an executable), and the 2005 SQL Express server, I'm left with a commit charge of around 700MB, i.e., some processes are swapped to virtual memory. I h ...Show All

• SQL Server Copy Database from 2005 server to another 2005 server.

  I'm getting the following error when trying to copy a database from one server to another. The specified @subsystem_name ('SSIS') does not exist. (Microsoft SQL Server, Error: 14262) A saw anther thread in this forum regarding this issue but it wasn't very helpful. Any recommendations on dealing with this issue The source server is running SQL 2005 Standard and the target server is running SQL 2005 Enterprise. Both servers are running Windows 2003 Server SP1. Any help would be greatly appreciated. Hi Jason, It sounds like you might not be running SP1 of SQL Server. In the RTM version of SQL Server 2005, you needed to install SSIS to make everything work. In SP1, we figured out how to get ...Show All

• Visual Studio 2008 (Pre-release) Why does the Selector class not support multiple selection?

  The System.Windows.Controls.Primitives.Selector class does only have a property SelectedItem , but not SelectedItems . Why not Maybe I don't understand the real meaning of this class, so any info is apreciated. ...Show All

• Software Development for Windows Vista July CTP will not install on all machines that had past CTP's

  Hi This has been one problem after another, we have managed to get the error messages down to this one after removing bits and bobs left behind by they "I don't uninstall much tool". [08/03/06,11:00:19] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603 [08/03/06,11:00:30] WapUI: [2] DepCheck indicates Windows Communication Foundation is not installed. Not sure who is in charge of beta setup but I suggest MS tells them to take a hike. I understand that 3.0 is in beta and bugs are perfectly acceptable but installation applications bugs are not. Especially when they are repeated over and over. Our architects have wasted two da ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Displaying Videoframes with DirectX

  I use a open source codec/video library (libavcodec). This lib exposes the video frames as 24_bit RGB bitmaps in memory. All I want to do now, is displaying those frames in a window as fast as possible. I tried a very naive approach: for ( unsigned int i = 0 ; i < Framenumber; i++ ) { Load->get_nth_frame( ID, i , RGBFrame ); DXDev->BeginScene(); Backbuffer->LockRect( &LR, NULL, 0); // [ memblit Copies RGBFrame pixelwise to Backbuffer , same function as //D3DXLoadSurfaceFromMemory ( Backbuffer, NULL, &SrcRect, RGBFrame, //D3DFMT_R8G8B8, Pitch, NULL, &SrcRect, D3DX_FILTER_NONE, 0);] memblit ( RGBFrame, (char*)LR.pBits, w, h, LR.Pitch ); Backbuffer->UnlockRect( ); DXDev->EndScene(); DXDev ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Simple 2D with D3D9

  Hello, I'm using vb.net 2005 express and I'm trying to write a sub that mimics the behavior of DirectDraw in D3D (since DD is depreciated and all). I have a few questions. In DirectDraw your surfaces could be as large as you'd like, and non-square. I've read that it's not reccomended that you have a texture larger than 256x256. I'm trying to migrate a simple tile based rpg game from DD to D3D. Will I need to split my tilemap into several smaller (256x256) bitmaps Or is it ok to have larger textures Here's my current code for my Draw sub: Public Sub Draw(ByVal lDevice As Device, ByVal srcTexture As Texture, ByVal srcRect As Rectangle, ByVal destRect As Rectangle) Dim ...Show All

• .NET Development Does anyone know the reason for this error.

  Hello, I'm getting an error while trying to read XML into a dataset and I was wondering if anyone knew what the error might be. Here is an example of the data causing the error... the error is an Expected End Element error. <data>--- summary </data> It's the --- that looks to be iffy, when it's removed the data imports fine. I was wondering if the import is seeing the >--- as a comment or something. Thanks Problem wasn't related to --. XML contained character with code '0' and as a result wasn't well formed XML. XmlTextReader rejected it. This is "by design". Opening the file in Notepad and saving it back fixed the file -- Notepad replaces characters with code '0'. .NET 1.1 gives cry ...Show All

• Visual Studio 2008 (Pre-release) using wsHttpBinding without enabling WS -AT Protocol

  Hi, My WCF service is using a wsHttpBinding hosted in IIS as :- < bindings > < wsHttpBinding > < binding name = " Binding1 " transactionFlow = " true " /> </ wsHttpBinding > </ bindings > My client is WCF client which start a tranasction which flowed to service.Tranactions are committed or aborted as expected. As I have read in various MSDN arctiles wsHttpBinding use WS-AT protocol by default.But WS -AT network support is disabled on the machine running service as shown by wsatConfig.exe -show ( It is as default , I did not set anything realted to WS-AT protocol). Since I have not enabled WS-AT protocol , so how the transactions are working Thank ...Show All

• .NET Development Write data on webserver.

  Hi, I wants to create a xml file in the webservices virtual directory from C# desktop application. can any one help me out No, it's totally related w'th asp.net, if you are running a desktop app and if that app is at the webserver, then you know it's location (could be something like c:\inetpub\wwwroot\....) or if it is under a virtual path that you can findout that path from your IIS panel at administrator control panel... ...Show All

• Visual C++ DLL generated but related import library is missing?

  Hello everyone, I am building a DLL file. But the related import library file .lib is not generated. I am using Visual Studio 2003. What points should I check in order to generate the import library file thanks in advance, George Thank you Opfer, Opfer wrote: The linker option for the .lib file is: /IMPLIB:"C:\Documents and Settings\<USER>\My Documents\Visual Studio 2005\Projects\<PROJECT>\Release\<DLL>.lib" If this option isn't specified, it should output a .lib file in the same directory as your DLL, also with the same name, just the different extension (lib). The only command line options that VS adds to the linker when building my DLL (with wo ...Show All

• Visual Studio 2008 (Pre-release) "PDF-like" scrolling

  I'm creating an application displaying a map and would like to use the same type of scrolling often used when browsing PDF documents (where the scrollable content is "dragged" by the mose). Is there any support for this or do I have to implement this functionallity from scratch Thanks A possible solution is to have an image inside a thumb and then listen to the drag delta event - scroll by the amount of horizontal/vertical change. ...Show All

• SQL Server How To Get User Input in Query

  I m new to SQL Server. Before this I was using access. In access one can have user inputs easily .. for example where receivedate=[enter date] how I can get userinputs in SQL server Query.... Forgive me if it is a dumb question I know what you mean, but user interaction is not possible in SQL Server like in Access as SQL Server is no frontent application. The best thing would be, as already mentioned to use parameterized queries and letting your frontend application fill these params with the respective values. HTH, jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All