Fw: [Firebird-net-provider] sql inserts and updates not working

[Pavol S. <st...@st...>]

hi,

i think you will do best to put there dispose calls to... There are same
leaks (or something like that) in firebird (may be in provider)

and i found that if you use reader you have to dispose it too...

p.

> Hello:
>
> myConnection.Close() make a Rollback of the transaction,  try with this:
>
> myConnectionString =
>
"Database=C:\\interbase\\Usertasks\\xxx.GDB;User=xxx;Password=xxx;Dialect=3;
Server=xxx"
> myConnection = new FbConnection(myConnectionString)
> myConnection.Open()
>
> Dim UpdateCmd As String
>
> Updatecmd = "UPDATE users SET fname = 'Andrew' WHERE userid = " &
> txtuserid.Value
>
> myTxn = myConnection.BeginTransaction()
>
> MyCommand = New FbCommand(updateCmd, MyConnection, myTxn)
>
> Try
>     MyCommand.ExecuteNonQuery()
>     Message.Style("color") = "Green"
>     Message.InnerHtml = "<b>Account has been updated.</b><br>"
>
>     myTxn.Commit()
       myTxn.Dispose()
       myCommand.Dispose()

>  Catch Exp As FbException
>     Message.Style("color") = "red"
>     Message.InnerHtml = "ERROR: Could not update Account: <br>" &
Exp.Message
>     myConnection.Close()
> End Try
>
> myConnection.Close()
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>