Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field and 256 limit
Message
From
04/07/2005 05:52:38
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01028738
Message ID:
01028749
Views:
11
Thanks for that, but unfortunately it does'nt seem to work.
I still get the "String to long to fit" error. I am using your version of the function. If I cange the return value to PADR(value,250) it works, but that doesnt really help me.

Jon


>Jon,
>The first returned value of the function is smaller then others, try:
>Select dspmemo(co_criteria) from co
>
>
>Function DSPMemo(tcString)
>* this functions coverts a string/memo for passing by URL
>
>LOCAL lcRetval
>* Check if the String is not NULL
>IF NOT ISNULL(tcString)
>   lcRetval = ALLTRIM(tcString)
>   lcRetval = STRTRAN(tcString, CHR(13)+CHR(10), "-")
>   lcRetval = CHRTRAN(lcRetval, ['`], [])
>   lcRetval = STRTRAN(lcRetval, [&], [and])
>
>   If Right(lcRetval, 4) = [<br>] Then
>      lcRetval = Left(lcRetval, Len(lcRetval) - 4)
>   EndIf
>ELSE
>   * Return blank for NULL
>   lcRetval = "%20"
>ENDIF
>
>RETURN PADR(lcRetval, 300)
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform