Using v4.22, I'm getting an error "'0.0' is not a valid timestamp."

I'm seeing this when trying to display the table using DevExpress
QuantamGrid 5.12, but I also get it when I try to access TimeStamp
fields on certain records using .Value or .AsDateTime.

Any ideas as to why this might be happening?

--Bruce

Bruce,

<< Using v4.22, I'm getting an error "'0.0' is not a valid timestamp."

I'm seeing this when trying to display the table using DevExpress
QuantamGrid 5.12, but I also get it when I try to access TimeStamp fields on
certain records using .Value or .AsDateTime.

Any ideas as to why this might be happening? >>

What are the values in the table for the records that are causing the error
?  Also, does the error occur with a normal TDBGrid control ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Bruce <bvanderweb@gmail.com> wrote in
news:m3it12tjgv6ej6fve5tfinegmchdu67v8a@4ax.com:

> Using v4.22, I'm getting an error "'0.0' is not a valid timestamp."
>
> Any ideas as to why this might be happening?

Is the PC set up for European numerics, with a comma decimal separator, and
is the component that's objecting using an intermediate string formatting
routine?

If not, I've no idea
--
Chris

Tim,

I don't know what the value is because both <field>.Value and
<field>.AsDateTime fail with the same error.

It works in DBSys, however.

On Mon, 20 Mar 2006 11:25:33 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Bruce,
>
><< Using v4.22, I'm getting an error "'0.0' is not a valid timestamp."
>
> I'm seeing this when trying to display the table using DevExpress
>QuantamGrid 5.12, but I also get it when I try to access TimeStamp fields on
>certain records using .Value or .AsDateTime.
>
> Any ideas as to why this might be happening? >>
>
>What are the values in the table for the records that are causing the error
>?  Also, does the error occur with a normal TDBGrid control ?

Tim - I e-mailed you the table and a sample project.

--Bruce

On Mon, 20 Mar 2006 11:25:33 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Bruce,
>
><< Using v4.22, I'm getting an error "'0.0' is not a valid timestamp."
>
> I'm seeing this when trying to display the table using DevExpress
>QuantamGrid 5.12, but I also get it when I try to access TimeStamp fields on
>certain records using .Value or .AsDateTime.
>
> Any ideas as to why this might be happening? >>
>
>What are the values in the table for the records that are causing the error
>?  Also, does the error occur with a normal TDBGrid control ?

Bruce,

I had this error recently.  If I recall correctly (& that's a big IF I
was trying to assign now (DateTime) to a Date field or something along those
lines.

Hope that helps.

--
Gavin Horne
www.hornesoftware.com.au


"Bruce" <bvanderweb@gmail.com> wrote in message
news:va7u1251379mij7i608hk42eq0bnvqh4f5@4ax.com...
> Tim - I e-mailed you the table and a sample project.
>
> --Bruce
>
> On Mon, 20 Mar 2006 11:25:33 -0500, "Tim Young [Elevate Software]"
> <timyoung@elevatesoft.com> wrote:
>
>>Bruce,
>>
>><< Using v4.22, I'm getting an error "'0.0' is not a valid timestamp."
>>
>> I'm seeing this when trying to display the table using DevExpress
>>QuantamGrid 5.12, but I also get it when I try to access TimeStamp fields
>>on
>>certain records using .Value or .AsDateTime.
>>
>> Any ideas as to why this might be happening? >>
>>
>>What are the values in the table for the records that are causing the
>>error
>>?  Also, does the error occur with a normal TDBGrid control ?

Bruce,

<< Tim - I e-mailed you the table and a sample project. >>

Okay, the table simply has some timestamp values in it that are 0, which was
permissible with Delphi 5 and earlier but isn't with Delphi 6 or higher in
terms of timestamp->string or timestamp->variant conversion.  If you Clear
them and make them NULL you should be okay.

--
Tim Young
Elevate Software
www.elevatesoft.com