Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by lesrobot
-
Error: Cannot update <field> to Null
PHV, Thanks for your fix...it worked fine... I appreciate it... Les -
Error: Cannot update <field> to Null
I checked the contents, of cmpnt_cost, and could not find any null values...will also try the Oracle Forum...Thanks.. -
Error: Cannot update <field> to Null
Hi, I am trying to update a field, in rows, in an existing table, with the contents of a field from another table, and can't get past this error.. ora-01407: cannot update ("GEMMS"."CM_CMPT_DTL"."CMPNT_COST") to NULL. This is the SQL: update cm_cmpt_dtl a set a.cmpnt_cost = (select...
