I checked Wikipedia and the permanent polar caps are made of water ice. The seasonal cover is from frozen carbon dioxide which sublimes in summer. I didn't know that. So you are right, there is enough water for a colony, but you'd need to melt it and transport to the colony in pipe I guess. I read somewhere there might be underground deposits of water ice which can occasionally melt during summer and even flow on the surface for a while. I don't have any reference for that however.

One person is seven or eight trees’ worth in terms of oxygen. But distance from the Sun will definitely be a factor here. Martian polar caps are mostly CO2, no luck here. Maybe there is some frozen water underground. Or you can get some water from comets if you can make them crash on Mars. Sun will be our only energy source so electricity will power everything.

How do you define mock data? We are not allowed to use real-life customer data in our tests. But we sometimes use data from test system when it is too complex to craft it by ourselves for example. However this has nothing to do with the fact where you store it: hard-coded in your test or in a file or database. For me these are two different aspects.

I would definitely not advise to use a real game engine. Kodu is aimed at teaching programming and is free.

Honestly I have the same problem. My 8 year old invents levels upon levels of his super complicated game thinking in details how different monsters will kill you. I tried to bring him to think of something simple which we can do together but seems that's not that interesting after all. I don't know anything about game making either so I tried to sell him Kodu[^] - with partial success.

Member 13094103 - Professional Profile[^]

Having a column per day is a poor design choice IMO. I'd strongly suggest you review it. As RyanDev already mentioned, you should use COALESCE[^], but you need to apply it to every value you are adding up.

COALESCE(1, 0) + COALESCE(2, 0) + ... + COALESCE(31, 0)

How do you add up the values? SUM should give you the correct result with NULL values. What database engine do you use?

Not the right forum. Try Q&A[^].

Wow! Never seen this before. I tested with RAND() and FLOAT and it's the same behavior. Did you find any explanation?

SALE OF HYPOTHECATED - CodeProject[^] Member 12465409 - Professional Profile - CodeProject[^]

Hi-tech company Hola set to break the Indian market - CodeProject[^]

I agree with the constant. I usually do this after I finish developing a method. I admit In this case I'd seen the problem immediately if I declared the constant upfront.

That's nice trick with unchecked. Thanks for sharing. I eventually used decimal format, it's just a number after all.

It was an uint, and the problem was that I was comparing that to and integer. The integer value is -2147024864 but there is no way to declare that in hex. Hex value always translates to positive number which is 2147942432 in this case. The hex view in debugger fooled me. Edit: ok there is a way :) thanks John.

I have a code where I need to get an exclusive lock on a file. It goes something like this:

try
{
// open file
}
catch(IOException ex)
{
if(ex.HResult == 0x80070020)
{
// retry
}
else
{
throw;
}
}

Looked good so I tested and it didn't work at all. So I debugged it and what i saw was:

ex.HResult 0x80070020 int
ex.HResult == 0x80070020 false bool

There is something wrong about the value 0x80070020. So I tried to declare a constant:

const int lockedFileHResult = 0x80070020;

And there it was: Cannot implicitly convert type 'uint' to 'int'. Of course because that is actually a negative number but the compiler doesn't know that so it cannot fit it into an integer. Next time I'll be extra careful with hex literals.

Best INTEL Processor For Mid to High-End Gaming PC - CodeProject[^]

The author: http://www.codeproject.com/script/Membership/View.aspx?mid=12215267[^] The article: http://www.codeproject.com/script/Articles/ArticleVersion.aspx?waid=194206&aid=1065387[^]

I was just looking at that. Maybe it's just a very poorly written article? I'm really not sure. There is no reference to any website or company or anything that I would consider spam. But is definitely off topic for CodeProject. Taking back, was not looking properly.

Question: The Power Of A Millionaire Mentor And How To Find One Millionaire Circle[^] Author: http://www.codeproject.com/script/Membership/View.aspx?mid=12151705[^]