Storing pdf file and retrieving

[charlisolutions]

 Posted by:  charlisolutions 

Hi All,
I am storing a pdf file(file size is 1445 kb) into database and
then retriving that value and writing into other pdf file.when writing it
will store until 680 kb only.i need the size 1445 kb while writing into
other pdf file.Is there any possibility to increase the size?

I am using Centura 1.5.1 and SQL Server2005 and the column data type is
varbinary(max).

Here i have attached that apt file also.

Any suggestion would be greatly appreciated.

Regards
Poongodi

[Jarmo Muukka]

 Posted by:  Jarmo Muukka 

Hi,

Read the whole file into string. Determine the size of file by
SalFileSeek( end ), SalFileTell, SalFileSeek( begin )

Before saving/querying the file set buffer length big enough wit call to
Call SqlSetParameterAll( cursor, DBP_LONGBUFFER, 10000000, STRING_Null,
TRUE ) 10 million bytes in here

HTH,
JMu

[Jim McNamara]

 Posted by:  Jim McNamara 

This line is your problem:

!!CB!! 70
Call SalFileWrite ( hFile, strpdf, 700000 )

700,000 is approx = 680kb

Needs to be large enough to accommodate the file - in this example 1,500,000
should be sufficient. - Better to use Jarmo's method to handle the file size
dynamically.