User Profile

Collapse

Profile Sidebar

Collapse
Anasi
Anasi
Last Activity: Oct 4 '07, 01:03 PM
Joined: Oct 3 '07
Location: Sweden
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Anasi
    replied to Use of exists when I cannot update to null
    in Oracle
    Yes, but how should i write if I dont want it to update at all if there isnt any rows with that timein in the table shipordart. I have tried with Exists but I cant get the syntax right. Maybe someone could help me with that or If someone have another solution to the problem i would be happy.

    Best regards
    Anasi
    See more | Go to post

      Leave a comment:

    • Anasi
      started a topic Use of exists when I cannot update to null
      in Oracle

      Use of exists when I cannot update to null

      Hi,
      I have a problem with a rule that is updating a oracle 10 database. The rule is expected to check if ther is a invoice number then take the highest of them, and if there isnt any, then choose the reference number instead. The problem is, sometimes the table shipordart doesnt contains any rows and then "nothing" should happen. But now i get a error message.

      ORA-01407: cannot update ("E768"."SHIPOR D"."INVOICEN O")...
      See more | Go to post
      No activity results to display
      Show More
      Working...