Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: 'identifier must be declared' when deleting from table

Re: Newbie: 'identifier must be declared' when deleting from table

From: Ian McCall <ian_at_eruvia.org>
Date: Thu, 17 Jul 2003 09:15:35 +0100
Message-ID: <JWsRa.13224$nP.7506@newsfep4-winn.server.ntli.net>

"Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in message news:rpoRa.79756$ye4.58653_at_sccrnsc01...
> Additionally,Why are you converting a date to a string and then comparing
it
> to a field that in all likelyhood is a date?

The field is an existing table, and is a varchar(8). It forms part of a primary key, which is why dates were avoided (don't want to accidently add timing resolution beyond that of one day).

Cheers,
Ian Received on Thu Jul 17 2003 - 03:15:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US