Re: Memo Update

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ook (outlookexpress_at_nospam@embertsdotcom)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 09:27:28 -0700

Try this:

lcVALUE = a string of jibberish goes here after I have counted the
characters with a LEN() function in Excel so that I know how manu characters
the string literal contains.'

UPDATE inmast SET fcomment=lcVALUE WHERE fprodcl='TO'

"Carl T" <anonymous@discussions.microsoft.com> wrote in message
news:CCB09EEC-F0C8-4F6B-86BE-C7C9C6263DD8@microsoft.com...
> I can do better than that - The error can be easily reproduced (at least
for me) in VFP 8.0 developer environment. I open the database (I am using a
ERP program called Made2Manage) and enter the following SQL statement
directly in the command window.
>
> UPDATE inmast SET fcomment='a string of jibberish goes here after I have
counted the characters with a LEN() function in Excel so that I know how
manu characters the string literal contains.' WHERE fprodcl='TO'
>
> When the length of that string literal is 255 or less then the statement
succeeds (I get no error message, and upon a subsequent select statement
with the same criteria I see that the memo field FCOMMENT was updated as
requested.
>
> However, when the length is 256 characters (or more) then I the update
command returns the following error message and upon subsequent select
statement, I can see the field was not updated.
>
> Command contains unrecognized phrase/keyword
>
> I am using
>
> ----- Jack Jackson wrote: -----
>
> Post the code that is getting the error so we can we what is wrong.
>
> On Tue, 16 Mar 2004 20:36:07 -0800, Carl T
> <anonymous@discussions.microsoft.com> wrote:
>
> >Yes I am using a variable of string type and when it's length is
less than 255 characters, it works fine, but when over 255 I get the error
"Command contains unrecognized phrase/keyword."
> >>> ----- Rush Strong wrote: -----
> >> But a variable can be 16MB long, and I suspect that a variable
is being
> > used.
> >> - Rush
> >> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> > news:unUw2E8CEHA.2616@TK2MSFTNGP12.phx.gbl...
> >> A memo field can support very large character strings. However, a
> > constant
> >> value in VFP can't be larger than 254 characters. Break the
contant up
> > into
> >> multiple strings.
> >>> REPLACE memofield WITH "very large character string"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> " more values"+;
> >> "etc."
> >>> "Carl T" <anonymous@discussions.microsoft.com> wrote in message
> >> news:761523E9-481E-4739-8CF8-8F62DA8F305A@microsoft.com...
> >>> What if longer than 255 charachters?
> >>>

Relevant Pages

  • Re: Set App Priority
    ... string and then terminates" ... gives then parameters to use to modify the START command ... below) /F:OFF Disable file and directory name completion characters ... no special characters between the two quote characters, ...
    (microsoft.public.windowsxp.customize)
  • Re: how to calculate number of characters in argument?
    ... and would like to have available a command for calculating the ... the use of ASCII test within CJK text). ... to 0) for typesetting 9 half-width characters (which are I believe set ... It works by first stripping off everything before the decimal point, then feeding the remaining string of characters to a recursive macro that creates a \numexpr of the form: ...
    (comp.text.tex)
  • Re: How to convert Infix notation to postfix notation
    ... If this is for an error message, why isn't it using stderr for its output? ... array of 15 characters, and you call this function with the limit 15 on ... Making sure that the only string I allocate and append to, ... because mulFactor in all versions must needs incorporate the functions ...
    (comp.lang.c)
  • Re: Using filenames with spaces in variable functions
    ... having the command interpreter not able to ... | filenames instead of persisting with the limitations of the string ... those characters were not legal in file names. ...
    (comp.os.msdos.4dos)
  • Re: Prothon should not borrow Python strings!
    ... """It does not make sense to have a string without knowing what encoding ... same cul de sac as Python. ... Prothon_String_As_ASCII // raises error if there are high characters ... Python's split between byte strings and Unicode strings is ...
    (comp.lang.python)