I gave you a flawed code sample, sorry. :-O Thank you for pointing it out so nicely.

Add MemDC to your project. That way your text drawing is done in memory, and then the entire screen is repainted in a flash. A sample can be found here: Flicker Free Drawing In MFC[^]

But wouldn't this be worth a vote ...

Joe Smith IX wrote: Anyone can help me here? Another solution is to pass the address of pTemplate to GetData(). "Love people and use things, not love things and use people." - Unknown "The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

Quote from the file EasyReport.cpp /***************************************************************** * * method :void CEasyReport::Start(void) * * parameters : none * * returns : * * description: Start the report generation. Create all the fonts, etc * Try and get the printer device context, If no printer is set up as * the default printer on the system, create a screen device context. * ****************************************************************/ So you have to make that your code attach the printerDC you are getting to the m_printerDC, that printerDC is being used in the CEasyReport::CEasyReport (), in the CEasyReport::WriteParagraph (), in the CEasyReport::Start () and the CEasyReport::End (). But watch out, the definition is an HDC so maybe you can not use your CDC* directly. I suggest you to read another time carefully the articles whose code you are using, go slow through the code they provided because the support for printing is in the pre-done code you are using. You just have to find your way to correctly connect them. If I were you I would try to contact with the autors ask them directly. Good Luck :) Regards. -------- M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you “The First Rule of Program Optimization: Don't do it. The Second Rule of Program Optimization (for experts only!): Don't do it yet.” - Michael A. Jackson Rating helpfull answers is nice, but saying thanks can be even nicer.

I have also faced the same problem when i used multithreading with very complex query that takes 25 sec to execute. and there are multiple threads so they hit the sql server with the same query at a time which cause Time Out Expired... I think following might help you. You can view the Locks by executing** sp_lock Also try these undocumented system stored procedures to get the info about blocking. sp_who sp_who2 **Read this MSDN KB Article and Try to divide the update/delete statement by block of rows like this [^]

Sorry for the late reply - did you get this working? The line with the warning should be just #undef new As I mentioned before, I'm just not sure where this should be in a template class. Since the actual class is built where an object is instantiated, I'm not sure if the #undef stuff needs to be there or if it worke by putting it in the template declaration. If it works in the template declaration (as you've shown) then that's cool :) It's easy enough to test. Mark Mark Salsbery Microsoft MVP - Visual C++ :java:

Which is why I specifically stated "compile-time version." :rolleyes: "A good athlete is the result of a good and worthy opponent." - David Crow "To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

But the code runs fine on XP... I don't have Win2K box with me right now, so I'll try your idea tomorrow. Thanks.

Query two shouldn't take up as much bandwidth as query one. The extra bandwidth depends on how many fields are being fetched from the table. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Compile your code into a DLL and export the classes. They'll see the method prototypes, but won't see the code behind them. One thing to consider is that you MUST provided complete documentation for the classes so the programmers know how to use them properly. "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

What do you need,excatly? WhiteSky

sp_who reports all current connections. The procedure takes its data from the sysprocesses view (SQL Server 2000) or the sys.dm_exec_connections dynamic management view in SQL Server 2005. Stability. What an interesting concept. -- Chris Maunder

thanks a lot, you've saved me hours of stressing out :)

You already got enough information from other replies. If you are using visual studio 2005, consider using secured version of these CRT function. Refer Security enhancement to CRT[^]. Prasad MS MVP -  VC++

Yup, you nailed it exactly. Thanks a lot. P.S.: Since this is not my class, I cannot change it.

Try this: update p set checked='ok' from product p where id in ( select id from product p2 join expirationdate e on p2.id = e.product_id group by id having count(*) = 0) I guess the question would be if there are records or not, it might be easier to do a left join if there are no records. So that would be: update p set checked='ok' from product p where id in ( select id from product p2 left join expirationdate e on p2.id = e.product_id where e.product_id is null) Hope that helps. Ben

Yes, according to their own details, it is the same thing just a smaller limited version. If you only have 5 clients and their databases will be under the limit then it sure is a lot cheaper. Actually if you decided to install the Sql express locally on the PC that the application was running on sql express would be faster then the full version since it wouldn't have to go across the network. Ben

Joe Smith IX wrote: Am I correct... No. Joe Smith IX wrote: ...there is a much simpler way? Yes. Once you have a class derived from CStatic, simply change your dialog's .h file by renaming all references to CStatic to your derived class. In the derived class, see the Extras section of this article. "Approved Workmen Are Not Ashamed" - 2 Timothy 2:15 "Judge not by the eye but by the heart." - Native American Proverb