• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1888
  • Last Modified:

String is too long to fit in StrToFile

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

0
systematica
Asked:
systematica
  • 2
  • 2
1 Solution
 
pcelbaCommented:
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: http://msdn.microsoft.com/en-us/library/3cc1x337(VS.80).aspx
1
 
LaccaCommented:
Hi.
What is your databade version?
Read the site bellow, maybe you'll find the answer

From: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:525622260411

Regards.
0
 
systematicaAuthor Commented:
It works!! Thanks a lot.
0
 
pcelbaCommented:
I am just curious what it should do to obtain A rating... :-)
0
 
systematicaAuthor Commented:
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.
Sorry
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now