Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field update length restriction
Message
From
22/09/2004 14:44:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Title:
Memo field update length restriction
Miscellaneous
Thread ID:
00945157
Message ID:
00945157
Views:
68
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
Next
Reply
Map
View

Click here to load this message in the networking platform