Re: DATE PROBLEM!

Hi Ray,

Actually, it's not the date that is the problem, it's what I would assume is the title (ie 'Empire boys: Adventures in a man's world'). It's the "man's" which is causing it, due to the '. If you have to use the ' (I sometimes substitute ` for ', enclose the values within double quotes to stop the error. As for the date, you still store all parts of the datetime (I believe it defaults to 12:00AM if no time is entered, and Jan 1 1900 if no date), even if you don't use them. Hope this helps.

Dean_at_Home

"Ray" <raymondsee_at_home.com> wrote in message news:RY4U4.70100$R4.384649_at_news1.rdc1.nj.home.com...
> Hey all,
>
> Can anyone tell me what's the problem in this insert statement?
>
> Insert into book values ('0-044-45630-1', 'Empire boys : Adventures in a
> man's world', 'Joseph Bristol', 'Fiction', '07/99', '29.99', '35.99',
 '60',
> 'McGraw-Hill Companies, Inc');
>
> I got some error message saying
> ERROR:
> ORA-01756: quoted string not properly terminated
>
> I suspect i didn't put the date correctly, any suggestions? I just need
 the
> month and year....July 1999!
>
> Thanks
> RAY
>
>
>
>
>
>
>
>
Received on Tue May 16 2000 - 00:00:00 CEST