Problems with Inserting Data & Variables

Problems with Inserting Data & Variables

Postby Zero-G. » Fri 12 Dec 2008 12:18

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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Mon 15 Dec 2008 11:31

Thank you for the report. We have reproduced the problem and now we are investigating it.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Zero-G. » Mon 15 Dec 2008 17:29

Hey

When do you think will the problem be solved?

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Tue 16 Dec 2008 12:30

The problem is solved, look forward to the next build.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Zero-G. » Thu 18 Dec 2008 12:40

When will the next build be available?

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Fri 19 Dec 2008 08:40

The next build will be available in a week or two.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL