Re: Under what circumstances would GetDate() return NULL?
- From: Jon Brunson <JonBrunson@NOSPAMinnovationsoftwareDOTcoPERIODuk>
- Date: Fri, 29 Jul 2005 11:53:48 +0100
Jon Brunson wrote:
Darren Shaffer wrote:
Jon,
Based on your code and the fact that this table is not being updated
by replication, RDA, or another code path, I can't tell you why you
got null for your date column. I'll try to recreate this myself and if I can
produce this behavior, I'll open the bug with the SQL CE team at
Microsoft.
Out of curiosity - has the null behavior happened since the time you reported?
Just got the latest error log from a customer, and from what I can tell, the NULLs were on Tuesday the 12th of July, but have not "happened" since (the log dates up to the 20th).
If I come across any more in the future, I will reply to this thread.
Had some more NULLs, they all seem to happen when the sqlce.dev.wce4.armv4 CAB file is not installed, although sometimes it's not installed and GETDATE() returns fine. We install that CAB so that we can get the messages from SQL errors, on some devices it seems to get deleted (the device may have been reset perhaps).
These NULLs seem to also stem from errors in SqlCe itself, that is, an error occurs in executing a SQL query (say "SELECT Column with a space but not bracketed FROM tbl" - crude example), thus a new record is inserted into our error log, but it cannot get the message for this error, so it just puts "Unable to parse SQLCE error. Please ensure the SQLCE.dev.wce4.armv4 CAB file is installed" in instead.
I can only think that SQL is currupt, or badly installed, but if that was true, how could it possibly add anything to the error log, which itself is in SQL?
*sigh* .
- References:
- Under what circumstances would GetDate() return NULL?
- From: Jon Brunson
- Re: Under what circumstances would GetDate() return NULL?
- From: Darren Shaffer
- Re: Under what circumstances would GetDate() return NULL?
- From: Jon Brunson
- Re: Under what circumstances would GetDate() return NULL?
- From: Darren Shaffer
- Re: Under what circumstances would GetDate() return NULL?
- From: Jon Brunson
- Under what circumstances would GetDate() return NULL?
- Prev by Date: Searching for Date
- Next by Date: RE: Searching for Date
- Previous by thread: Re: Under what circumstances would GetDate() return NULL?
- Next by thread: TOP Clause
- Index(es):
Relevant Pages
|
