Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generating a Memo in a SQL statement
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00007163
Message ID:
00007220
Views:
29
>Does anybody know how to force a text field to become a memo? I have a long text string that gets me: String to long to fit.
>
>Tried padding the string to 260 bytes to overflow a text field, but that didn't work.
>
>Any ideas?
>
>+++ Rick ---

If you're using MS SQL Server, have you tried the CONVERT() SQL function?
Something like, "SELECT CONVERT(Text, FieldA) ...".

I'm sure other SQL DBMSes have similar functions. HTH!
alistair israel
Distressed DBA, Sleepy SysAd, Weary WebMaster (aka Senior Software Engineer)
aisrael@poboxes.com
Makati City, Philippines
Previous
Reply
Map
View

Click here to load this message in the networking platform