🚀 go-pugleaf

Robert Stitson wrote:
> Am unable to update dates and or timestamps using dataexpress
> components.Resolving query always fails when including dates or timestamps
> as updateable. Using the latest download of JBuilder Developer version. and
> Oracle 9.2.0.2. Am fine if I make the dates/timestamps not updateable/not
> resolvable etc but need to allow updates of certain fields. Have not written
> a custom resolver as am unable to find robust examples with interfaces to
> Oracle tables.
> 
> 

Oracle is confused/confusing.  Oracle has a DATE/TIMESTAMP "type". 
Unfortunately, most standard relational API's just see it as a "DATE", 
because that's what they call it.

With Oracle 9i, we got a real TIMESTAMP type in Oracle.  That's the type 
you should be using.  Then it should be resolvable.

I have a script I ran on my Oracle database that converted all my 
columns to the proper type when I upgraded to Oracle 9i.  I'd be happy 
to post it in the attachments group for your reference if you'd like.

-- 

Regards,

Lori Olson [TeamB]

------------

Save yourself, and everyone else, some time and search the
newsgroups and the FAQ-O-Matic before posting your next
question.

Google Advanced Newsgroup Search
     http://www.google.ca/advanced_group_search
Other Newsgroup Searches:
     http://www.borland.com/newsgroups/ngsearch.html
Joi Ellis's FAQ-O-Matic:
     http://www.visi.com/~gyles19/fom-serve/cache/1.html

Thanks, am new to news groups will try to do a more complete search in
advance. Unfortunately I have also posted this in the database section as I
though documentation was the incorrect place. Please ignore.

"Lori M Olson [TeamB]" <javadragon@techie.com> wrote in message
news:4133f9d5$1@newsgroups.borland.com...
> Robert Stitson wrote:
> > Am unable to update dates and or timestamps using dataexpress
> > components.Resolving query always fails when including dates or
timestamps
> > as updateable. Using the latest download of JBuilder Developer version.
and
> > Oracle 9.2.0.2. Am fine if I make the dates/timestamps not
updateable/not
> > resolvable etc but need to allow updates of certain fields. Have not
written
> > a custom resolver as am unable to find robust examples with interfaces
to
> > Oracle tables.
> >
> >
>
> Oracle is confused/confusing.  Oracle has a DATE/TIMESTAMP "type".
> Unfortunately, most standard relational API's just see it as a "DATE",
> because that's what they call it.
>
> With Oracle 9i, we got a real TIMESTAMP type in Oracle.  That's the type
> you should be using.  Then it should be resolvable.
>
> I have a script I ran on my Oracle database that converted all my
> columns to the proper type when I upgraded to Oracle 9i.  I'd be happy
> to post it in the attachments group for your reference if you'd like.
>
> -- 
>
> Regards,
>
> Lori Olson [TeamB]
>
> ------------
>
> Save yourself, and everyone else, some time and search the
> newsgroups and the FAQ-O-Matic before posting your next
> question.
>
> Google Advanced Newsgroup Search
>      http://www.google.ca/advanced_group_search
> Other Newsgroup Searches:
>      http://www.borland.com/newsgroups/ngsearch.html
> Joi Ellis's FAQ-O-Matic:
>      http://www.visi.com/~gyles19/fom-serve/cache/1.html
>