Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

timestamp

1 view
Skip to first unread message

sfaber

unread,
Feb 11, 2007, 11:43:58 AM2/11/07
to

It seems a jdbTable displays a TIMESTAMP as the date 12:00:00 AM
all the time even when the JDataStore data as shown with the
DataExplorer has the correct timestamp in it. Then worse yet, when
I try do a deleteRow(), it fails since the query can't find a match. Is there any workaround for this? I tried to go back to a DATE format but I can't get DataExplorer to change it back. Guess I'll have to build a whole new database again. I'm using JBuilderX with JDataStore 6.

sfaber

unread,
Feb 12, 2007, 11:42:11 AM2/12/07
to

I made a small test program with a timestamp in the database
and it worked fine, so I have to attribute my problem to the
fact that I changed the underlying data type from DATE to
TIMESTAMP and then changed the column data types in the project.
I noticed before that changing any underlying data will cause
erratic behavior that may require a deletion and re-addition
of the database components in the project. Can anyone verify this? I seem to remember similar trouble with C++ Builder.

Kevin Dean [TeamB]

unread,
Feb 12, 2007, 5:31:33 PM2/12/07
to
sfaber wrote:

>Can anyone verify this? I seem to remember similar trouble with C++
>Builder.

Yes, changing the underlying data type can corrupt the application if you
have got hard-coded Column types. This is a limitation you have to be
aware of.

--
Kevin Dean [TeamB]
Dolphin Data Development Ltd.
http://www.datadevelopment.com/

Please see Borland's newsgroup guidelines at
http://info.borland.com/newsgroups/guide.html

0 new messages