Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo size limit?
Message
 
 
To
16/09/2004 11:47:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00942918
Message ID:
00942988
Views:
22
Steve,

This may well be a limitation that is coming from asp or their webserver, perhaps even the client's browser.

Here's proof VFP itself can handle extremely large memos:
lcX = replicate( "0123456789ABCDEF", 512 )
for i = 1 to 11
   lcX = lcX + lcX
endfor
? len( lcX ) && 16mb

strtofile( lcX, "testbigmemo.txt" )
for i = 1 to 15
   strtofile( lcX, "testbigmemo.txt", .t. )
endfor

adir( laFiles, "testbigmemo.txt" )
? laFiles[1,2] && 256mb

create table testbigmemo ( bigmemo m nocptrans )
append blank
append memo bigmemo from testbigmemo.txt
? len( bigmemo ) && 256mb
use
adir( laFiles, "testbigmemo.fpt" )
? laFiles[1,2] && 2m6mb + some

use testbigmemo
insert into testbigmemo ( bigmemo ) values ( lcX )
? len( bigmemo ) && 16mb
>here is the code I traced down.
>
>
<%
>	
>	Local lcFileName, lcDescription, lcFile
>	lcFileName = JustFname(Request.MultiPart("txtFile","filename"))
>	If Empty(m.lcFileName)
>		Return
>	EndIf
>	lcDescription = Request.Form("edtDescription")
>	lcFile = Request.Form("txtFile")
>	Insert into Upload (cFile,cDesc,cData) Values ( ;
>		m.lcFileName, ;
>		m.lcDescription, ;
>		m.lcFile ;
>	)
>	
>  
>
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform