Problems with Inserting Data & Variables

[Zero-G.]

Hey

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

Code: Select all

    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

[AndreyR]

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

[Zero-G.]

Hey

When do you think will the problem be solved?

THX

[AndreyR]

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

[Zero-G.]

When will the next build be available?

THX

[AndreyR]

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