> has a value of 0. This will occur both in the Designer and in execution.
> Sometimes the string of numbers varies some.
SQL Date and Time fields, in most SQL Servers, cannot have a 0 value like
integers or "" (empty string) for characters.
Actually, M$ have added 2 new data types to its SQL Server cause of this:
"ElapsedTime" and "Elapsed Date", that supoort an empty value.
If your fields have a 0 value because they're corrupted, you must have
either assign a NULL state (or NULL value) to them, or assign a valid date
like when the database/table was created.
If you still want to assign a empty value, you could either use a NULL
value, or change you field data type to integer and use your own functions
to convert from and to date...
Just my 2 cents.
-----
Marco Aurelio Ramirez Carrillo
lazarus dot mramirez at star-dev dot com [dot mx]
P.D. I write an full article to "The Delphi Magazine" about this matter,
but they run out of bussiness...
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
