Re: SOLVED !!!!! ** H E L P ** Auto inserting date/Time (SQL*FORMS 2.3)

In <C94x3u.4su_at_brunel.ac.uk> cs91dnm_at_brunel.ac.uk (David N McCann) writes:

<stuff deleted>
>a SELECT ... INTO TiME ... will fail, because once the data is put int a
>SQL*Forms DATE field, it loses the time part. (remember only SQL*Forms fields
>can be reference in an INTO clause.)

You might need to be careful here if you plan to re-query the date and time field at some later point. Its a while since I worked with Forms 2.3 but, if I remember correctly, it will happily retrieve the field to the form but remove the time part. If you then change other fields on the form and commit the changes you lose the time on your column. If you dont change any fields, Forms thinks the row has changed and will prompt you to commit.

> I hope this has been as useful for you guys as it has for me. THe
>number of differebt variations that don't work are quite amazing, but they all
>fell down due to SQL*Forms DATE type not having any time component. I can't
>wait now till we upgrade to ORACLE v7.0 and I get to use Forms v3.0 with the
>DATETIME type.

Why wait for Oracle 7? You can have Forms 3 now on version 6.

Regards

Ian

-- 
--
Ian Dixon                       Email : idixon_at_infocom.co.uk
Reading, England