View Single Post
  #1 (permalink)  
Old April 25th, 2009, 05:58 PM
Willemt Willemt is offline
Registered User
 
Join Date: Apr 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem updating table

Hello,

I have an Oracle DB with some table's, I can insert data to the table's, but when I want to update the table's there is nothing happend.

I use the query below written in Delphi.Prism. What is wrong with this query?
Code:
   try
    OracleConn := new OracleConnection;
    OracleConn.Connectionstring := 'User Id=SCHULDHULP;Password=pass; Data Source=Omgeving;';
    OracleConn.Open;
    myOracleTransaction := OracleConn.BeginTransaction();
    cmd := new OracleCommand;
    cmd := OracleConn.CreateCommand;
     if RadioButton2.Checked = true then SEXE := 'Man'else
        SEXE := 'Vrouw';
     if RadioButton5.Checked = true then VER := 'Ja' else
        VER := 'Nee';
     if RadioButton3.Checked = true then GEH := 'Ja' else
        GEH := 'Nee';
     if RadioButton7.Checked = true then MOB := 'Abonnement' else
         MOB := 'Prepaid';
    TextBox154.Text := BSNTxt.Text;
    cmd.Connection := OracleConn;  
        cmd.CommandText := "Update AANVRAGER SET GESLACHT='"+SEXE+"',GEHEIM='"+GEH+"',ABONNEMENT='"+MOB+"',GAAT_VERHUIZEN='"+VER+"'WHERE ALGEMEEN.BSN = 9675463772";
        cmd.ExecuteNonQuery();
        OracleConn.BeginTransaction.Commit;
    finally
        OracleConn.Close();
        OracleConn.Dispose();
    end;