Bug #15041 Cast from string "INSERT INTO table_name" to type 'Double' is not valid

• Submitted: 18 Nov 2005 3:05
• Modified: 20 Nov 2005 8:30
• Reporter: Reginald Fewell
• Status: Not a Bug
• Category: Connector / NET
• Severity: S3 (Non-critical)
• Version: 5.0
• OS: Windows (Windows XP)
• Assigned to: Bugs System
• CPU Architecture: Any

[18 Nov 2005 3:05] Reginald Fewell

Description:
I have the following VB.Net code to insert a record into MySQL and get the error listed below:

        Dim transaction_total As Double
        Dim taxdeduct As Double

        transacdate = Today
        lastn = Me.editLast_Name.Text
        firstn = Me.editFirst__Name.Text
        middle = Me.editMiddle_Initial.Text
        phone = Me.editPhone_Number.Text
        transaction_total = FormatCurrency(Total)
        taxdeduct = FormatCurrency((uniform * Val(txtUniforms.Text)))

        Dim myConnection As New MySqlConnection(myConnectionString)
        Dim myInsertQuery As String = "INSERT INTO transactions Values 
('" + transacdate + "', '" + firstn + "', '" + lastn + "','" + middle + "', '" + phone + "', 
  '" + transaction_total + "', '" + taxdeduct + "')"
        Dim myCommand As New MySqlCommand(myInsertQuery)
        myCommand.Connection = myConnection
        myConnection.Open()
        myCommand.ExecuteNonQuery()
        myCommand.Connection.Close()

ERROR:(Cast from string "INSERT INTO transactions Values " to type 'Double' is not valid.)

It appears that the Insert statement will not accept the type double.  Please advise if you all can help.

How to repeat:
Copy the VB.NET code above and execute.

[20 Nov 2005 8:30] Vasily Kishkin

You need to replace "+" on "&" :

from:

Dim myInsertQuery As String = "INSERT INTO transactions Values 
('" + transacdate + "', '" + firstn + "', '" + lastn + "','" + middle + "', '" +
phone + "',  '" + transaction_total + "', '" + taxdeduct + "')"

to:

Dim myInsertQuery As String = "INSERT INTO transactions Values 
('" & transacdate & "', '" & firstn & "', '" & lastn & "','" & middle & "', '" &
phone & "',  '" & transaction_total & "', '" & taxdeduct & "')"

It is sintax VB error.

[27 May 2010 6:32] axel caceres

gracias me fue de mcuha utilidad