Re: Help with Insert

[Robert Buford <robertb@ABBASYS.COM>]

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 >>