String is too long to fit in StrToFile

Posted on 2010-11-18
Last Modified: 2012-05-10
Hi experts, I have a "String is too long to fit" error using the StrToFile function.
This is the context:
- I have a BLOB field in an Oracle table (the blob contains a pfd file)
- I do a select to read the field and I get a FoxPro cursor
- I write the content of the blob filed to a file using StrToFile

When the size of the blob is large (20-25 MB) I get the error
Also tried to use fcreate and fwrite but I get the same error

Question by:systematica
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 42

Accepted Solution

pcelba earned 500 total points
ID: 34163046
The maximum string size is about 16 MB in VFP.

To copy a blob field into a file you have to use:

COPY MEMO YourBlob TO YourFile

More into:

Expert Comment

ID: 34163071
What is your databade version?
Read the site bellow, maybe you'll find the answer



Author Closing Comment

ID: 34163794
It works!! Thanks a lot.
LVL 42

Expert Comment

ID: 34164404
I am just curious what it should do to obtain A rating... :-)

Author Comment

ID: 34164586
I'm newbie, I should probably give less points to the demand as the problem was not complex and give an A for the promptness and correctness of the solution.

Featured Post

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: (http://msd…
There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question