[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    RE: dose $Sys_Def$ mean anything to anyone...
From:       "Shane Hatch" <SHATCH () micronpc ! com>
Date:       2002-07-11 22:44:13
[Download RAW message or body]

Thanks for your help. I've done a little more research and have discovered the issue. \


-----Original Message-----
Sent: Thursday, July 11, 2002 3:44 PM
To: Multiple recipients of list ODTUG-SQLPLUS-L



Does the table have the auto-gen types set?  We had a system that was
generated using CASE 5.1 and the auto-gen was done at the forms level
instead of the database.  The auto-generated fields contained $$USER$$ as
the default value.  After one of our upgrades some of these fields started
getting populated with this value versus the actual user that was logged
on.   I would check the table definition, the TAPI or the triggers firing
when the table inserts, and the forms used to insert the data.  It looks
like a hold over of some kind to me.


                                                                                      \
                
                    "Shane Hatch"                                                     \
                
                    <SHATCH@micron       To:     Multiple recipients of list \
                ODTUG-SQLPLUS-L <ODTUG-SQLPLUS-L@fatcity.com>                  
                    pc.com>              cc:                                          \
                
                    Sent by:             Fax to:                                      \
                
                    root@fatcity.c       Subject:     dose $Sys_Def$ mean anything to \
                anyone...                                             
                    om                                                                \
                
                                                                                      \
                
                                                                                      \
                
                    07/11/02 02:10                                                    \
                
                    PM                                                                \
                
                    Please respond                                                    \
                
                    to                                                                \
                
                    ODTUG-SQLPLUS-                                                    \
                
                    L                                                                 \
                
                                                                                      \
                
                                                                                      \





$Sys_Def$ is a default value that is being inserted into a column when the
data being inserted to the column is actually null. Dose this string mean
anything to the database some how? DB version is 7.3.3........

Thanks for your help.

Thanks to everyone for making ODTUG 2002 a great success!  Plan now
for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003.
--
Author: Shane Hatch
  INET: SHATCH@micronpc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




Thanks to everyone for making ODTUG 2002 a great success!  Plan now
for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003.
-- 
Author: Judith L Bramlette/JUDYB/CC01/INEEL/US
  INET: JUDYB@inel.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Thanks to everyone for making ODTUG 2002 a great success!  Plan now
for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003.
--
Author: Shane Hatch
  INET: SHATCH@micronpc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


[prev in list] [next in list] [prev in thread] [next in thread]