This is a strange phenomenon in MySQL; Oracle and SQL Server won't even run this query. In a Select statement with a Group By clause, all items appearing in the Select list must also appear in the Group By list, except the aggregate functions. Rewrite your query as: SELECT SensorID, State, NumKey, MAX(DateTimeEvent) FROM Sensors GROUP BY SensorID, State, NumKey

You're welcome. :) Luc Pattyn [Forum Guidelines] [My Articles] - before you ask a question here, search CodeProject, then Google - the quality and detail of your question reflects on the effectiveness of the help you are likely to get - use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

The ART of index optimisation. Always a good topic, guaranteed to stir a DBAs juices. Never underestimate the power of human stupidity RAH

If I hadn't seen it with my own eyes, I would have thought you were making it up. Jon Smith & Wesson: The original point and click interface

AFAIK, a coefficient is used for a multiplicative constant while factor has a more general meaning (i.e. multiplicative operand). :) If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile. This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke [My articles]

I agree with his assesment too.

I made a few performance tests, and it looks like my suspicion about accessing ints on an odd address was correct. It takes slightly longer (about 3%) to access the value using an adjusted pointer compared to just getting the value from the array and shifting it. Despite everything, the person most likely to be fooling you next is yourself.

Thanks Mark. this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Looks like FTP problem to me. What's the O.S. installed on the images server? Best Regards 3ala2 :)

Corkscrew? We don't need no stinking corkscrew![^]

Arguably compared to the UK/Germany/France. Definitely vs the USA, Canada, Russia, etc; although by this standard everyone in the EU is tiny (NY to LA = Lisbon to Moscow). You know, every time I tried to win a bar-bet about being able to count to 1000 using my fingers I always got punched out when I reached 4.... -- El Corazon

Appreciate the help this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Roger Alsing wrote: Its perfectly possible to pass a "ref string" Even if the instance of a string is immutable doesnt mean that the variable reference to that instance is immutable... Absolutely correct - what I meant is that the .NET library methods for the string and DateTime objects (among others) do not modify the variable but rather return a new instance. So if you want to add another method to the DateTime class (by using extension methods or simply a utility class) I might be a good idea to do it in the same way like the original DateTime methods do, by returning a new instance.

Thanks for the reply. I am working with legacy code which contains such wonderful calls as FP_OFF(), FP_SEG(). I believe it is these calls and the manipulation of far pointers which is crashing the code. Short of writing a header file to handle far pointers I was hoping VS may have had some obscure setting for dealing with far pointers. I suspect it is time to dust off Borland and fire up the Windows 98 machine. this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Too bad 'free()' wasn't defined as returning a (void *). In that case, the code could have been written as: flag = free(flag); In case of any error other than a null pointer being passed in, free() could return the passed-in pointer. Similar behavior could have been used with fclose() [return a (FILE*)] and other such functions that destroy the object whose pointer is passed to them. Oh well, only a few decades too late now.... Where's my time machine?

After a fair amount of looking around, InPlaceMetaDataWriter.Title accesses the IPTC Document Title while the InPlaceMetaDataWriter.GetQuery("/app1/ifd/{uint=270}")) looks at the ImageDescription. Two separate items. this thing looks like it was written by an epileptic ferret Dave Kreskowiak

Well I've always felt that VS2008 is much faster than VS2005. The only experience I can consider is that I've installed VS2005 into an XP VM and VS2008 into another XP VM running on the same computer running Vista x64 and definitely thought tha 2008 one was faster. So my experiences directly contradict yours, sorry. I doubt it. If it isn't intuitive then we need to fix it. - Chris Maunder