On Tue, 2006-06-06 at 08:22 -0500, [EMAIL PROTECTED] wrote:
> > 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.'
MySQL is apparently one that does, at least since version 4.1.
>
> 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...
This is something I am still considering.
>
> Just my 2 cents.
>
> -----
> Marco Aurelio Ramirez Carrillo
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
