List:MySQL on Win32« Previous MessageNext Message »
From:Leif Johnston Date:December 22 2013 4:47pm
Subject:RE: Invalid File Format after update for rich text data
View as plain text  
I think your update may need to be different from your insert.  Try trapping the sql statement before you run the update to see what it is. Then run it stand alone against the db. I think you'll find you have some artifact either quotes or double byte aRe what comes to my mind. 


Leif 


Sent from my smartphone which means any mistakes in wording or meaning is the smartphone's musings on my intent...

-------- Original message --------
From: Vic Spainhower <vic@stripped> 
Date: 12/22/2013  11:10 AM  (GMT-05:00) 
To: win32@stripped 
Subject: Invalid File Format after update for rich text data 
 
Hello,


I hope this is the right mysql list, but I have a MySQL database which
contains fields that are richtext.  However after updates to the data, I am
unable to retrieve the data without getting the error "file format is not
valid".e I'm using to update the database:

            Try
               
Dim result As DialogResult = MessageBox.Show("Do you want to
save your changes?", "Update Confirm", MessageBoxButtons.YesNo,
MessageBoxIcon.Question)

               
If result = DialogResult.Yes Then
               T
introText = " & Chr(34) & Me.RTB1.Rtf & Chr(34) _
              & " WHERE
FacilityID = " &
Globals.gdFacilityID
                   
Dim myConnection As New
MySqlConnection(Globals.g_strConnectionString)
                   
Dim myCommand As New MySqlCommand(strSQL, myConnection)
    and(strSQL, myConnection)
                          
myCommand.Connection.Close()
                    
MsgBox("Changes were Saved!")
               
Else
           End If

            Catch ex As Exception

               
MsgBox("Update Error, details: " & vbCrLf & ex.ToString)
            End Try


Thank you very much,

Vic


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32

Thread
Invalid File Format after update for rich text dataVic Spainhower22 Dec
RE: Invalid File Format after update for rich text dataLeif Johnston22 Dec