Devart Forums

Posted: **Fri 12 Dec 2008 12:18**

Hey

I use your latest Components & VS2008 The following Code I try without any result:

    Dim myCommand As New Devart.Data.MySql.MySqlCommand
        Dim LID As Long

        MySqlConnection1.Open()
        myTr = MySqlConnection1.BeginTransaction
        myCommand.Connection = MySqlConnection1
        myCommand.CommandText = "Select @NID :=Max(Identifikation)+1 from Anrede; " & _
                                "Insert Into Anrede (Identifikation, Beschreibung) Values(@NID, 'TIPP');" & _
                                "Select Identifikation from Anrede Where Identifikation= @NID;"
        LID = myCommand.ExecuteScalar
        myTr.Commit()

        MsgBox(LID)

So, I have to say, that MsgBox(LID) tells me the correct value, but it is not set to the DataBase.
Any kinds of tipps?
THX

Posted: **Mon 15 Dec 2008 11:31**

Thank you for the report. We have reproduced the problem and now we are investigating it.

Posted: **Mon 15 Dec 2008 17:29**

Hey

When do you think will the problem be solved?

THX

Posted: **Tue 16 Dec 2008 12:30**

The problem is solved, look forward to the next build.

Posted: **Thu 18 Dec 2008 12:40**

When will the next build be available?

THX

Posted: **Fri 19 Dec 2008 08:40**

The next build will be available in a week or two.

Devart Forums

Problems with Inserting Data & Variables

Problems with Inserting Data & Variables