Re: Help with Insert

["Logu Chakravarthi (IT Dept. - Langley)" <logu_chakravarthi@OWFG.COM>]

Somewhere you are getting null value for that column. As said earlier use
print or display command to sort out the values

C.Logu

> -----Original Message-----
> From: Robert Buford [SMTP:robertb@ABBASYS.COM]
> Sent: 1999/05/07 8:01 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Help with Insert
>
> Hi Aboukr,
>
> Before you insert each REG record, display all columns for that record and
> look for a column that has no values.
>
> Bob
>
> -----Original Message-----
> From:   Aboukr Sadikh [SMTP:bsadikh@YAHOO.COM]
> Sent:   Friday, May 07, 1999 8:56 AM
> To:     Multiple recipients of list SQR-USERS
> Subject:        Help with Insert
>
> Hi Gurus,
>
> I'm working on uploading employees' time from a flat file to a
> temporary table. Besides a few earnings
> codes, everything is a straight  upload. I'm having problems with the
> 'DIM', 'TPT' earnings codes.
> when 'DIM' is read from the file and the employee posts xhours for DIM,
> the program will
> assign xhours to DIM and (xhours * .5) to 'REG'. If TPT is read with
> xhours, xhours will be posted
> for TPT and xhours for 'REG'. Here are the steps I follow.
>
> 1. Read the input file
> 2. Put what is read into variables
> 3. Validate employee data (if exists).
> 4. Edit earning codes
> 5. Check if employee already has a REG earning code for the same date
> (Apr. 9,1999)
> 6. If yes
>         if earning code = 'DIM'
>                 let #Input-hours = #Input-hours
>                 Insert the DIM record then
>                 Update the REG record by adding #Input-hour/2 to it
> 7. If no,
>                 Insert the DIM and REG records.
> 8. Similar process for the 'TPT' earning code.
> 9. When I read earnings codes other than 'DIM' and 'TPT', I check for a
> REG line before inserting
>    the record.
>    If exists,
>            Update the existing record by adding to the existing line
>    if not, insert the new line.
>
> All other earning codes load properly execpt 'REG'. I have an error
> message saying 'ORA error, trying
> to insert a NULL value in a column that doesn't allow NULL values.)
>
> Any ideas on why it's happening. Thanks in advance for your insight.
>
> BS.
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>  << File: proc.txt >>