Help! changed data type and now cannot run project

Hi Folks,
I am using Delphi 7 with an Adavantage database.
I changed 5 fields from TimeStamp to Date. (yes, I know, bad planning).
Anyway, After changing the data types to Date, I can now no longer run my
project!
I can open the project in design but I get the message "0.0 is not a valid
time stamp.
I tried to open the data module that houses my tables and queries, but can
only get to the code view.

Can anyone tell me how to fix this issue???


.

Relevant Pages

  • Re: Index on timestamp with timezone AT LOCAL
    ... I want to use a view to get the time stamp column at the timezone ... Also there is mention of Time Zone in the post but the Timestamp data ... From Concepts Manual chapter on native data types ...
    (comp.databases.oracle.misc)
  • Re: Setter method for Date entry
    ... The reason I ask is because I can use this if not formating my date ... Or use this if formatting my date entry: ... What a given DBMS calls its data types is subject to variation; one has to know the local-to-SQL data type mapping. ... I think Oracle calls its TIMESTAMP type "TIMESTAMP" but I don't feel like looking it up this minute. ...
    (comp.lang.java.programmer)
  • Re: Oracle and JDBC Timestamp Types Confusion
    ... > Robert Klemme wrote: ... >> timestamp data types is correct: ... >> TIMESTAMP. ... Were timestampid your only column in the primary key an INDEX ...
    (comp.databases.oracle.server)
  • Re: Oracle and JDBC Timestamp Types Confusion
    ... Robert Klemme wrote: ... > timestamp data types is correct: ... > TIMESTAMP. ... Were timestampid your only column in the primary key an INDEX ...
    (comp.databases.oracle.server)