Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo size limit?
Message
 
 
À
16/09/2004 11:47:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00942918
Message ID:
00942988
Vues:
23
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform