Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo field update length restriction
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Titre:
Memo field update length restriction
Divers
Thread ID:
00945157
Message ID:
00945157
Vues:
67
I am updating a legacy standalone table with a memo field from an ASP.NET app. Simple enough, but I get a "Command contains unrecognized phrase/keyword." message if I exceed 254 characters, as I must. The code is below. Can someone suggest a solution? The fx.InsertRows() is just a standard data update class call and works fine with shorter strings. Thanks!

Laura
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim fx As New DataFunctions
        Dim strReq As String
        Dim strRet As String
        Try
            ' We simply insert the new record, as the paging engine selection process is based on a last updated sort.
            strReq = "UPDATE AcctMemo SET mam_info='" & Me.TextBox1.Text  & "' WHERE cAcctID='009990'"
            strRet = fx.InsertRows(strReq, Application("LOCAL_FOX_CONNECT"))
            If Not strRet = Nothing Then
                Me.Label1.Text = strRet
            End If
        Catch ex As Exception
            Me.Label1.Text = ex.Message.ToString
        End Try
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform